Lines Matching refs:catchsql
35 catchsql {CREATE TABLE t1(a,b,c)}
51 catchsql {CREATE TABLE t1(a,b,c)}
70 catchsql {CREATE TEMP TABLE t1(a,b,c)}
83 catchsql {CREATE TEMP TABLE t1(a,b,c)}
99 catchsql {CREATE TABLE t1(a,b,c)}
112 catchsql {CREATE TABLE t1(a,b,c)}
124 catchsql {CREATE TEMP TABLE t1(a,b,c)}
137 catchsql {CREATE TEMP TABLE t1(a,b,c)}
151 catchsql {CREATE TEMP TABLE t1(a,b,c)}
165 catchsql {CREATE TABLE t2(a,b,c)}
182 catchsql {DROP TABLE t2}
198 catchsql {DROP TABLE t2}
215 catchsql {DROP TABLE t1}
228 catchsql {DROP TABLE t1}
241 catchsql {INSERT INTO t2 VALUES(1,2,3)}
253 catchsql {INSERT INTO t2 VALUES(1,2,3)}
265 catchsql {INSERT INTO t2 VALUES(1,2,3)}
278 catchsql {SELECT * FROM t2}
282 catchsql {SELECT * FROM two.t2}
292 catchsql {SELECT * FROM t2}
301 catchsql {SELECT * FROM t2 WHERE b=2}
310 catchsql {SELECT * FROM t2 WHERE b=2}
319 catchsql {SELECT * FROM t2 WHERE b IS NULL}
328 catchsql {SELECT a,c FROM t2 WHERE b IS NULL}
338 catchsql {UPDATE t2 SET a=11}
350 catchsql {UPDATE t2 SET b=22, c=33}
362 catchsql {UPDATE t2 SET b=22, c=33}
375 catchsql {DELETE FROM t2 WHERE a=11}
387 catchsql {DELETE FROM t2 WHERE a=11}
400 catchsql {SELECT * FROM t2}
409 catchsql {SELECT * FROM t2}
418 catchsql {SELECT * FROM t2}
432 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
448 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
464 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
480 catchsql {DROP TABLE t2}
492 catchsql {DROP TABLE t2}
504 catchsql {DROP TABLE t1}
516 catchsql {DROP TABLE t1}
529 catchsql {DROP TABLE t2}
541 catchsql {DROP TABLE t2}
553 catchsql {DROP TABLE t1}
565 catchsql {DROP TABLE t1}
579 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
595 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
612 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
628 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
644 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
656 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
669 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
681 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
694 catchsql {
710 catchsql {DROP VIEW v2}
725 catchsql {DROP VIEW v2}
738 catchsql {DROP VIEW v2}
754 catchsql {DROP VIEW v2}
771 catchsql {
787 catchsql {DROP VIEW v1}
802 catchsql {DROP VIEW v1}
815 catchsql {DROP VIEW v1}
831 catchsql {DROP VIEW v1}
848 catchsql {
867 catchsql {
884 catchsql {
903 catchsql {
920 catchsql {
962 catchsql {
981 catchsql {
998 catchsql {
1017 catchsql {
1034 catchsql {
1054 catchsql {DROP TRIGGER r2}
1067 catchsql {DROP TRIGGER r2}
1082 catchsql {DROP TRIGGER r2}
1095 catchsql {DROP TRIGGER r2}
1111 catchsql {DROP TRIGGER r2}
1131 catchsql {DROP TRIGGER r1}
1144 catchsql {DROP TRIGGER r1}
1159 catchsql {DROP TRIGGER r1}
1172 catchsql {DROP TRIGGER r1}
1188 catchsql {DROP TRIGGER r1}
1205 catchsql {CREATE INDEX i2 ON t2(a)}
1220 catchsql {CREATE INDEX i2 ON t2(a)}
1233 catchsql {CREATE INDEX i2 ON t2(b)}
1248 catchsql {CREATE INDEX i2 ON t2(b)}
1261 catchsql {CREATE INDEX i2 ON t2(a)}
1278 catchsql {CREATE INDEX i1 ON t1(a)}
1293 catchsql {CREATE INDEX i1 ON t1(b)}
1306 catchsql {CREATE INDEX i1 ON t1(b)}
1321 catchsql {CREATE INDEX i1 ON t1(c)}
1334 catchsql {CREATE INDEX i1 ON t1(a)}
1350 catchsql {DROP INDEX i2}
1363 catchsql {DROP INDEX i2}
1378 catchsql {DROP INDEX i2}
1391 catchsql {DROP INDEX i2}
1407 catchsql {DROP INDEX i2}
1423 catchsql {DROP INDEX i1}
1436 catchsql {DROP INDEX i1}
1451 catchsql {DROP INDEX i1}
1464 catchsql {DROP INDEX i1}
1480 catchsql {DROP INDEX i1}
1497 catchsql {PRAGMA full_column_names=on}
1513 catchsql {PRAGMA full_column_names=on}
1529 catchsql {PRAGMA full_column_names=on}
1542 catchsql {PRAGMA full_column_names=OFF}
1559 catchsql {BEGIN}
1572 catchsql {BEGIN; INSERT INTO t2 VALUES(44,55,66); COMMIT}
1581 catchsql {ROLLBACK}
1587 catchsql {END TRANSACTION}
1594 catchsql {ROLLBACK}
1610 catchsql {
1618 catchsql {DETACH DATABASE test1}
1626 catchsql {
1634 catchsql {DETACH DATABASE test1}
1642 catchsql {
1658 catchsql {
1674 catchsql {
1689 catchsql {
1709 catchsql {SELECT * FROM t3}
1712 catchsql {SELECT y,z FROM t3}
1715 catchsql {SELECT ROWID,y,z FROM t3}
1718 catchsql {SELECT OID,y,z FROM t3}
1728 catchsql {SELECT * FROM t3}
1731 catchsql {SELECT rowid,y,z FROM t3}
1740 catchsql {SELECT * FROM t3}
1743 catchsql {SELECT ROWID,y,z FROM t3}
1752 catchsql {SELECT ROWID,b,c FROM t2}
1761 catchsql {SELECT ROWID,b,c FROM t2}
1773 catchsql {SELECT ROWID,b,c FROM t2}
1782 catchsql {SELECT * FROM t2, t3}
1791 catchsql {SELECT * FROM t2, t3}