invalid LIMIT for Postgres

nezroy - September 16, 2008 - 17:59
Project:Image FUpload
Version:6.x-3.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

On line 101 of image_fupload.module, there is an SQL statement with a LIMIT #, # format. This format is not supported by Postgres. A simple "LIMIT 1" is supported, however, and seems to be how limits are handled elsewhere in the code.

#1

nezroy - September 16, 2008 - 18:03

Also, for that matter, on line 121, Postgres does not currently support LIMIT on UPDATE/DELETE SQL.

#2

grandcat - September 17, 2008 - 12:43

OK, I will probably fix it, but you could provide a patch ;)

#3

grandcat - September 18, 2008 - 18:00
Version:6.x-1.1-rc1» 6.x-3.x-dev
Status:active» fixed

Should be fixed in CVS Head now.

#4

Anonymous (not verified) - October 2, 2008 - 18:12
Status:fixed» closed

Automatically closed -- issue fixed for two weeks with no activity.

 
 

Drupal is a registered trademark of Dries Buytaert.