Lines Matching refs:catchsql
150 do_test fkey2-1.1.$tn.1 { catchsql $zSql } $res
164 do_test fkey2-1.2.$tn { catchsql $zSql } $res
180 do_test fkey2-1.3.$tn { catchsql $zSql } $res
198 do_test fkey2-1.4.$tn { catchsql $zSql } $res
217 catchsql { DELETE FROM i }
233 catchsql { DELETE FROM i }
245 catchsql { DELETE FROM i }
257 catchsql { INSERT INTO j VALUES('sqlite') }
265 catchsql { DELETE FROM i WHERE i = 'sqlite' }
278 do_test fkey2-2.$tn [list catchsql $sql] $expected
281 catchsql COMMIT
377 catchsql "INSERT INTO node SELECT parent, 3 FROM leaf"
419 catchsql { UPDATE ab SET a = 5 }
426 catchsql { UPDATE ab SET a = 5 }
435 catchsql { DELETE FROM ab }
557 catchsql { INSERT INTO t2 VALUES(1, 'A'); }
570 catchsql { UPDATE t2 SET c = 3 }
573 catchsql { DELETE FROM t1 WHERE a = 2 }
579 catchsql { UPDATE t1 SET a = 3 }
582 catchsql { UPDATE t2 SET rowid = 3 }
647 catchsql { DELETE FROM t1 }
707 catchsql { INSERT INTO c DEFAULT VALUES }
716 catchsql {
723 catchsql {
730 catchsql {
739 catchsql {
787 catchsql "UPDATE t1 SET b = 'five' WHERE b = 'two'"
793 catchsql "COMMIT"
835 catchsql { DELETE FROM t1 }
873 catchsql { INSERT INTO down(c39, c38) VALUES('yes', 'no') }
880 catchsql { DELETE FROM up WHERE c34 = 'yes' }
908 catchsql $stmt
918 catchsql $stmt
960 catchsql { ALTER TABLE t2 ADD COLUMN c REFERENCES t1 }
963 catchsql { ALTER TABLE t2 ADD COLUMN d DEFAULT NULL REFERENCES t1 }
966 catchsql { ALTER TABLE t2 ADD COLUMN e REFERENCES t1 DEFAULT NULL}
969 catchsql { ALTER TABLE t2 ADD COLUMN f REFERENCES t1 DEFAULT 'text'}
972 catchsql { ALTER TABLE t2 ADD COLUMN g DEFAULT CURRENT_TIME REFERENCES t1 }
1027 catchsql { INSERT INTO t3 VALUES(1, 2, 3) }
1033 catchsql { UPDATE t4 SET b = 5 }
1036 catchsql { UPDATE t4 SET b = 1 }
1052 catchsql { ALTER TABLE t2 ADD COLUMN c REFERENCES t1 }
1055 catchsql { ALTER TABLE t2 ADD COLUMN d DEFAULT NULL REFERENCES t1 }
1058 catchsql { ALTER TABLE t2 ADD COLUMN e REFERENCES t1 DEFAULT NULL}
1061 catchsql { ALTER TABLE t2 ADD COLUMN f REFERENCES t1 DEFAULT 'text'}
1064 catchsql { ALTER TABLE t2 ADD COLUMN g DEFAULT CURRENT_TIME REFERENCES t1 }
1111 catchsql { INSERT INTO t3 VALUES(1, 2, 3) }
1117 catchsql { UPDATE t4 SET b = 5 }
1120 catchsql { UPDATE t4 SET b = 1 }
1137 catchsql { ALTER TABLE t2 ADD COLUMN c REFERENCES t1 }
1140 catchsql { ALTER TABLE t2 ADD COLUMN d DEFAULT NULL REFERENCES t1 }
1143 catchsql { ALTER TABLE t2 ADD COLUMN e REFERENCES t1 DEFAULT NULL}
1146 catchsql { ALTER TABLE t2 ADD COLUMN f REFERENCES t1 DEFAULT 'text'}
1149 catchsql { ALTER TABLE t2 ADD COLUMN g DEFAULT CURRENT_TIME REFERENCES t1 }
1196 catchsql { INSERT INTO t3 VALUES(1, 2, 3) }
1202 catchsql { UPDATE t4 SET b = 5 }
1205 catchsql { UPDATE t4 SET b = 1 }
1228 catchsql { DROP TABLE t1 }
1237 catchsql { INSERT INTO t2 VALUES('x') }
1247 catchsql { DROP TABLE t1 }
1260 catchsql { INSERT INTO cc VALUES(1, 2) }
1405 catchsql { UPDATE self SET b = 15 }
1409 catchsql { UPDATE self SET a = 15 }
1413 catchsql { UPDATE self SET a = 15, b = 16 }
1417 catchsql { UPDATE self SET a = 17, b = 17 }
1424 catchsql { INSERT INTO self VALUES(20, 21) }
1477 catchsql {
1637 catchsql { INSERT INTO short VALUES(1, 3, 2) }
1646 catchsql { UPDATE short SET f = 2 WHERE f IS NULL }
1698 catchsql "$insert INTO cc VALUES(1, 2)"
1709 catchsql "$insert INTO cc VALUES(3, 4)"
1734 catchsql "$update pp SET a = 1"
1740 catchsql "$update cc SET d = 1"
1750 catchsql "$update pp SET a = 1 WHERE a = 2"
1760 catchsql "$update cc SET d = 1 WHERE c = 1"
1786 catchsql { INSERT INTO t2 VALUES(1, 2) }
1798 catchsql { UPDATE t2 SET e = 5 WHERE e IS NULL }
1807 catchsql { UPDATE t1 SET a = 10 }
1810 catchsql { UPDATE t1 SET a = NULL }
1813 catchsql { DELETE FROM t1 }
1833 catchsql { INSERT INTO t3 VALUES(3, 1, 4) }
1842 catchsql { DELETE FROM t1 }
1845 catchsql { UPDATE t1 SET b = 10}
1851 catchsql { UPDATE t3 SET h = 'hello' WHERE i = 3}
1962 catchsql {
1972 catchsql {
1977 catchsql {
1982 catchsql {
2003 catchsql {
2008 catchsql {
2023 catchsql {
2028 catchsql {
2038 catchsql {