Hello !
I'm getting an error that seems to be a bug in sqlite3 or a change of
behavior.
===
CREATE TABLE a(
keyval varchar(25) NOT NULL,
testid integer NOT NULL,
PRIMARY KEY ("keyval","testid")
);
CREATE TABLE b(
sampleid integer NOT NULL,
prodspeckey varchar(25) NOT NULL,
PRIMARY KEY ("sampleid"),
CONSTRAINT "qasamples_ibfk_1" FOREIGN KEY ("prodspeckey")
REFERENCES "a" ("keyval")
);
PRAGMA foreign_key_check;
===
output
===
sqlite3 < bug-fk.sql
Error: near line 14: foreign key mismatch - "b" referencing "a"
===
Cheers !
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
