Lines Matching refs:t
94 CREATE TABLE t1(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);
95 CREATE TABLE t2(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);
96 CREATE TABLE t3(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);
98 CREATE VIEW v1 AS SELECT rowid, i, t FROM t1;
99 CREATE VIEW v2 AS SELECT rowid, i, t FROM t2;
100 CREATE VIEW v3 AS SELECT rowid, i, t FROM t3;
103 set stmt [string map "%T% t$jj" {INSERT INTO %T% VALUES(NULL, $i, $t)}]
106 set t [number_name $i]
111 CREATE INDEX i1 ON t1(t);
112 CREATE INDEX i2 ON t2(t);
113 CREATE INDEX i3 ON t3(t);
128 set sql "SELECT * FROM t1, t2, t3 WHERE t1.t = t2.t AND t2.t = t3.t"
145 append sql "SELECT t FROM t[expr {($ii%3)+1}] WHERE rowid = [expr {$ii*3}];"
154 SELECT (SELECT t FROM t1 WHERE rowid = [expr {$ii*3}]),
155 (SELECT t FROM t2 WHERE rowid = [expr {$ii*3}]),
156 (SELECT t FROM t3 WHERE rowid = [expr {$ii*3}])
165 CREATE TABLE log(op TEXT, r INTEGER, i INTEGER, t TEXT);
166 CREATE TABLE t4(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);
168 INSERT INTO log VALUES('INSERT INTO t4', new.rowid, new.i, new.t);
171 INSERT INTO log VALUES('UPDATE OF t4', new.rowid, new.i, new.t);
174 INSERT INTO log VALUES('DELETE OF t4', old.rowid, old.i, old.t);
187 UPDATE t4 SET i = $ii2, t = '[number_name $ii2]' WHERE rowid = $ii;
207 CREATE TABLE t4(rowid INTEGER PRIMARY KEY, i INTEGER, t TEXT);
219 UPDATE t4 SET i = $ii2, t = '[number_name $ii2]' WHERE rowid = $ii;