Lines Matching refs:p1
129 CREATE TABLE p1(c PRIMARY KEY, d);
130 CREATE TABLE c1(a, b, FOREIGN KEY(a) REFERENCES p1 ON DELETE SET NULL);
131 CREATE TABLE c2(a, b, FOREIGN KEY(a) REFERENCES p1 ON DELETE CASCADE);
132 CREATE TABLE c3(a, b, FOREIGN KEY(a) REFERENCES p1 ON DELETE SET DEFAULT);
134 INSERT INTO p1 VALUES(1, 'one');
135 INSERT INTO p1 VALUES(2, 'two');
136 INSERT INTO p1 VALUES(3, 'three');
137 INSERT INTO p1 VALUES(4, 'four');
145 do_tc_test 3.1.2 { DELETE FROM p1 WHERE c=1; } {9}
146 do_tc_test 3.1.3 { DELETE FROM p1 WHERE c=2; } {11}
147 do_tc_test 3.1.4 { DELETE FROM p1 WHERE c=3; } {13}
148 do_tc_test 3.1.5 { DELETE FROM p1 WHERE c=4; } {14} ; # only 1 this time.
155 CREATE TABLE c1(a, b, FOREIGN KEY(a) REFERENCES p1 ON UPDATE SET NULL);
156 CREATE TABLE c2(a, b, FOREIGN KEY(a) REFERENCES p1 ON UPDATE CASCADE);
157 CREATE TABLE c3(a, b, FOREIGN KEY(a) REFERENCES p1 ON UPDATE SET DEFAULT);
159 INSERT INTO p1 VALUES(1, 'one');
160 INSERT INTO p1 VALUES(2, 'two');
161 INSERT INTO p1 VALUES(3, 'three');
162 INSERT INTO p1 VALUES(4, 'four');
170 do_tc_test 3.1.7 { UPDATE p1 SET c=c+4 WHERE c=1; } {9}
171 do_tc_test 3.1.8 { UPDATE p1 SET c=c+4 WHERE c=2; } {11}
172 do_tc_test 3.1.9 { UPDATE p1 SET c=c+4 WHERE c=3; } {13}
173 do_tc_test 3.1.10 { UPDATE p1 SET c=c+4 WHERE c=4; } {14} ; # only 1 this time.