Lines Matching refs:catchsql
37 catchsql {CREATE TABLE t1(a,b,c)}
53 catchsql {CREATE TABLE t1(a,b,c)}
72 catchsql {CREATE TEMP TABLE t1(a,b,c)}
85 catchsql {CREATE TEMP TABLE t1(a,b,c)}
101 catchsql {CREATE TABLE t1(a,b,c)}
114 catchsql {CREATE TABLE t1(a,b,c)}
126 catchsql {CREATE TEMP TABLE t1(a,b,c)}
139 catchsql {CREATE TEMP TABLE t1(a,b,c)}
153 catchsql {CREATE TEMP TABLE t1(a,b,c)}
167 catchsql {CREATE TABLE t2(a,b,c)}
184 catchsql {DROP TABLE t2}
200 catchsql {DROP TABLE t2}
217 catchsql {DROP TABLE t1}
230 catchsql {DROP TABLE t1}
243 catchsql {INSERT INTO t2 VALUES(1,2,3)}
255 catchsql {INSERT INTO t2 VALUES(1,2,3)}
267 catchsql {INSERT INTO t2 VALUES(1,2,3)}
280 catchsql {SELECT * FROM t2}
284 catchsql {SELECT * FROM two.t2}
294 catchsql {SELECT * FROM t2}
303 catchsql {SELECT * FROM t2 WHERE b=2}
312 catchsql {SELECT * FROM t2 WHERE b=2}
321 catchsql {SELECT * FROM t2 WHERE b IS NULL}
330 catchsql {SELECT a,c FROM t2 WHERE b IS NULL}
340 catchsql {UPDATE t2 SET a=11}
352 catchsql {UPDATE t2 SET b=22, c=33}
364 catchsql {UPDATE t2 SET b=22, c=33}
377 catchsql {DELETE FROM t2 WHERE a=11}
389 catchsql {DELETE FROM t2 WHERE a=11}
402 catchsql {SELECT * FROM t2}
411 catchsql {SELECT * FROM t2}
420 catchsql {SELECT * FROM t2}
434 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
450 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
466 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
482 catchsql {DROP TABLE t2}
494 catchsql {DROP TABLE t2}
506 catchsql {DROP TABLE t1}
518 catchsql {DROP TABLE t1}
531 catchsql {DROP TABLE t2}
543 catchsql {DROP TABLE t2}
555 catchsql {DROP TABLE t1}
567 catchsql {DROP TABLE t1}
581 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
597 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
614 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
630 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
646 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
658 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
671 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
683 catchsql {CREATE TEMPORARY VIEW v1 AS SELECT a+1,b+1 FROM t2}
696 catchsql {
712 catchsql {DROP VIEW v2}
727 catchsql {DROP VIEW v2}
740 catchsql {DROP VIEW v2}
756 catchsql {DROP VIEW v2}
773 catchsql {
789 catchsql {DROP VIEW v1}
804 catchsql {DROP VIEW v1}
817 catchsql {DROP VIEW v1}
833 catchsql {DROP VIEW v1}
850 catchsql {
869 catchsql {
886 catchsql {
905 catchsql {
922 catchsql {
964 catchsql {
983 catchsql {
1000 catchsql {
1019 catchsql {
1036 catchsql {
1056 catchsql {DROP TRIGGER r2}
1069 catchsql {DROP TRIGGER r2}
1084 catchsql {DROP TRIGGER r2}
1097 catchsql {DROP TRIGGER r2}
1113 catchsql {DROP TRIGGER r2}
1133 catchsql {DROP TRIGGER r1}
1146 catchsql {DROP TRIGGER r1}
1161 catchsql {DROP TRIGGER r1}
1174 catchsql {DROP TRIGGER r1}
1190 catchsql {DROP TRIGGER r1}
1207 catchsql {CREATE INDEX i2 ON t2(a)}
1222 catchsql {CREATE INDEX i2 ON t2(a)}
1235 catchsql {CREATE INDEX i2 ON t2(b)}
1250 catchsql {CREATE INDEX i2 ON t2(b)}
1263 catchsql {CREATE INDEX i2 ON t2(a)}
1280 catchsql {CREATE INDEX i1 ON t1(a)}
1295 catchsql {CREATE INDEX i1 ON t1(b)}
1308 catchsql {CREATE INDEX i1 ON t1(b)}
1323 catchsql {CREATE INDEX i1 ON t1(c)}
1336 catchsql {CREATE INDEX i1 ON t1(a)}
1352 catchsql {DROP INDEX i2}
1365 catchsql {DROP INDEX i2}
1380 catchsql {DROP INDEX i2}
1393 catchsql {DROP INDEX i2}
1409 catchsql {DROP INDEX i2}
1425 catchsql {DROP INDEX i1}
1438 catchsql {DROP INDEX i1}
1453 catchsql {DROP INDEX i1}
1466 catchsql {DROP INDEX i1}
1482 catchsql {DROP INDEX i1}
1499 catchsql {PRAGMA full_column_names=on}
1515 catchsql {PRAGMA full_column_names=on}
1531 catchsql {PRAGMA full_column_names=on}
1544 catchsql {PRAGMA full_column_names=OFF}
1561 catchsql {BEGIN}
1574 catchsql {BEGIN; INSERT INTO t2 VALUES(44,55,66); COMMIT}
1583 catchsql {ROLLBACK}
1589 catchsql {END TRANSACTION}
1596 catchsql {ROLLBACK}
1612 catchsql {
1620 catchsql {DETACH DATABASE test1}
1628 catchsql {
1636 catchsql {DETACH DATABASE test1}
1644 catchsql {
1660 catchsql {
1676 catchsql {
1691 catchsql {
1711 catchsql {SELECT * FROM t3}
1714 catchsql {SELECT y,z FROM t3}
1717 catchsql {SELECT ROWID,y,z FROM t3}
1720 catchsql {SELECT OID,y,z FROM t3}
1730 catchsql {SELECT * FROM t3}
1733 catchsql {SELECT rowid,y,z FROM t3}
1742 catchsql {SELECT * FROM t3}
1745 catchsql {SELECT ROWID,y,z FROM t3}
1754 catchsql {SELECT ROWID,b,c FROM t2}
1763 catchsql {SELECT ROWID,b,c FROM t2}
1775 catchsql {SELECT ROWID,b,c FROM t2}
1784 catchsql {SELECT * FROM t2, t3}
1793 catchsql {SELECT * FROM t2, t3}