Bug #1135

SQLite can handle LIMIT, stop exception

Details

Submitted	2004-04-05 06:40 UTC
From	contact at mann dot fr
Status	No Feedback
Package	DB_DataObject
PHP Version	4.3.4
OS	Linux (Debian i586)
Roadmaps	(Not assigned)

Comments

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