Hi,
when enabling foreign_keys via
PRAGMA foreign_keys=ON;
multi row inserts fail when having a foreign key and adding a value as
well as the reference in a transaction fails as well.
Example is attached.
Fails for me on
SQLite 3.8.2 2013-12-06 14:53:30 27392118af4c38c5203a04b8013e1afdb1cebd0d
on Ubuntu 1404/x86_64 (from apt)
as well as
SQLite 3.8.6 2014-07-24 23:23:26 114dcf33670fd98a1ebbac0e44f66b2d8bcccddf
(current amalgamation compiled with
gcc -o sqlite3 sqlite3.c shell.c -ldl -lpthread)
MfG
Markus
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
