On Wed Jun 20, 2018 at 05:26:19PM -0400, Richard Hipp wrote: > On 6/20/18, Jonathan Koren <jdko...@gmail.com> wrote: > > > > The grammar & documentation > > <https://www.sqlite.org/draft/lang_UPSERT.html> shows a WHERE > > clause can be given in the "conflict target" of the UPSERT, but the > > documentation does not explain how the result of this clause > > impacts the statement. As a test, I tried the following: > > The WHERE clause on the conflict-target is only used for partial > indexes.
It would be useful and sensible for SQLite to complain loudly when it parses a query with a conflict target that doesn't exactly match a known constraint. Otherwise it is clearly easy for authors to write legal but misleading queries with actions quite different to the obvious intention. -- Mark Lawrence _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
