On 10/28/2016 01:42 PM, [email protected] wrote:

I think the value of 'match' should be FULL instead of NONE!


From the docs, "SQLite parses MATCH clauses (i.e. does not report a syntax error if you specify one), but does not enforce them. All foreign key constraints in SQLite are handled as if MATCH SIMPLE were specified".

I think this is the issue you are facing.

--
Bernardo Sulzbach
http://www.mafagafogigante.org/
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to