| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.11.5 |
| Bug #1135 | SQLite can handle LIMIT, stop exception | ||
|---|---|---|---|
| Submitted: | 2004-04-05 06:40 UTC | ||
| From: | contact at mann dot fr | Assigned: | |
| Status: | No Feedback | Package: | DB_DataObject |
| PHP Version: | 4.3.4 | OS: | Linux (Debian i586) |
| Roadmaps: | (Not assigned) | ||
[2004-04-05 06:40 UTC] contact at mann dot fr
Description:
------------
SQLite proports to handle LIMIT in select clauses.
DB_DataObject proports to throw an exception is this clause is used on anything but MySQL and PostgreSQL.
Reproduce code:
---------------
Is this a DB issue or a DB_DataObject issue (probably the second).
Bug dependant on bug # 1085
Expected result:
----------------
DB_DataObject show not throw an error on SQLite LIMIT clauses.
The manuel should say that on databases other than MySQL, PostgreSQL and SQLite, it will throw an error (especially on Oracle ;))
Actual result:
--------------
The Manuel throws an error.
Comments
[2004-04-05 07:07 UTC] alan_k
Can you try the latest code for DB_sqlite from CVS
- the code in dataobjects looks like it should work ok with this..