Lines Matching refs:pp

652     CREATE TABLE pp(a, b, c, PRIMARY KEY(b, c));
654         FOREIGN KEY(f, d) REFERENCES pp 
658     INSERT INTO pp VALUES(1, 2, 3);
659     INSERT INTO pp VALUES(4, 5, 6);
660     INSERT INTO pp VALUES(7, 8, 9);
669     UPDATE pp SET b = 1 WHERE a = 7;
675     DELETE FROM pp WHERE a = 4;
897     CREATE TABLE pp(a UNIQUE, b, c, PRIMARY KEY(b, c));
898     CREATE TABLE cc(d, e, f UNIQUE, FOREIGN KEY(d, e) REFERENCES pp);
899     INSERT INTO pp VALUES(1, 2, 3);
904   1   "REPLACE INTO pp VALUES(1, 4, 5)"
905   2   "REPLACE INTO pp(rowid, a, b, c) VALUES(1, 2, 3, 4)"
912       SELECT * FROM pp;
923       SELECT * FROM pp;
930     REPLACE INTO pp(rowid, a, b, c) VALUES(1, 2, 2, 3);
931     SELECT rowid, * FROM pp;
937     REPLACE INTO pp(rowid, a, b, c) VALUES(2, 2, 2, 3);
938     SELECT rowid, * FROM pp;
1257     CREATE TABLE pp(x, y, PRIMARY KEY(x, y));
1258     CREATE TABLE cc(a, b, FOREIGN KEY(a, b) REFERENCES pp(x, z));
1261 } {1 {foreign key mismatch - "cc" referencing "pp"}}
1268       FOREIGN KEY(a, b) REFERENCES pp DEFERRABLE INITIALLY DEFERRED
1272     INSERT INTO pp VALUES('a', 'b');
1275       DROP TABLE pp;
1276       CREATE TABLE pp(a, b, c, PRIMARY KEY(b, c));
1277       INSERT INTO pp VALUES(1, 'a', 'b');
1285       DROP TABLE pp;
1343     CREATE TABLE pp(a PRIMARY KEY, b);
1344     CREATE TABLE cc(x, y REFERENCES pp DEFERRABLE INITIALLY DEFERRED);
1345     INSERT INTO pp VALUES(1, 'one');
1346     INSERT INTO pp VALUES(2, 'two');
1352   execsqlS { INSERT INTO pp VALUES(3, 'three') }
1359   execsqlS { INSERT INTO pp VALUES(5, 'five') }
1363   execsqlS { INSERT INTO pp VALUES(6, 'six') }
1378     DELETE FROM pp WHERE a = 2;
1684     CREATE TABLE pp(a PRIMARY KEY, b);
1685     CREATE TABLE cc(c PRIMARY KEY, d REFERENCES pp);
1706         INSERT INTO pp VALUES(2, 'two');
1715     execsql { DELETE FROM cc ; DELETE FROM pp }
1729       INSERT INTO pp VALUES(2, 'two');
1734     catchsql "$update pp SET a = 1"
1737     execsql { SELECT * FROM pp }
1748         INSERT INTO pp VALUES(3, 'three');
1750     catchsql "$update pp SET a = 1 WHERE a = 2"
1753     execsql { COMMIT ; SELECT * FROM pp }
1766     execsql { DELETE FROM cc ; DELETE FROM pp }