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)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 19 + 26 = ?

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