| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.3 |
| Bug #1432 | limitQuery() unable to return very first record in Oracle DB | ||
|---|---|---|---|
| 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) | ||
[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
Comments
[2004-05-18 16:28 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[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 16:50 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[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:32 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!