20109 – PEAR's DB abstraction layer for PostgreSQL broken: 'LIMIT #,#' should become 'LIMIT # OFFSET #'

Bug 20109 - PEAR's DB abstraction layer for PostgreSQL broken: 'LIMIT #,#' should become 'LIMIT # OFFSET #'

Summary: PEAR's DB abstraction layer for PostgreSQL broken: 'LIMIT #,#' should become...

Status:	RESOLVED NEEDINFO

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	[OLD] Development (show other bugs)
Hardware:	All All

Importance:	High major (vote)
Assignee:	Masatomo Nakano (RETIRED)

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2003-04-28 11:54 UTC by Dries Buytaert
Modified:	2007-09-22 23:12 UTC (History)
CC List:	1 user (show)

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Dries Buytaert 2003-04-28 11:54:21 UTC

PostgreSQL no longer supports the use of 'LIMIT #,#' in SQL queries.  The PostgreSQL backend for the PEAR database abstraction layer needs to be updated to this extend.  Gentoo installs PostgreSQL 7.3.2 (at the time of this writing).  As such, this might break many PHP applications.  As a quick fix, change the function 'modifyLimitQuery' of '/usr/lib/php/DB/pgsql.php':

  $query = $query . " LIMIT $count OFFSET $from";

Reproducible: Always
Steps to Reproduce:

1.
2.
3.

Comment 1 Heinrich Wendel (RETIRED) gentoo-dev

2004-03-15 11:52:46 UTC

is this bug still valid?

Comment 2 Robin Johnson archtester

2004-07-04 16:21:49 UTC

no response from user, closing bug.