Lines Matching full:t2
165 catchsql {CREATE TABLE t2(a,b,c)}
172 } {t2}
182 catchsql {DROP TABLE t2}
186 } {t2 {} main {}}
189 } {t2}
198 catchsql {DROP TABLE t2}
202 } {t2 {} main {}}
205 } {t2}
236 if {$code=="SQLITE_INSERT" && $arg1=="t2"} {
241 catchsql {INSERT INTO t2 VALUES(1,2,3)}
244 execsql {SELECT * FROM t2}
248 if {$code=="SQLITE_INSERT" && $arg1=="t2"} {
253 catchsql {INSERT INTO t2 VALUES(1,2,3)}
256 execsql {SELECT * FROM t2}
265 catchsql {INSERT INTO t2 VALUES(1,2,3)}
268 execsql {SELECT * FROM t2}
273 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="b"} {
278 catchsql {SELECT * FROM t2}
279 } {1 {access to t2.b is prohibited}}
282 catchsql {SELECT * FROM two.t2}
283 } {1 {access to two.t2.b is prohibited}}
287 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="b"} {
292 catchsql {SELECT * FROM t2}
296 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="b"} {
301 catchsql {SELECT * FROM t2 WHERE b=2}
305 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="a"} {
310 catchsql {SELECT * FROM t2 WHERE b=2}
314 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="b"} {
319 catchsql {SELECT * FROM t2 WHERE b IS NULL}
323 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="b"} {
328 catchsql {SELECT a,c FROM t2 WHERE b IS NULL}
329 } {1 {access to t2.b is prohibited}}
333 if {$code=="SQLITE_UPDATE" && $arg1=="t2" && $arg2=="b"} {
338 catchsql {UPDATE t2 SET a=11}
341 execsql {SELECT * FROM t2}
345 if {$code=="SQLITE_UPDATE" && $arg1=="t2" && $arg2=="b"} {
350 catchsql {UPDATE t2 SET b=22, c=33}
353 execsql {SELECT * FROM t2}
357 if {$code=="SQLITE_UPDATE" && $arg1=="t2" && $arg2=="b"} {
362 catchsql {UPDATE t2 SET b=22, c=33}
365 execsql {SELECT * FROM t2}
370 if {$code=="SQLITE_DELETE" && $arg1=="t2"} {
375 catchsql {DELETE FROM t2 WHERE a=11}
378 execsql {SELECT * FROM t2}
382 if {$code=="SQLITE_DELETE" && $arg1=="t2"} {
387 catchsql {DELETE FROM t2 WHERE a=11}
390 execsql {SELECT * FROM t2}
400 catchsql {SELECT * FROM t2}
409 catchsql {SELECT * FROM t2}
418 catchsql {SELECT * FROM t2}
432 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
436 } {t2 data1.txt main {}}
438 execsql {SELECT * FROM t2}
448 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
452 } {t2 data1.txt main {}}
454 execsql {SELECT * FROM t2}
464 catchsql {COPY t2 FROM 'data1.txt' USING DELIMITERS ':'}
468 } {t2 data1.txt main {}}
470 execsql {SELECT * FROM t2}
480 catchsql {DROP TABLE t2}
484 } {t2}
487 if {$code=="SQLITE_DELETE" && $arg1=="t2"} {
492 catchsql {DROP TABLE t2}
496 } {t2}
529 catchsql {DROP TABLE t2}
533 } {t2}
536 if {$code=="SQLITE_DELETE" && $arg1=="t2"} {
541 catchsql {DROP TABLE t2}
545 } {t2}
579 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
586 } {t2}
595 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
602 } {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}
648 } {t2}
656 catchsql {CREATE VIEW v1 AS SELECT a+1,b+1 FROM t2}
660 } {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}
695 CREATE VIEW v2 AS SELECT a+1,b+1 FROM t2;
701 } {t2 v2}
717 } {t2 v2}
729 } {t2 v2}
745 } {t2 v2}
761 } {t2}
849 CREATE TRIGGER r2 DELETE on t2 BEGIN
856 } {r2 t2 main {}}
859 } {t2}
868 CREATE TRIGGER r2 DELETE on t2 BEGIN
875 } {t2}
885 CREATE TRIGGER r2 DELETE on t2 BEGIN
892 } {r2 t2 main {}}
895 } {t2}
904 CREATE TRIGGER r2 DELETE on t2 BEGIN
911 } {t2}
922 CREATE TRIGGER r2 AFTER INSERT ON t2 BEGIN
929 } {r2 t2 main {}}
942 INSERT INTO t2 VALUES(1,2,3);
945 } {SQLITE_INSERT t2 {} main {} SQLITE_INSERT tx {} main r2 SQLITE_READ t2 ROWID main r2}
953 } {t2 tx r2}
1058 } {t2 tx r2}
1071 } {r2 t2 main {}}
1074 } {t2 tx r2}
1086 } {t2 tx r2}
1099 } {r2 t2 main {}}
1102 } {t2 tx r2}
1115 } {r2 t2 main {}}
1119 DELETE FROM t2 WHERE a=1 AND b=2 AND c=3;
1122 } {t2}
1205 catchsql {CREATE INDEX i2 ON t2(a)}
1209 } {i2 t2 main {}}
1212 } {t2}
1220 catchsql {CREATE INDEX i2 ON t2(a)}
1224 } {t2}
1233 catchsql {CREATE INDEX i2 ON t2(b)}
1237 } {i2 t2 main {}}
1240 } {t2}
1248 catchsql {CREATE INDEX i2 ON t2(b)}
1252 } {t2}
1261 catchsql {CREATE INDEX i2 ON t2(a)}
1265 } {i2 t2 main {}}
1268 } {t2 i2}
1354 } {t2 i2}
1367 } {i2 t2 main {}}
1370 } {t2 i2}
1382 } {t2 i2}
1395 } {i2 t2 main {}}
1398 } {t2 i2}
1411 } {i2 t2 main {}}
1414 } {t2}
1503 execsql2 {SELECT a FROM t2}
1519 execsql2 {SELECT a FROM t2}
1532 execsql2 {SELECT a FROM t2}
1533 } {t2.a 11 t2.a 7}
1548 execsql2 {SELECT a FROM t2}
1572 catchsql {BEGIN; INSERT INTO t2 VALUES(44,55,66); COMMIT}
1578 execsql {SELECT * FROM t2}
1597 execsql {SELECT * FROM t2}
1747 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="ROWID"} {
1752 catchsql {SELECT ROWID,b,c FROM t2}
1756 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="ROWID"} {
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}
1802 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
1805 UPDATE t2 SET a=a+1;
1811 if {$code=="SQLITE_READ" && $arg1=="t2" && $arg2=="c"} {
1818 UPDATE t2 SET a=a+100;
1832 UPDATE t2 SET a=a+1;
1836 SQLITE_READ t2 a main {} \
1837 SQLITE_UPDATE t2 a main {} \
1839 SQLITE_READ t2 a main r1 \
1840 SQLITE_READ t2 a main r1 \
1841 SQLITE_READ t2 b main r1 \
1842 SQLITE_READ t2 b main r1 \
1843 SQLITE_READ t2 c main r1 \
1844 SQLITE_READ t2 c main r1]
1847 CREATE VIEW v1 AS SELECT a+b AS x FROM t2;
1865 SQLITE_READ t2 a main v1 \
1866 SQLITE_READ t2 b main v1 \
1888 SQLITE_READ t2 a main v1 \
1889 SQLITE_READ t2 b main v1 \