On 5/7/19, Manuel Rigger <rigger.man...@gmail.com> wrote: > Great, thanks! In which commits were they addressed? I saw two commits that > address https://www.sqlite.org/src/info/e63cbcfd3378afe6980d6. Was this > issue derived from the test case?
Issue 1: Foreign key constraints are not checked until the end of a statement, so the INSERT OR IGNORE needs to act like INSERT OR ABORT when dealing with FK constraints. This will involve a (pending) change to the documentation as well. Check-in https://www.sqlite.org/src/info/659c551dcc374a0d Issue 2: Foreign key constraint checking might cause some elements of an inserted or updated row to change datatypes, which causes the row to be constructed incorrectly. Fixed by check-in https://www.sqlite.org/src/info/3f1c8051648a341d -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users