Bug #1432

limitQuery() unable to return very first record in Oracle DB

Details

Submitted	2004-05-18 16:22 UTC
From	roger at bgnet dot bgsu dot edu
Assigned	danielc
Status	Bogus
Package	DB
PHP Version	4.3.4
OS	Unix
Roadmaps	(Not assigned)

Comments

[2004-05-18 16:22 UTC] roger at bgnet dot bgsu dot edu

Description:
------------
Using limitQuery() to try and grab record 1 through 5 in an Oracle database table. The result is always records 2 thorugh 6. I'm not sure if this is a bug, but someone from the mailing list stated that I may want to report it as one...

Thanks,
Roger

Reproduce code:
---------------
To get records 1 through 5:
$res =& $db->limitQuery("SELECT ID,Name,Rate FROM newRecords ORDER BY st", 1, 5);

Returns records 2 through 6

Tried this also:
$res =& $db->limitQuery("SELECT ID,Name,Rate FROM newRecords ORDER BY st", 0, 5);

Returns no records

Expected result:
----------------
Records 1 through 5

Actual result:
--------------
Records 2 through 6

[2004-05-18 16:40 UTC] roger at bgnet dot bgsu dot edu

How can I tell which version of PEAR is being used? Also, how can I tell which version of DB is being used?

Thanks,
Roger

[2004-05-18 19:14 UTC] roger at bgnet dot bgsu dot edu

DB 1.5.ORC2

PEAR 1.3b3

Not sure what all of that means, but let me know if they are outdated....

Thanks,
Roger

[2004-05-18 19:39 UTC] roger at bgnet dot bgsu dot edu

If I read everything correctly, the latest version is 1.6 something or other. I\'ll update my DB to the newest version...

Thanks,
Roger