Lines Matching refs:pp

638     CREATE TABLE pp(a, b, c, PRIMARY KEY(b, c)) WITHOUT rowid;
640         FOREIGN KEY(f, d) REFERENCES pp 
644     INSERT INTO pp VALUES(1, 2, 3);
645     INSERT INTO pp VALUES(4, 5, 6);
646     INSERT INTO pp VALUES(7, 8, 9);
655     UPDATE pp SET b = 1 WHERE a = 7;
661     DELETE FROM pp WHERE a = 4;
878     CREATE TABLE pp(a UNIQUE, b, c, PRIMARY KEY(b, c)) WITHOUT rowid;
879     CREATE TABLE cc(d, e, f UNIQUE, FOREIGN KEY(d, e) REFERENCES pp);
880     INSERT INTO pp VALUES(1, 2, 3);
885   1   "REPLACE INTO pp VALUES(1, 4, 5)"
892       SELECT * FROM pp;
903       SELECT * FROM pp;
1232     CREATE TABLE pp(x, y, PRIMARY KEY(x, y)) WITHOUT ROWID;
1233     CREATE TABLE cc(a, b, FOREIGN KEY(a, b) REFERENCES pp(x, z));
1236 } {1 {foreign key mismatch - "cc" referencing "pp"}}
1243       FOREIGN KEY(a, b) REFERENCES pp DEFERRABLE INITIALLY DEFERRED
1247     INSERT INTO pp VALUES('a', 'b');
1250       DROP TABLE pp;
1251       CREATE TABLE pp(a, b, c, PRIMARY KEY(b, c)) WITHOUT rowid;
1252       INSERT INTO pp VALUES(1, 'a', 'b');
1260       DROP TABLE pp;
1318     CREATE TABLE pp(a PRIMARY KEY, b) WITHOUT rowid;
1319     CREATE TABLE cc(x, y REFERENCES pp DEFERRABLE INITIALLY DEFERRED);
1320     INSERT INTO pp VALUES(1, 'one');
1321     INSERT INTO pp VALUES(2, 'two');
1327   execsqlS { INSERT INTO pp VALUES(3, 'three') }
1334   execsqlS { INSERT INTO pp VALUES(5, 'five') }
1338   execsqlS { INSERT INTO pp VALUES(6, 'six') }
1353     DELETE FROM pp WHERE a = 2;
1746     CREATE TABLE pp(a PRIMARY KEY, b) WITHOUT rowid;
1747     CREATE TABLE cc(c PRIMARY KEY, d REFERENCES pp) WITHOUT rowid;
1768         INSERT INTO pp VALUES(2, 'two');
1777     execsql { DELETE FROM cc ; DELETE FROM pp }
1791       INSERT INTO pp VALUES(2, 'two');
1796     catchsql "$update pp SET a = 1"
1799     execsql { SELECT * FROM pp }
1810         INSERT INTO pp VALUES(3, 'three');
1812     catchsql "$update pp SET a = 1 WHERE a = 2"
1815     execsql { COMMIT ; SELECT * FROM pp }
1828     execsql { DELETE FROM cc ; DELETE FROM pp }