Lines Matching refs:KEY
59 CREATE TABLE p(i PRIMARY KEY);
95 CREATE TABLE p(i PRIMARY KEY);
125 execsql { CREATE TABLE p(i PRIMARY KEY) }
162 CREATE TABLE p(i PRIMARY KEY);
232 } {1 {FOREIGN KEY constraint failed}}
261 # trackartist INTEGER, FOREIGN KEY(trackartist) REFERENCES
267 artistid INTEGER PRIMARY KEY,
274 FOREIGN KEY(trackartist) REFERENCES artist(artistid)
286 } {1 {FOREIGN KEY constraint failed}}
290 } {1 {FOREIGN KEY constraint failed}}
304 } {1 {FOREIGN KEY constraint failed}}
332 } {1 {FOREIGN KEY constraint failed}}
339 } {1 {FOREIGN KEY constraint failed}}
366 {1 {FOREIGN KEY constraint failed}}
417 artistid INTEGER PRIMARY KEY,
424 FOREIGN KEY(trackartist) REFERENCES artist(artistid)
441 artistid INTEGER PRIMARY KEY,
448 FOREIGN KEY(trackartist) REFERENCES artist(artistid)
459 } {1 {FOREIGN KEY constraint failed}}
467 } {1 {FOREIGN KEY constraint failed}}
485 } {1 {FOREIGN KEY constraint failed}}
496 } {1 {FOREIGN KEY constraint failed}}
521 CREATE TABLE par(p PRIMARY KEY);
534 " [lindex {{0 {}} {1 {FOREIGN KEY constraint failed}}} $isError]
563 CREATE TABLE t1(a COLLATE nocase PRIMARY KEY);
578 } {1 {FOREIGN KEY constraint failed}}
581 } {1 {FOREIGN KEY constraint failed}}
595 CREATE TABLE t1(a NUMERIC PRIMARY KEY);
613 } {1 {FOREIGN KEY constraint failed}}
620 # A parent key must be either a PRIMARY KEY, subject to a UNIQUE
628 # Also test that if a parent key is not subject to a PRIMARY KEY or UNIQUE
651 test_efkey_57 2 0 { CREATE TABLE t1(x PRIMARY KEY) }
659 test_efkey_57 7 1 { CREATE TABLE t1(x, y, PRIMARY KEY(x, y)) }
696 CREATE TABLE parent(a PRIMARY KEY, b UNIQUE, c, d, e, f);
703 CREATE TABLE child3(j, k, FOREIGN KEY(j, k) REFERENCES parent(c, d)); -- Ok
706 CREATE TABLE child6(p, q, FOREIGN KEY(p,q) REFERENCES parent(b, c)); -- Err
764 CREATE TABLE c2(c, d, FOREIGN KEY(c, d) REFERENCES p2(a, x));
766 CREATE TABLE p3(a PRIMARY KEY, b);
769 CREATE TABLE p4(a PRIMARY KEY, b);
773 CREATE TABLE p5(a PRIMARY KEY, b COLLATE nocase);
777 CREATE TABLE p6(a PRIMARY KEY, b);
778 CREATE TABLE c6(c, d, FOREIGN KEY(c, d) REFERENCES p6);
780 CREATE TABLE p7(a, b, PRIMARY KEY(a, b));
827 CREATE TABLE parent2(a, b, PRIMARY KEY(a,b));
829 CREATE TABLE child8(x, y, FOREIGN KEY(x,y) REFERENCES parent2); -- Ok
831 CREATE TABLE child10(x,y,z, FOREIGN KEY(x,y,z) REFERENCES parent2); -- Err
882 "CREATE TABLE child1(a, b, FOREIGN KEY(a, b) REFERENCES p(c))"
884 "CREATE TABLE child2(a, b, FOREIGN KEY(a, b) REFERENCES p(c, d, e))"
886 "CREATE TABLE child2(a, b, FOREIGN KEY(a, c) REFERENCES p(c, d))"
888 "CREATE TABLE child2(a, b, FOREIGN KEY(c, b) REFERENCES p(c, d))"
908 CREATE TABLE p1(a, b, PRIMARY KEY(a, b));
909 CREATE TABLE p2(a, b PRIMARY KEY);
910 CREATE TABLE c1(c, d, FOREIGN KEY(c, d) REFERENCES p1);
917 " [lindex {{0 {}} {1 {FOREIGN KEY constraint failed}}} $isError]
944 CREATE TABLE c1(a, b, FOREIGN KEY(a, b) REFERENCES parent(x, y));
945 CREATE TABLE c2(a, b, FOREIGN KEY(a, b) REFERENCES parent(x, y));
946 CREATE TABLE c3(a, b, FOREIGN KEY(a, b) REFERENCES parent(x, y));
954 " [lindex {{0 {}} {1 {FOREIGN KEY constraint failed}}} $isError]
979 artistid INTEGER PRIMARY KEY,
986 FOREIGN KEY(trackartist) REFERENCES artist(artistid)
1019 } {1 1 {FOREIGN KEY constraint failed}}
1031 } {2 1 {FOREIGN KEY constraint failed}}
1061 CREATE TABLE child(a, b, FOREIGN KEY(a, b) REFERENCES parent(x, y))
1064 CREATE TABLE child(a, b, FOREIGN KEY(a, b) REFERENCES parent(x, y));
1068 CREATE TABLE child(a, b, FOREIGN KEY(a, b) REFERENCES parent(x, y));
1103 artistid INTEGER PRIMARY KEY,
1147 3 "CREATE TABLE c(jj, FOREIGN KEY(jj) REFERENCES p(x, y))"
1150 4 "CREATE TABLE c(jj, FOREIGN KEY(jj) REFERENCES p())"
1153 5 "CREATE TABLE c(ii, jj, FOREIGN KEY(jj, ii) REFERENCES p())"
1156 6 "CREATE TABLE c(ii, jj, FOREIGN KEY(jj, ii) REFERENCES p(x))"
1159 7 "CREATE TABLE c(ii, jj, FOREIGN KEY(jj, ii) REFERENCES p(x,y,z))"
1168 CREATE TABLE p(x PRIMARY KEY);
1169 CREATE TABLE c(a, b, FOREIGN KEY(a,b) REFERENCES p);
1176 CREATE TABLE p(x, y, PRIMARY KEY(x,y));
1195 PRIMARY KEY(albumartist, albumname)
1202 FOREIGN KEY(songartist, songalbum) REFERENCES album(albumartist,albumname)
1219 } {1 {FOREIGN KEY constraint failed}}
1252 CREATE TABLE king(a, b, PRIMARY KEY(a));
1260 } {1 {FOREIGN KEY constraint failed}}
1285 } {1 {FOREIGN KEY constraint failed}}
1316 " [lindex {{0 {}} {1 {FOREIGN KEY constraint failed}}} $isError]
1321 CREATE TABLE ll(k PRIMARY KEY);
1347 " [lindex {{0 {}} {1 {FOREIGN KEY constraint failed}}} $isError]
1354 FOREIGN KEY(a, b) REFERENCES parent(x, y) DEFERRABLE INITIALLY DEFERRED
1394 CREATE TABLE parent(x, y, z, PRIMARY KEY(x,y,z));
1396 FOREIGN KEY(a, b, c) REFERENCES parent NOT DEFERRABLE INITIALLY DEFERRED
1399 FOREIGN KEY(a, b, c) REFERENCES parent NOT DEFERRABLE INITIALLY IMMEDIATE
1402 FOREIGN KEY(a, b, c) REFERENCES parent NOT DEFERRABLE
1405 FOREIGN KEY(a, b, c) REFERENCES parent DEFERRABLE INITIALLY IMMEDIATE
1408 FOREIGN KEY(a, b, c) REFERENCES parent DEFERRABLE
1410 CREATE TABLE c6(a, b, c, FOREIGN KEY(a, b, c) REFERENCES parent);
1414 FOREIGN KEY(a, b, c) REFERENCES parent DEFERRABLE INITIALLY DEFERRED
1437 lindex {{0 {}} {1 {FOREIGN KEY constraint failed}}} $isError
1495 artistid INTEGER PRIMARY KEY,
1511 } {1 {FOREIGN KEY constraint failed}}
1530 CREATE TABLE t1(a PRIMARY KEY,
1548 } {1 {FOREIGN KEY constraint failed}}
1578 } {1 {FOREIGN KEY constraint failed}}
1595 } {1 {FOREIGN KEY constraint failed}}
1626 } {1 {FOREIGN KEY constraint failed}}
1647 } {1 {FOREIGN KEY constraint failed}}
1651 } {1 {FOREIGN KEY constraint failed}}
1681 CREATE TABLE p(a, b PRIMARY KEY, c);
1733 CREATE TABLE parent(x PRIMARY KEY, y);
1779 CREATE TABLE parent(p1, p2, PRIMARY KEY(p1, p2));
1781 FOREIGN KEY(c1, c2) REFERENCES parent
1802 } {1 {FOREIGN KEY constraint failed}}
1823 FOREIGN KEY(c2, c1) REFERENCES parent(p1, p2) ON DELETE RESTRICT
1826 FOREIGN KEY(c2, c1) REFERENCES parent(p1, p2) ON UPDATE RESTRICT
1840 } {1 {FOREIGN KEY constraint failed}}
1843 } {1 {FOREIGN KEY constraint failed}}
1860 CREATE TABLE parent(x PRIMARY KEY);
1877 } {1 {FOREIGN KEY constraint failed}}
1888 CREATE TABLE parent(x PRIMARY KEY);
1905 } {1 {FOREIGN KEY constraint failed}}
1916 CREATE TABLE parent(x PRIMARY KEY);
1928 } {1 {FOREIGN KEY constraint failed}}
1947 CREATE TABLE parent(x PRIMARY KEY);
1964 } {1 {FOREIGN KEY constraint failed}}
1970 } {1 {FOREIGN KEY constraint failed}}
1981 CREATE TABLE parent(x PRIMARY KEY);
1998 } {1 {FOREIGN KEY constraint failed}}
2004 } {1 {FOREIGN KEY constraint failed}}
2024 CREATE TABLE pA(x PRIMARY KEY);
2065 CREATE TABLE pA(x PRIMARY KEY);
2194 artistid INTEGER PRIMARY KEY,
2234 CREATE TABLE parent(a COLLATE nocase, b, c, PRIMARY KEY(c, a));
2236 FOREIGN KEY(f, d) REFERENCES parent ON UPDATE SET DEFAULT
2260 } {1 {FOREIGN KEY constraint failed}}
2281 artistid INTEGER PRIMARY KEY,
2295 } {1 {FOREIGN KEY constraint failed}}
2327 CREATE TABLE parent(x PRIMARY KEY);
2374 CREATE TABLE zeus(a INTEGER COLLATE NOCASE, b, PRIMARY KEY(a, b));
2376 FOREIGN KEY(c, d) REFERENCES zeus ON UPDATE CASCADE
2428 CREATE TABLE parent(x PRIMARY KEY);
2460 # collectively bound by a PRIMARY KEY or UNIQUE constraint.
2477 3 "CREATE TABLE t1(a, b, FOREIGN KEY(a,b) REFERENCES t1)" {0 {}}
2478 4 "CREATE TABLE t1(a, b, FOREIGN KEY(a,b) REFERENCES t2)" {0 {}}
2479 5 "CREATE TABLE t1(a, b, FOREIGN KEY(a,b) REFERENCES t2)" {0 {}}
2480 6 "CREATE TABLE t1(a, b, FOREIGN KEY(a,b) REFERENCES t2(n,d))" {0 {}}
2481 7 "CREATE TABLE t1(a, b, FOREIGN KEY(a,b) REFERENCES t1(a,b))" {0 {}}
2483 A "CREATE TABLE t1(a, b, FOREIGN KEY(c,b) REFERENCES t2)"
2485 B "CREATE TABLE t1(a, b, FOREIGN KEY(c,b) REFERENCES t2(d))"
2541 CREATE TABLE 'p 1 "parent one"'(a REFERENCES 'p 1 "parent one"', b, PRIMARY KEY(b));
2544 CREATE TABLE c2(e, f, FOREIGN KEY(f) REFERENCES 'p 1 "parent one"' ON UPDATE CASCADE);
2545 …CREATE TABLE c3(e, 'f col 2', FOREIGN KEY('f col 2') REFERENCES 'p 1 "parent one"' ON UPDATE CASCA…
2552 -- CREATE TABLE q(a, b, PRIMARY KEY(b));
2570 {CREATE TABLE "p"(a REFERENCES "p", b, PRIMARY KEY(b))} \
2572 {CREATE TABLE c2(e, f, FOREIGN KEY(f) REFERENCES "p" ON UPDATE CASCADE)} \
2573 {CREATE TABLE c3(e, 'f col 2', FOREIGN KEY('f col 2') REFERENCES "p" ON UPDATE CASCADE)} \
2592 CREATE TABLE p(a, b, PRIMARY KEY(a, b));
2594 CREATE TABLE c1(c, d, FOREIGN KEY(c, d) REFERENCES p ON DELETE SET NULL);
2595 CREATE TABLE c2(c, d, FOREIGN KEY(c, d) REFERENCES p ON DELETE SET DEFAULT);
2596 CREATE TABLE c3(c, d, FOREIGN KEY(c, d) REFERENCES p ON DELETE CASCADE);
2597 CREATE TABLE c4(c, d, FOREIGN KEY(c, d) REFERENCES p ON DELETE RESTRICT);
2598 CREATE TABLE c5(c, d, FOREIGN KEY(c, d) REFERENCES p ON DELETE NO ACTION);
2601 FOREIGN KEY(c, d) REFERENCES p ON DELETE RESTRICT
2605 FOREIGN KEY(c, d) REFERENCES p ON DELETE NO ACTION
2663 } {1 {FOREIGN KEY constraint failed}}
2672 } {1 {FOREIGN KEY constraint failed}}
2706 } {1 {FOREIGN KEY constraint failed}}
2708 execsql { CREATE TABLE p(a, b, PRIMARY KEY(a, b)) }
2710 } {1 {FOREIGN KEY constraint failed}}
2728 CREATE TABLE p(a PRIMARY KEY, b REFERENCES nosuchtable);
2729 CREATE TABLE c1(c, d, FOREIGN KEY(c, d) REFERENCES a);
2752 execsql { CREATE TABLE nosuchtable(x PRIMARY KEY) }
2858 CREATE TABLE p(a, b, c, PRIMARY KEY(b, c));
2859 CREATE TABLE c(d, e, f, FOREIGN KEY(e, f) REFERENCES p MATCH $zMatch);
2877 } {1 {FOREIGN KEY constraint failed}}
2897 CREATE TABLE p(a, b, PRIMARY KEY(a, b));
2899 FOREIGN KEY(c, d) REFERENCES p DEFERRABLE INITIALLY DEFERRED);
2901 FOREIGN KEY(c, d) REFERENCES p DEFERRABLE INITIALLY IMMEDIATE);
2907 } {1 {FOREIGN KEY constraint failed}}
2913 } {1 {FOREIGN KEY constraint failed}}
2935 CREATE TABLE t0(a PRIMARY KEY, b);
2941 a PRIMARY KEY, b REFERENCES t[expr $i-1] ON DELETE CASCADE
2956 CREATE TABLE t0(a PRIMARY KEY);
2963 CREATE TABLE t$i (a PRIMARY KEY REFERENCES t$j ON UPDATE CASCADE);
3027 CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1 ON DELETE CASCADE);