SQLite Forum

Error not given when referencing something that doesn't exist
I tried repeating your example. The insert produced the same "foreign key mismatch" error in the SQLite command shell for version 3.34.0 (exact same date and time, running on Windows in my case), which you claim didn't produce an error. It also produced the same error in an older version I happened to have handy (3.15.2).

Did you perhaps miss the PRAGMA foriegn_keys = ON when running your test with 3.34.0?