Lines Matching refs:KEY
93 CREATE TABLE t1(a PRIMARY KEY, b) WITHOUT rowid;
96 CREATE TABLE t3(a PRIMARY KEY, b) WITHOUT rowid;
99 CREATE TABLE t7(a, b INT PRIMARY KEY) WITHOUT rowid;
108 1.1 "INSERT INTO t2 VALUES(1, 3)" {1 {FOREIGN KEY constraint failed}}
111 1.4 "INSERT INTO t2 VALUES(2, 4)" {1 {FOREIGN KEY constraint failed}}
113 1.6 "UPDATE t2 SET c=2 WHERE d=4" {1 {FOREIGN KEY constraint failed}}
117 1.11 "DELETE FROM t1 WHERE a=1" {1 {FOREIGN KEY constraint failed}}
118 1.12 "UPDATE t1 SET a = 2" {1 {FOREIGN KEY constraint failed}}
121 2.1 "INSERT INTO t4 VALUES(1, 3)" {1 {FOREIGN KEY constraint failed}}
125 4.1 "INSERT INTO t8 VALUES(1, 3)" {1 {FOREIGN KEY constraint failed}}
128 4.4 "INSERT INTO t8 VALUES(2, 4)" {1 {FOREIGN KEY constraint failed}}
130 4.6 "UPDATE t8 SET c=2 WHERE d=4" {1 {FOREIGN KEY constraint failed}}
134 4.11 "DELETE FROM t7 WHERE b=1" {1 {FOREIGN KEY constraint failed}}
135 4.12 "UPDATE t7 SET b = 2" {1 {FOREIGN KEY constraint failed}}
137 4.14 "INSERT INTO t8 VALUES('a', 'b')" {1 {FOREIGN KEY constraint failed}}
138 4.15 "UPDATE t7 SET b = 5" {1 {FOREIGN KEY constraint failed}}
209 CREATE TABLE i(i INT PRIMARY KEY) WITHOUT rowid;
218 } {1 {FOREIGN KEY constraint failed}}
234 } {1 {FOREIGN KEY constraint failed}}
240 CREATE TABLE i(i TEXT COLLATE nocase PRIMARY KEY) WITHOUT rowid;
246 } {1 {FOREIGN KEY constraint failed}}
253 CREATE TABLE i(i TEXT PRIMARY KEY) WITHOUT rowid; -- 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) WITHOUT rowid;
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) WITHOUT rowid;
506 CREATE TABLE t1(a PRIMARY KEY, b) WITHOUT rowid;
507 CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1(a)) WITHOUT rowid;
535 # Test that it is possible to use an INT PRIMARY KEY as the child key
541 CREATE TABLE t1(a PRIMARY KEY, b) WITHOUT rowid;
542 CREATE TABLE t2(c INT PRIMARY KEY REFERENCES t1, b) WITHOUT rowid;
547 } {1 {FOREIGN KEY constraint failed}}
560 } {1 {FOREIGN KEY constraint failed}}
563 } {1 {FOREIGN KEY constraint failed}}
569 } {1 {FOREIGN KEY constraint failed}}
603 CREATE TABLE t1(a INT PRIMARY KEY, b) WITHOUT rowid;
605 c INT PRIMARY KEY,
634 } {1 {FOREIGN KEY constraint failed}}
638 CREATE TABLE pp(a, b, c, PRIMARY KEY(b, c)) WITHOUT rowid;
640 FOREIGN KEY(f, d) REFERENCES pp
672 CREATE TABLE p(a PRIMARY KEY, b) WITHOUT rowid;
678 CREATE TABLE p(a, b, PRIMARY KEY(a, b)) WITHOUT rowid;
698 CREATE TABLE t1(a PRIMARY KEY, b) WITHOUT rowid;
699 CREATE TABLE t2(c, d, FOREIGN KEY(rowid) REFERENCES t1(a));
705 CREATE TABLE t1(a PRIMARY KEY, b) WITHOUT rowid;
706 CREATE TABLE t2(rowid, d, FOREIGN KEY(rowid) REFERENCES t1(a));
713 CREATE TABLE t2(c, d, FOREIGN KEY(c) REFERENCES t1(rowid));
721 CREATE TABLE t1(rowid PRIMARY KEY, b) WITHOUT rowid;
722 CREATE TABLE t2(c, d, FOREIGN KEY(c) REFERENCES t1(rowid));
735 CREATE TABLE t1(a INT PRIMARY KEY, b) WITHOUT rowid;
736 CREATE TABLE t2(c, d, FOREIGN KEY(c) REFERENCES t1(a) ON UPDATE CASCADE);
751 CREATE TABLE t1(a, b PRIMARY KEY) WITHOUT rowid;
769 } {1 {FOREIGN KEY constraint failed}}
775 } {1 {FOREIGN KEY constraint failed}}
786 CREATE TABLE t1(x COLLATE NOCASE PRIMARY KEY) WITHOUT rowid;
817 } {1 {FOREIGN KEY constraint failed}}
833 PRIMARY KEY(c34, c35)
840 FOREIGN KEY(c39, c38) REFERENCES up ON UPDATE CASCADE
855 } {1 {FOREIGN KEY constraint failed}}
862 } {1 {FOREIGN KEY constraint failed}}
878 CREATE TABLE pp(a UNIQUE, b, c, PRIMARY KEY(b, c)) WITHOUT rowid;
879 CREATE TABLE cc(d, e, f UNIQUE, FOREIGN KEY(d, e) REFERENCES pp);
889 } {1 {FOREIGN KEY constraint failed}}
899 } {1 {FOREIGN KEY constraint failed}}
922 CREATE TABLE t1(a PRIMARY KEY) WITHOUT rowid;
974 CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1) WITHOUT rowid;
975 CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)
981 {CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1) WITHOUT rowid} \
982 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)
990 {CREATE TABLE "t4"(a PRIMARY KEY, b REFERENCES "t4") WITHOUT rowid} \
991 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES "t4", c REFERENCES t2)
997 } {1 {FOREIGN KEY constraint failed}}
1003 } {1 {FOREIGN KEY constraint failed}}
1017 CREATE TEMP TABLE t1(a PRIMARY KEY) WITHOUT rowid;
1061 CREATE TEMP TABLE t1(a PRIMARY KEY, b REFERENCES t1) WITHOUT rowid;
1062 CREATE TEMP TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)
1068 {CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1) WITHOUT rowid} \
1069 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)
1077 {CREATE TABLE "t4"(a PRIMARY KEY, b REFERENCES "t4") WITHOUT rowid} \
1078 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES "t4", c REFERENCES t2)
1084 } {1 {FOREIGN KEY constraint failed}}
1090 } {1 {FOREIGN KEY constraint failed}}
1105 CREATE TABLE aux.t1(a PRIMARY KEY) WITHOUT rowid;
1149 CREATE TABLE aux.t1(a PRIMARY KEY, b REFERENCES t1) WITHOUT rowid;
1150 CREATE TABLE aux.t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)
1156 {CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1) WITHOUT rowid} \
1157 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES t1, c REFERENCES t2)
1165 {CREATE TABLE "t4"(a PRIMARY KEY, b REFERENCES "t4") WITHOUT rowid} \
1166 {CREATE TABLE t2(a PRIMARY KEY, b REFERENCES "t4", c REFERENCES t2)
1172 } {1 {FOREIGN KEY constraint failed}}
1178 } {1 {FOREIGN KEY constraint failed}}
1196 CREATE TABLE t1(a PRIMARY KEY, b) WITHOUT rowid;
1204 } {1 {FOREIGN KEY constraint failed}}
1216 CREATE TABLE t1(x PRIMARY KEY) WITHOUT rowid;
1223 } {1 {FOREIGN KEY constraint failed}}
1232 CREATE TABLE pp(x, y, PRIMARY KEY(x, y)) WITHOUT ROWID;
1233 CREATE TABLE cc(a, b, FOREIGN KEY(a, b) REFERENCES pp(x, z));
1243 FOREIGN KEY(a, b) REFERENCES pp DEFERRABLE INITIALLY DEFERRED
1251 CREATE TABLE pp(a, b, c, PRIMARY KEY(b, c)) WITHOUT rowid;
1318 CREATE TABLE pp(a PRIMARY KEY, b) WITHOUT rowid;
1366 1 { CREATE TABLE self(a INTEGER PRIMARY KEY, b REFERENCES self(a))
1368 2 { CREATE TABLE self(a PRIMARY KEY, b REFERENCES self(a)) WITHOUT rowid }
1369 3 { CREATE TABLE self(a UNIQUE, b INT PRIMARY KEY REFERENCES self(a))
1383 } {1 {FOREIGN KEY constraint failed}}
1387 } {1 {FOREIGN KEY constraint failed}}
1391 } {1 {FOREIGN KEY constraint failed}}
1402 } {1 {FOREIGN KEY constraint failed}}
1406 # FOREIGN KEY constraints.
1413 PRIMARY KEY (e,c),
1414 FOREIGN KEY (d,f) REFERENCES t1(e,c)
1436 } {1 {FOREIGN KEY constraint failed}}
1442 } {1 {FOREIGN KEY constraint failed}}
1452 PRIMARY KEY (a,b),
1454 FOREIGN KEY (d,f) REFERENCES t1(e,c)
1476 } {1 {FOREIGN KEY constraint failed}}
1482 } {1 {FOREIGN KEY constraint failed}}
1506 CREATE TABLE two(d, e, f, FOREIGN KEY(e, f) REFERENCES one(b, c));
1544 } {1 {FOREIGN KEY constraint failed}}
1558 FOREIGN KEY(h, i) REFERENCES one(b, c) DEFERRABLE INITIALLY DEFERRED
1581 CREATE TABLE high("a'b!" PRIMARY KEY, b) WITHOUT rowid;
1629 CREATE TABLE long(a, b PRIMARY KEY, c) WITHOUT rowid;
1663 CREATE TABLE nought(a, b PRIMARY KEY, c) WITHOUT rowid;
1665 FOREIGN KEY(e) REFERENCES nought(b) ON UPDATE CASCADE
1681 CREATE TABLE one(a INT PRIMARY KEY, b) WITHOUT rowid;
1700 } {1 {FOREIGN KEY constraint failed}}
1709 } {1 {FOREIGN KEY constraint failed}}
1718 CREATE TABLE main(id INT PRIMARY KEY) WITHOUT rowid;
1746 CREATE TABLE pp(a PRIMARY KEY, b) WITHOUT rowid;
1747 CREATE TABLE cc(c PRIMARY KEY, d REFERENCES pp) WITHOUT rowid;
1761 } {1 {FOREIGN KEY constraint failed}}
1772 } {1 {FOREIGN KEY constraint failed}}
1797 } {1 {FOREIGN KEY constraint failed}}
1803 } {1 {FOREIGN KEY constraint failed}}
1813 } {1 {FOREIGN KEY constraint failed}}
1823 } {1 {FOREIGN KEY constraint failed}}
1842 CREATE TABLE t1(a INT PRIMARY KEY, b, c, UNIQUE(b, c)) WITHOUT rowid;
1844 CREATE TABLE t3(g, h, i, FOREIGN KEY (h, i) REFERENCES t1(b, c));
1849 } {1 {FOREIGN KEY constraint failed}}
1861 } {1 {FOREIGN KEY constraint failed}}
1870 } {1 {FOREIGN KEY constraint failed}}
1876 } {1 {FOREIGN KEY constraint failed}}
1896 } {1 {FOREIGN KEY constraint failed}}
1905 } {1 {FOREIGN KEY constraint failed}}
1908 } {1 {FOREIGN KEY constraint failed}}
1914 } {1 {FOREIGN KEY constraint failed}}
1919 CREATE TABLE t1(a INT PRIMARY KEY, b, c, UNIQUE(b, c)) WITHOUT rowid;
1922 FOREIGN KEY (h, i)
1965 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(c, b)) WITHOUT rowid;
1968 FOREIGN KEY (h, i)
2015 CREATE TABLE tdd08(a INTEGER PRIMARY KEY, b) WITHOUT rowid;
2019 CREATE TABLE tdd08_b(w,x,y, FOREIGN KEY(x,y) REFERENCES tdd08(a,b));
2027 } {1 {FOREIGN KEY constraint failed}}
2037 } {1 {FOREIGN KEY constraint failed}}
2042 } {1 {FOREIGN KEY constraint failed}}
2047 } {1 {FOREIGN KEY constraint failed}}
2055 CREATE TABLE tce71(a INTEGER PRIMARY KEY, b) WITHOUT rowid;
2058 CREATE TABLE tce72(w, x, y, FOREIGN KEY(x,y) REFERENCES tce71(a,b));
2068 } {1 {FOREIGN KEY constraint failed}}
2073 } {1 {FOREIGN KEY constraint failed}}
2076 CREATE TABLE tce73(a INTEGER PRIMARY KEY, b, UNIQUE(a,b)) WITHOUT rowid;
2078 CREATE TABLE tce74(w, x, y, FOREIGN KEY(x,y) REFERENCES tce73(a,b));
2088 } {1 {FOREIGN KEY constraint failed}}
2093 } {1 {FOREIGN KEY constraint failed}}
2101 CREATE TABLE t1(a,b,PRIMARY KEY(a,b)) WITHOUT ROWID;
2102 CREATE TABLE t2(a,b,PRIMARY KEY(a,b)) WITHOUT ROWID;