Why I don't get a foreign key constraint error?

Question

Look, I'm expecting to get an "SQL error: foreign key constraint failed" error, but this never happens, can you guys explain why? Working with sqlite3 db on Android.

sqlite> CREATE TABLE first (id text, value text);
sqlite> CREATE TABLE second (id text, ref text, foreign key(ref) references first(value));
sqlite> INSERT INTO first VALUES("1", "one");
sqlite> INSERT INTO first VALUES("2", "two");
sqlite> INSERT INTO second VALUES("1", "three");

So it is perfectly possible to insert "three", but there is no "three" in the first table. I'm confused.

possible duplicate of [How do you enforce foreign key constraints in SQLite through Java?](http://stackoverflow.com/questions/9774923/how-do-you-enforce-foreign-key-constraints-in-sqlite-through-java) — Christoff Erasmus, Sep 09 '13 at 16:51

score 2 · Accepted Answer · answered Aug 22 '13 at 10:48

2

Did you make sure FK support is enabled? http://www.sqlite.org/foreignkeys.html#fk_enable

answered Aug 22 '13 at 10:48

Meldor

236
1
3

Yeah, you're right, I need to enable it manually, thanks a lot. – Eugene Aug 22 '13 at 10:49

Why I don't get a foreign key constraint error?

1 Answers1