#22696 [Csd->Opn]: modifyLimitQuery not compatible with PostgreSQL 7.3

ID: 22696 User updated by: marco at telug dot it Reported By: marco at telug dot it -Status: Closed +Status: Open Bug Type: PEAR related Operating System: Any -PHP Version: 4.3.2RC1 +PHP Version: 4.3.2RC1, 4.3.2rc2 New Comment: > This bug has been fixed in CVS. I know that it is fixed in the CVS, but it should be fixed also in the official stable release, while the bug is still present in PHP 4.3.2rc2, as the tarball of 4.3.2rc2 still ships DB-1.3.tar, which is still affected by this bad bug. This way, my applications based on PHP and PostgreSQL do not run on all providers that run an updated and stable version of PHP and an updated and stable version of PostgreSQL and IMO this is not a minor problem, also because I'm not the sys admin of all servers. OK, the bug is fixed in the CVS, but, please, be kind, fix it also in the official release. > technically this is probably broken for old versions of > postgres now.. No, it is not: "LIMIT #,#" runs only on old versions of PostgreSQL, hence it causes problems; on the contrary, "LIMIT # OFFSET #" runs both on PostgreSQL 7.3 and on older versions (I have already tried on my servers). Hence the bug fix hasn't any side effect. Marco Pratesi Previous Comments: ------------------------------------------------------------------------ [2003-04-12 10:44:49] alan_k@php.net This bug has been fixed in CVS. In case this was a PHP problem, snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. In case this was a documentation problem, the fix will show up soon at http://www.php.net/manual/. In case this was a PHP.net website problem, the change will show up on the PHP.net site and on the mirror sites in short time. Thank you for the report, and for helping us make PHP better. technically this is probably broken for old versions of postgres now.. but I guess thats life.. ------------------------------------------------------------------------ [2003-03-14 04:15:53] marco at telug dot it Description of problem: The method modifyLimitQuery() in DB/pgsql.php does not work with postgresql 7.3, as postgresql 7.3 does not support anymore the syntax "LIMIT #,#". To solve the problem, a patch from the CVS (committed after the PHP 4.3.0 release) is needed: http://cvs.php.net/diff.php/pear/DB/DB/pgsql.php?login=2&r1=1.12&r2=1.13&ty=h Marco Pratesi ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=22696&edit=1