Posted by dave at 16:35 on Wednesday 26th August 2026[link]
observation: the default update string includes the "LIMIT 1" clause, which is a syntax error. Removing limit removes error, so that updates proceed.
from the doc: the [UPDATE ... LIMIT] feature is disabled by default in standard builds. If you try to run an UPDATE ... LIMIT query on a default installation, SQLite returns a syntax error.
suggestion: since limit is NOT default in standard SQLite, it should NOT be default in the editor.
You're welcome!
Posted by Richard at 19:44 on Wednesday 26th August 2026[link]
Hi Dave,
Coming from having used MySQL exclusively for 20 years I had no idea that a LIMIT clause on an update query was non-standard SQL.
Hmm. That's a fly in the ointment isn't it? I'll change the default update though - thanks for letting me know.