Arch Linux

Description:

Sqlite3 seems to be not compiled with support for UPDATE and DELETE statement with "LIMIT" clause support. It would be nice if this could be included in the default available package, as it is not supported at present.

More information can be found here:
http://www.sqlite.org/lang_update.html

Please search on that page for:
"Optional LIMIT and ORDER BY Clauses"

"""
If SQLite is built with the SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option then the syntax of the UPDATE statement is extended with optional ORDER BY and LIMIT clauses as follows:

update-stmt-limited:.....
"""

Additional info:
* sqlite 3.16.2-1


Steps to reproduce:
Open a database with sqlite, create a table with two columns of a name and one data entry.
Update the column using "UPDATE table SET data=value WHERE name='test' LIMIT 0,1;"
The LIMIT will raise an sql error.

Alternative way to reproduce:
Im writing an application which makes use of this functionality.
It can be found at https://github.com/jrie/kisslib which has a screen on first application startup. After canceling the window, there is a "near LIMIT syntax error" of sqlite written to the terminal/error output.
Expected behavior would be to update the database and after reopening the application, the dialog is not shown anymore, and the database got updated correctly.