Lines Matching refs:p1

144   CREATE TABLE p1(one PRIMARY KEY, two);
146   CREATE TRIGGER tr_ai AFTER INSERT ON p1 BEGIN
149   CREATE TRIGGER tr_bd BEFORE DELETE ON p1 BEGIN
152   CREATE TRIGGER tr_au AFTER UPDATE ON p1 BEGIN
159   INSERT INTO p1 VALUES('a', 'A'), ('b', 'B'), ('c', 'C');
162   UPDATE p1 SET two = two||two;
165   DELETE FROM p1 WHERE one IN ('a', 'c');
173   DELETE FROM p1;
174   INSERT INTO p1 VALUES('a', 'A'), ('b', 'B'), ('c', 'C');
176   CREATE TABLE c1(a, b, FOREIGN KEY(a) REFERENCES p1 ON DELETE SET NULL);
177   CREATE TABLE c2(a, b, FOREIGN KEY(a) REFERENCES p1 ON DELETE SET DEFAULT);
178   CREATE TABLE c3(a, b, FOREIGN KEY(a) REFERENCES p1 ON DELETE CASCADE);
183   INSERT INTO p1 VALUES('d', 'D'), ('e', 'E'), ('f', 'F');
184   CREATE TABLE c4(a, b, FOREIGN KEY(a) REFERENCES p1 ON UPDATE SET NULL);
185   CREATE TABLE c5(a, b, FOREIGN KEY(a) REFERENCES p1 ON UPDATE SET DEFAULT);
186   CREATE TABLE c6(a, b, FOREIGN KEY(a) REFERENCES p1 ON UPDATE CASCADE);
194 do_changes_test 3.2.1 { DELETE FROM p1 WHERE one = 'a' } 1
195 do_changes_test 3.2.2 { DELETE FROM p1 WHERE one = 'b' } 1
196 do_changes_test 3.2.3 { DELETE FROM p1 WHERE one = 'c' } 1
203 do_changes_test 3.2.5 { UPDATE p1 SET one = 'g' WHERE one = 'd' } 1
204 do_changes_test 3.2.6 { UPDATE p1 SET one = 'h' WHERE one = 'e' } 1
205 do_changes_test 3.2.7 { UPDATE p1 SET one = 'i' WHERE one = 'f' } 1