Lines Matching refs:catchsql
150 do_test without_rowid3-1.1.$tn.1 { catchsql $zSql } $res
164 do_test without_rowid3-1.2.$tn { catchsql $zSql } $res
180 do_test without_rowid3-1.3.$tn { catchsql $zSql } $res
198 do_test without_rowid3-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 without_rowid3-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 }
546 catchsql { INSERT INTO t2 VALUES(1, 'A'); }
559 catchsql { UPDATE t2 SET c = 3 }
562 catchsql { DELETE FROM t1 WHERE a = 2 }
568 catchsql { UPDATE t1 SET a = 3 }
633 catchsql { DELETE FROM t1 }
688 catchsql { INSERT INTO c DEFAULT VALUES }
697 catchsql {
704 catchsql {
711 catchsql {
720 catchsql {
768 catchsql "UPDATE t1 SET b = 'five' WHERE b = 'two'"
774 catchsql "COMMIT"
816 catchsql { DELETE FROM t1 }
854 catchsql { INSERT INTO down(c39, c38) VALUES('yes', 'no') }
861 catchsql { DELETE FROM up WHERE c34 = 'yes' }
888 catchsql $stmt
898 catchsql $stmt
926 catchsql { ALTER TABLE t2 ADD COLUMN c REFERENCES t1 }
929 catchsql { ALTER TABLE t2 ADD COLUMN d DEFAULT NULL REFERENCES t1 }
932 catchsql { ALTER TABLE t2 ADD COLUMN e REFERENCES t1 DEFAULT NULL}
935 catchsql { ALTER TABLE t2 ADD COLUMN f REFERENCES t1 DEFAULT 'text'}
938 catchsql { ALTER TABLE t2 ADD COLUMN g DEFAULT CURRENT_TIME REFERENCES t1 }
996 catchsql { INSERT INTO t3 VALUES(1, 2, 3) }
1002 catchsql { UPDATE t4 SET b = 5 }
1005 catchsql { UPDATE t4 SET b = 1 }
1021 catchsql { ALTER TABLE t2 ADD COLUMN c REFERENCES t1 }
1024 catchsql { ALTER TABLE t2 ADD COLUMN d DEFAULT NULL REFERENCES t1 }
1027 catchsql { ALTER TABLE t2 ADD COLUMN e REFERENCES t1 DEFAULT NULL}
1030 catchsql { ALTER TABLE t2 ADD COLUMN f REFERENCES t1 DEFAULT 'text'}
1033 catchsql { ALTER TABLE t2 ADD COLUMN g DEFAULT CURRENT_TIME REFERENCES t1 }
1083 catchsql { INSERT INTO t3 VALUES(1, 2, 3) }
1089 catchsql { UPDATE t4 SET b = 5 }
1092 catchsql { UPDATE t4 SET b = 1 }
1109 catchsql { ALTER TABLE t2 ADD COLUMN c REFERENCES t1 }
1112 catchsql { ALTER TABLE t2 ADD COLUMN d DEFAULT NULL REFERENCES t1 }
1115 catchsql { ALTER TABLE t2 ADD COLUMN e REFERENCES t1 DEFAULT NULL}
1118 catchsql { ALTER TABLE t2 ADD COLUMN f REFERENCES t1 DEFAULT 'text'}
1121 catchsql { ALTER TABLE t2 ADD COLUMN g DEFAULT CURRENT_TIME REFERENCES t1 }
1171 catchsql { INSERT INTO t3 VALUES(1, 2, 3) }
1177 catchsql { UPDATE t4 SET b = 5 }
1180 catchsql { UPDATE t4 SET b = 1 }
1203 catchsql { DROP TABLE t1 }
1212 catchsql { INSERT INTO t2 VALUES('x') }
1222 catchsql { DROP TABLE t1 }
1235 catchsql { INSERT INTO cc VALUES(1, 2) }
1382 catchsql { UPDATE self SET b = 15 }
1386 catchsql { UPDATE self SET a = 15 }
1390 catchsql { UPDATE self SET a = 15, b = 16 }
1394 catchsql { UPDATE self SET a = 17, b = 17 }
1401 catchsql { INSERT INTO self VALUES(20, 21) }
1433 catchsql {
1439 catchsql {
1473 catchsql {
1479 catchsql {
1539 catchsql {
1699 catchsql { INSERT INTO short VALUES(1, 3, 2) }
1708 catchsql { UPDATE short SET f = 2 WHERE f IS NULL }
1760 catchsql "$insert INTO cc VALUES(1, 2)"
1771 catchsql "$insert INTO cc VALUES(3, 4)"
1796 catchsql "$update pp SET a = 1"
1802 catchsql "$update cc SET d = 1"
1812 catchsql "$update pp SET a = 1 WHERE a = 2"
1822 catchsql "$update cc SET d = 1 WHERE c = 1"
1848 catchsql { INSERT INTO t2 VALUES(1, 2) }
1860 catchsql { UPDATE t2 SET e = 5 WHERE e IS NULL }
1869 catchsql { UPDATE t1 SET a = 10 }
1872 catchsql { UPDATE t1 SET a = NULL }
1875 catchsql { DELETE FROM t1 }
1895 catchsql { INSERT INTO t3 VALUES(3, 1, 4) }
1904 catchsql { DELETE FROM t1 }
1907 catchsql { UPDATE t1 SET b = 10}
1913 catchsql { UPDATE t3 SET h = 'hello' WHERE i = 3}
2024 catchsql {
2034 catchsql {
2039 catchsql {
2044 catchsql {
2065 catchsql {
2070 catchsql {
2085 catchsql {
2090 catchsql {