Lines Matching refs:KEY
92 CREATE TABLE t1(a PRIMARY KEY, b);
95 CREATE TABLE t3(a PRIMARY KEY, b);
98 CREATE TABLE t7(a, b INTEGER PRIMARY KEY);
107 1.1 "INSERT INTO t2 VALUES(1, 3)" {1 {FOREIGN KEY constraint failed}}
110 1.4 "INSERT INTO t2 VALUES(2, 4)" {1 {FOREIGN KEY constraint failed}}
112 1.6 "UPDATE t2 SET c=2 WHERE d=4" {1 {FOREIGN KEY constraint failed}}
116 1.11 "DELETE FROM t1 WHERE a=1" {1 {FOREIGN KEY constraint failed}}
117 1.12 "UPDATE t1 SET a = 2" {1 {FOREIGN KEY constraint failed}}
120 2.1 "INSERT INTO t4 VALUES(1, 3)" {1 {FOREIGN KEY constraint failed}}
124 4.1 "INSERT INTO t8 VALUES(1, 3)" {1 {FOREIGN KEY constraint failed}}
127 4.4 "INSERT INTO t8 VALUES(2, 4)" {1 {FOREIGN KEY constraint failed}}
129 4.6 "UPDATE t8 SET c=2 WHERE d=4" {1 {FOREIGN KEY constraint failed}}
133 4.11 "DELETE FROM t7 WHERE b=1" {1 {FOREIGN KEY constraint failed}}
134 4.12 "UPDATE t7 SET b = 2" {1 {FOREIGN KEY constraint failed}}
136 4.14 "INSERT INTO t8 VALUES('a', 'b')" {1 {FOREIGN KEY constraint failed}}
137 4.15 "UPDATE t7 SET b = 5" {1 {FOREIGN KEY constraint failed}}
138 4.16 "UPDATE t7 SET rowid = 5" {1 {FOREIGN KEY constraint failed}}
209 CREATE TABLE i(i INTEGER PRIMARY KEY);
218 } {1 {FOREIGN KEY constraint failed}}
234 } {1 {FOREIGN KEY constraint failed}}
240 CREATE TABLE i(i TEXT COLLATE nocase PRIMARY KEY);
246 } {1 {FOREIGN KEY constraint failed}}
253 CREATE TABLE i(i TEXT PRIMARY KEY); -- Colseq is "BINARY"
258 } {1 {FOREIGN KEY constraint failed}}
266 } {1 {FOREIGN KEY constraint failed}}
274 set expected {1 {FOREIGN KEY constraint failed}}
282 } {1 {FOREIGN KEY constraint failed}}
288 nodeid PRIMARY KEY,
292 cellid PRIMARY KEY,
400 CREATE TABLE ab(a PRIMARY KEY, b);
402 c PRIMARY KEY REFERENCES ab ON UPDATE CASCADE ON DELETE CASCADE,
436 } {1 {FOREIGN KEY constraint failed}}
450 node PRIMARY KEY,
453 CREATE TABLE t2(node PRIMARY KEY, parent);
506 CREATE TABLE t1(a PRIMARY KEY, b);
507 CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1(a));
546 # Test that it is possible to use an INTEGER PRIMARY KEY as the child key
552 CREATE TABLE t1(a PRIMARY KEY, b);
553 CREATE TABLE t2(c INTEGER PRIMARY KEY REFERENCES t1, b);
558 } {1 {FOREIGN KEY constraint failed}}
571 } {1 {FOREIGN KEY constraint failed}}
574 } {1 {FOREIGN KEY constraint failed}}
580 } {1 {FOREIGN KEY constraint failed}}
583 } {1 {FOREIGN KEY constraint failed}}
617 CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
619 c INTEGER PRIMARY KEY,
648 } {1 {FOREIGN KEY constraint failed}}
652 CREATE TABLE pp(a, b, c, PRIMARY KEY(b, c));
654 FOREIGN KEY(f, d) REFERENCES pp
680 CREATE TABLE t3(x PRIMARY KEY REFERENCES t3 ON DELETE SET NULL);
691 CREATE TABLE p(a PRIMARY KEY, b);
697 CREATE TABLE p(a, b, PRIMARY KEY(a, b));
717 CREATE TABLE t1(a PRIMARY KEY, b);
718 CREATE TABLE t2(c, d, FOREIGN KEY(rowid) REFERENCES t1(a));
724 CREATE TABLE t1(a PRIMARY KEY, b);
725 CREATE TABLE t2(rowid, d, FOREIGN KEY(rowid) REFERENCES t1(a));
732 CREATE TABLE t2(c, d, FOREIGN KEY(c) REFERENCES t1(rowid));
740 CREATE TABLE t1(rowid PRIMARY KEY, b);
741 CREATE TABLE t2(c, d, FOREIGN KEY(c) REFERENCES t1(rowid));
754 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, rowid, _rowid_, oid);
755 CREATE TABLE t2(c, d, FOREIGN KEY(c) REFERENCES t1(a) ON UPDATE CASCADE);
770 CREATE TABLE t1(a, b PRIMARY KEY);
788 } {1 {FOREIGN KEY constraint failed}}
794 } {1 {FOREIGN KEY constraint failed}}
805 CREATE TABLE t1(x COLLATE NOCASE PRIMARY KEY);
836 } {1 {FOREIGN KEY constraint failed}}
852 PRIMARY KEY(c34, c35)
859 FOREIGN KEY(c39, c38) REFERENCES up ON UPDATE CASCADE
874 } {1 {FOREIGN KEY constraint failed}}
881 } {1 {FOREIGN KEY constraint failed}}
897 CREATE TABLE pp(a UNIQUE, b, c, PRIMARY KEY(b, c));
898 CREATE TABLE cc(d, e, f UNIQUE, FOREIGN KEY(d, e) REFERENCES pp);
909 } {1 {FOREIGN KEY constraint failed}}
919 } {1 {FOREIGN KEY constraint failed}}
956 CREATE TABLE t1(a PRIMARY KEY);
1008 CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1);
1009 CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2);
1014 {CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1)} \
1015 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)} \
1022 {CREATE TABLE "t4"(a PRIMARY KEY, b REFERENCES "t4")} \
1023 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES "t4", c REFERENCES t2)} \
1028 } {1 {FOREIGN KEY constraint failed}}
1034 } {1 {FOREIGN KEY constraint failed}}
1048 CREATE TEMP TABLE t1(a PRIMARY KEY);
1092 CREATE TEMP TABLE t1(a PRIMARY KEY, b REFERENCES t1);
1093 CREATE TEMP TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2);
1098 {CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1)} \
1099 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)} \
1106 {CREATE TABLE "t4"(a PRIMARY KEY, b REFERENCES "t4")} \
1107 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES "t4", c REFERENCES t2)} \
1112 } {1 {FOREIGN KEY constraint failed}}
1118 } {1 {FOREIGN KEY constraint failed}}
1133 CREATE TABLE aux.t1(a PRIMARY KEY);
1177 CREATE TABLE aux.t1(a PRIMARY KEY, b REFERENCES t1);
1178 CREATE TABLE aux.t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2);
1183 {CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1)} \
1184 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)} \
1191 {CREATE TABLE "t4"(a PRIMARY KEY, b REFERENCES "t4")} \
1192 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES "t4", c REFERENCES t2)} \
1197 } {1 {FOREIGN KEY constraint failed}}
1203 } {1 {FOREIGN KEY constraint failed}}
1221 CREATE TABLE t1(a PRIMARY KEY, b);
1229 } {1 {FOREIGN KEY constraint failed}}
1241 CREATE TABLE t1(x PRIMARY KEY);
1248 } {1 {FOREIGN KEY constraint failed}}
1257 CREATE TABLE pp(x, y, PRIMARY KEY(x, y));
1258 CREATE TABLE cc(a, b, FOREIGN KEY(a, b) REFERENCES pp(x, z));
1268 FOREIGN KEY(a, b) REFERENCES pp DEFERRABLE INITIALLY DEFERRED
1276 CREATE TABLE pp(a, b, c, PRIMARY KEY(b, c));
1343 CREATE TABLE pp(a PRIMARY KEY, b);
1391 1 { CREATE TABLE self(a INTEGER PRIMARY KEY, b REFERENCES self(a)) }
1392 2 { CREATE TABLE self(a PRIMARY KEY, b REFERENCES self(a)) }
1393 3 { CREATE TABLE self(a UNIQUE, b INTEGER PRIMARY KEY REFERENCES self(a)) }
1406 } {1 {FOREIGN KEY constraint failed}}
1410 } {1 {FOREIGN KEY constraint failed}}
1414 } {1 {FOREIGN KEY constraint failed}}
1425 } {1 {FOREIGN KEY constraint failed}}
1444 CREATE TABLE two(d, e, f, FOREIGN KEY(e, f) REFERENCES one(b, c));
1482 } {1 {FOREIGN KEY constraint failed}}
1496 FOREIGN KEY(h, i) REFERENCES one(b, c) DEFERRABLE INITIALLY DEFERRED
1519 CREATE TABLE high("a'b!" PRIMARY KEY, b);
1567 CREATE TABLE long(a, b PRIMARY KEY, c);
1601 CREATE TABLE nought(a, b PRIMARY KEY, c);
1603 FOREIGN KEY(e) REFERENCES nought(b) ON UPDATE CASCADE
1619 CREATE TABLE one(a INTEGER PRIMARY KEY, b);
1638 } {1 {FOREIGN KEY constraint failed}}
1647 } {1 {FOREIGN KEY constraint failed}}
1656 CREATE TABLE main(id INTEGER PRIMARY KEY);
1684 CREATE TABLE pp(a PRIMARY KEY, b);
1685 CREATE TABLE cc(c PRIMARY KEY, d REFERENCES pp);
1699 } {1 {FOREIGN KEY constraint failed}}
1710 } {1 {FOREIGN KEY constraint failed}}
1735 } {1 {FOREIGN KEY constraint failed}}
1741 } {1 {FOREIGN KEY constraint failed}}
1751 } {1 {FOREIGN KEY constraint failed}}
1761 } {1 {FOREIGN KEY constraint failed}}
1780 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(b, c));
1782 CREATE TABLE t3(g, h, i, FOREIGN KEY (h, i) REFERENCES t1(b, c));
1787 } {1 {FOREIGN KEY constraint failed}}
1799 } {1 {FOREIGN KEY constraint failed}}
1808 } {1 {FOREIGN KEY constraint failed}}
1814 } {1 {FOREIGN KEY constraint failed}}
1834 } {1 {FOREIGN KEY constraint failed}}
1843 } {1 {FOREIGN KEY constraint failed}}
1846 } {1 {FOREIGN KEY constraint failed}}
1852 } {1 {FOREIGN KEY constraint failed}}
1857 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(b, c));
1860 FOREIGN KEY (h, i)
1903 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(c, b));
1906 FOREIGN KEY (h, i)
1953 CREATE TABLE tdd08(a INTEGER PRIMARY KEY, b);
1957 CREATE TABLE tdd08_b(w,x,y, FOREIGN KEY(x,y) REFERENCES tdd08(a,b));
1965 } {1 {FOREIGN KEY constraint failed}}
1975 } {1 {FOREIGN KEY constraint failed}}
1980 } {1 {FOREIGN KEY constraint failed}}
1985 } {1 {FOREIGN KEY constraint failed}}
1993 CREATE TABLE tce71(a INTEGER PRIMARY KEY, b);
1996 CREATE TABLE tce72(w, x, y, FOREIGN KEY(x,y) REFERENCES tce71(a,b));
2006 } {1 {FOREIGN KEY constraint failed}}
2011 } {1 {FOREIGN KEY constraint failed}}
2014 CREATE TABLE tce73(a INTEGER PRIMARY KEY, b, UNIQUE(a,b));
2016 CREATE TABLE tce74(w, x, y, FOREIGN KEY(x,y) REFERENCES tce73(a,b));
2026 } {1 {FOREIGN KEY constraint failed}}
2031 } {1 {FOREIGN KEY constraint failed}}
2040 CREATE TABLE t1(x PRIMARY KEY);