Lines Matching refs:t2
167 catchsql {CREATE TABLE t2(a,b,c)}
174 } {t2}
184 catchsql {DROP TABLE t2}
188 } {t2 {} main {}}
191 } {t2}
200 catchsql {DROP TABLE t2}
204 } {t2 {} main {}}
207 } {t2}
238 if {$code=="SQLITE_INSERT" && $arg1=="t2"} {
243 catchsql {INSERT INTO t2 VALUES(1,2,3)}
246 execsql {SELECT * FROM t2}
250 if {$code=="SQLITE_INSERT" && $arg1=="t2"} {
255 catchsql {INSERT INTO t2 VALUES(1,2,3)}
258 execsql {SELECT * FROM t2}
267 catchsql {INSERT INTO t2 VALUES(1,2,3)}
270 execsql {SELECT * FROM t2}
275 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="b"} {
280 catchsql {SELECT * FROM t2}
281 } {1 {access to t2.b is prohibited}}
284 catchsql {SELECT * FROM two.t2}
285 } {1 {access to two.t2.b is prohibited}}
289 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="b"} {
294 catchsql {SELECT * FROM t2}
298 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="b"} {
303 catchsql {SELECT * FROM t2 WHERE b=2}
307 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="a"} {
312 catchsql {SELECT * FROM t2 WHERE b=2}
316 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="b"} {
321 catchsql {SELECT * FROM t2 WHERE b IS NULL}
325 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="b"} {
330 catchsql {SELECT a,c FROM t2 WHERE b IS NULL}
331 } {1 {access to t2.b is prohibited}}
335 if {$code=="SQLITE_UPDATE" && $arg1=="t2" && $arg2=="b"} {
340 catchsql {UPDATE t2 SET a=11}
343 execsql {SELECT * FROM t2}
347 if {$code=="SQLITE_UPDATE" && $arg1=="t2" && $arg2=="b"} {
352 catchsql {UPDATE t2 SET b=22, c=33}
355 execsql {SELECT * FROM t2}
359 if {$code=="SQLITE_UPDATE" && $arg1=="t2" && $arg2=="b"} {
364 catchsql {UPDATE t2 SET b=22, c=33}
367 execsql {SELECT * FROM t2}
372 if {$code=="SQLITE_DELETE" && $arg1=="t2"} {
377 catchsql {DELETE FROM t2 WHERE a=11}
380 execsql {SELECT * FROM t2}
384 if {$code=="SQLITE_DELETE" && $arg1=="t2"} {
389 catchsql {DELETE FROM t2 WHERE a=11}
392 execsql {SELECT * FROM t2}
402 catchsql {SELECT * FROM t2}
411 catchsql {SELECT * FROM t2}
420 catchsql {SELECT * FROM t2}
434 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
438 } {t2 data1.txt main {}}
440 execsql {SELECT * FROM t2}
450 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
454 } {t2 data1.txt main {}}
456 execsql {SELECT * FROM t2}
466 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
470 } {t2 data1.txt main {}}
472 execsql {SELECT * FROM t2}
482 catchsql {DROP TABLE t2}
486 } {t2}
489 if {$code=="SQLITE_DELETE" && $arg1=="t2"} {
494 catchsql {DROP TABLE t2}
498 } {t2}
531 catchsql {DROP TABLE t2}
535 } {t2}
538 if {$code=="SQLITE_DELETE" && $arg1=="t2"} {
543 catchsql {DROP TABLE t2}
547 } {t2}
581 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
588 } {t2}
597 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
604 } {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}
650 } {t2}
658 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
662 } {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}
697 CREATE VIEW v2 AS SELECT a+1,b+1 FROM t2;
703 } {t2 v2}
719 } {t2 v2}
731 } {t2 v2}
747 } {t2 v2}
763 } {t2}
851 CREATE TRIGGER r2 DELETE on t2 BEGIN
858 } {r2 t2 main {}}
861 } {t2}
870 CREATE TRIGGER r2 DELETE on t2 BEGIN
877 } {t2}
887 CREATE TRIGGER r2 DELETE on t2 BEGIN
894 } {r2 t2 main {}}
897 } {t2}
906 CREATE TRIGGER r2 DELETE on t2 BEGIN
913 } {t2}
924 CREATE TRIGGER r2 AFTER INSERT ON t2 BEGIN
931 } {r2 t2 main {}}
944 INSERT INTO t2 VALUES(1,2,3);
947 } {SQLITE_INSERT t2 {} main {} SQLITE_INSERT tx {} main r2 SQLITE_READ t2 ROWID main r2}
955 } {t2 tx r2}
1060 } {t2 tx r2}
1073 } {r2 t2 main {}}
1076 } {t2 tx r2}
1088 } {t2 tx r2}
1101 } {r2 t2 main {}}
1104 } {t2 tx r2}
1117 } {r2 t2 main {}}
1121 DELETE FROM t2 WHERE a=1 AND b=2 AND c=3;
1124 } {t2}
1207 catchsql {CREATE INDEX i2 ON t2(a)}
1211 } {i2 t2 main {}}
1214 } {t2}
1222 catchsql {CREATE INDEX i2 ON t2(a)}
1226 } {t2}
1235 catchsql {CREATE INDEX i2 ON t2(b)}
1239 } {i2 t2 main {}}
1242 } {t2}
1250 catchsql {CREATE INDEX i2 ON t2(b)}
1254 } {t2}
1263 catchsql {CREATE INDEX i2 ON t2(a)}
1267 } {i2 t2 main {}}
1270 } {t2 i2}
1356 } {t2 i2}
1369 } {i2 t2 main {}}
1372 } {t2 i2}
1384 } {t2 i2}
1397 } {i2 t2 main {}}
1400 } {t2 i2}
1413 } {i2 t2 main {}}
1416 } {t2}
1505 execsql2 {SELECT a FROM t2}
1521 execsql2 {SELECT a FROM t2}
1534 execsql2 {SELECT a FROM t2}
1535 } {t2.a 11 t2.a 7}
1550 execsql2 {SELECT a FROM t2}
1574 catchsql {BEGIN; INSERT INTO t2 VALUES(44,55,66); COMMIT}
1580 execsql {SELECT * FROM t2}
1599 execsql {SELECT * FROM t2}
1749 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="ROWID"} {
1754 catchsql {SELECT ROWID,b,c FROM t2}
1758 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="ROWID"} {
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}
1804 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
1807 UPDATE t2 SET a=a+1;
1813 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="c"} {
1820 UPDATE t2 SET a=a+100;
1834 UPDATE t2 SET a=a+1;
1838 SQLITE_READ t2 a main {} \
1839 SQLITE_UPDATE t2 a main {} \
1841 SQLITE_READ t2 a main r1 \
1842 SQLITE_READ t2 a main r1 \
1843 SQLITE_READ t2 b main r1 \
1844 SQLITE_READ t2 b main r1 \
1845 SQLITE_READ t2 c main r1 \
1846 SQLITE_READ t2 c main r1]
1849 CREATE VIEW v1 AS SELECT a+b AS x FROM t2;
1867 SQLITE_READ t2 a main v1 \
1868 SQLITE_READ t2 b main v1 \
1890 SQLITE_READ t2 a main v1 \
1891 SQLITE_READ t2 b main v1 \