Lines Matching refs:p1

28   1   1 "DELETE FROM p1" {
29     CREATE TABLE p1(a PRIMARY KEY);
30     CREATE TABLE c1(b REFERENCES p1);
33   2.1     0 "DELETE FROM p1" {
34     CREATE TABLE p1(a PRIMARY KEY);
35     CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE);
37   2.2   0 "DELETE FROM p1" {
38     CREATE TABLE p1(a PRIMARY KEY);
39     CREATE TABLE c1(b REFERENCES p1 ON DELETE SET NULL);
41   2.3   1 "DELETE FROM p1" {
42     CREATE TABLE p1(a PRIMARY KEY);
43     CREATE TABLE c1(b REFERENCES p1 ON DELETE SET DEFAULT);
46   3   1 "DELETE FROM p1" {
47     CREATE TABLE p1(a PRIMARY KEY);
48     CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE);
50       INSERT INTO p1 VALUES('x');
54   4   1 "DELETE FROM p1" {
55     CREATE TABLE p1(a PRIMARY KEY);
56     CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
60   5.1   0 "DELETE FROM p1" {
61     CREATE TABLE p1(a PRIMARY KEY);
62     CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
65   5.2   0 "DELETE FROM p1" {
66     CREATE TABLE p1(a PRIMARY KEY);
67     CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
70   5.3   1 "DELETE FROM p1" {
71     CREATE TABLE p1(a PRIMARY KEY);
72     CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE, c PRIMARY KEY);
76   6.1   1 "UPDATE p1 SET a = ?" {
77     CREATE TABLE p1(a PRIMARY KEY);
78     CREATE TABLE c1(b REFERENCES p1 ON UPDATE SET NULL, c);
80   6.2   0 "UPDATE OR IGNORE p1 SET a = ?" {
81     CREATE TABLE p1(a PRIMARY KEY);
82     CREATE TABLE c1(b REFERENCES p1 ON UPDATE SET NULL, c);
84   6.3   1 "UPDATE OR IGNORE p1 SET a = ?" {
85     CREATE TABLE p1(a PRIMARY KEY);
86     CREATE TABLE c1(b REFERENCES p1 ON UPDATE CASCADE, c);
88   6.4   1 "UPDATE OR IGNORE p1 SET a = ?" {
89     CREATE TABLE p1(a PRIMARY KEY);
90     CREATE TABLE c1(b NOT NULL REFERENCES p1 ON UPDATE SET NULL, c);
113   CREATE TABLE p1(a PRIMARY KEY, b) WITHOUT ROWID;
114   CREATE TABLE c1(x REFERENCES p1 DEFERRABLE INITIALLY DEFERRED);
116   INSERT INTO p1 VALUES(1, 'one');
117   INSERT INTO p1 VALUES(2, 'two');
124     DELETE FROM p1 WHERE a=1;
125     INSERT OR REPLACE INTO p1 VALUES(2, 'two');
242   CREATE TABLE aux.p1(a INTEGER PRIMARY KEY);
243   CREATE TABLE aux.c1(b REFERENCES p1(a) ON DELETE RESTRICT);
245   INSERT INTO aux.p1 VALUES(123);
249   DELETE FROM aux.p1 WHERE a=123;