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.


 [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..