Lines Matching refs:pA

2024     CREATE TABLE pA(x PRIMARY KEY);
2025     CREATE TABLE cA(c REFERENCES pA ON DELETE SET NULL);
2026     CREATE TABLE cB(c REFERENCES pA ON UPDATE SET NULL);
2028     INSERT INTO pA VALUES(X'ABCD');
2029     INSERT INTO pA VALUES(X'1234');
2036     DELETE FROM pA WHERE rowid = 1;
2037     SELECT quote(x) FROM pA;
2047     UPDATE pA SET x = X'8765' WHERE rowid = 2;
2048     SELECT quote(x) FROM pA;
2065     CREATE TABLE pA(x PRIMARY KEY);
2066     CREATE TABLE cA(c DEFAULT X'0000' REFERENCES pA ON DELETE SET DEFAULT);
2067     CREATE TABLE cB(c DEFAULT X'9999' REFERENCES pA ON UPDATE SET DEFAULT);
2069     INSERT INTO pA(rowid, x) VALUES(1, X'0000');
2070     INSERT INTO pA(rowid, x) VALUES(2, X'9999');
2071     INSERT INTO pA(rowid, x) VALUES(3, X'ABCD');
2072     INSERT INTO pA(rowid, x) VALUES(4, X'1234');
2080     DELETE FROM pA WHERE rowid = 3;
2081     SELECT quote(x) FROM pA ORDER BY rowid;
2089     UPDATE pA SET x = X'8765' WHERE rowid = 4;
2090     SELECT quote(x) FROM pA ORDER BY rowid;