FUDforum: Bug Reports » BUGs: LIMIT clause in postgresql

Home » FUDforum Development » Bug Reports » BUGs: LIMIT clause in postgresql

Show: Today's Messages :: Polls :: Message Navigator

BUGs: LIMIT clause in postgresql [message #8039]

Thu, 09 January 2003 03:16

laser

Messages: 9
Registered: January 2003

Karma:

Junior Member

Seems no one use FUDforum with PostgreSQL, and less test in it.
but if you use it with current version of PostgreSQL (7.3.1),
you'll find there are lots of bugs:

first one is the the users table (in fuduser.tbl or something), the CREATE TABLE come with and
extra comma ',' at the end of last line, the consraint, causing installation on PostgreSQL failed.

second one is very big: in PostgreSQL 7.3.1, the "LIMIT #,#" clause are obsolete, you should use "LIMIT # OFFSET #", the later
is SQL standard compliant, but the formal is not. (I think it's
mysql specefic). There are many places with direct hard coded
LIMIT #,# and not using qry_limit() function, cost a few hours to check. Sad

finally, I want to ask how to change the code in install.php directly? those md5() check and LIMIT clause *did* annoying me
while I want do fix those bugs in install.php directly, and failed at last.

any comment?

Report message to a moderator

[Message index]

		BUGs: LIMIT clause in postgresql By: laser on Thu, 09 January 2003 03:16
		Re: BUGs: LIMIT clause in postgresql By: Ilia on Thu, 09 January 2003 03:51
		Re: BUGs: LIMIT clause in postgresql By: laser on Thu, 09 January 2003 05:17
		Re: BUGs: LIMIT clause in postgresql By: Ilia on Thu, 09 January 2003 22:12
		Re: BUGs: LIMIT clause in postgresql By: laser on Fri, 10 January 2003 10:33

Previous Topic:	bad default sql table prefix
Next Topic:	2.3.6 listing bug?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 17 07:35:29 GMT 2025

Total time taken to generate the page: 0.06245 seconds