Lines Matching full:t2
51 CREATE TEMP TABLE t2(x,y,z);
52 INSERT INTO t2 VALUES(4,5,6);
54 db2 eval {SELECT * FROM t2}
58 catchsql {SELECT * FROM t2}
59 } {1 {no such table: t2}}
61 catchsql {INSERT INTO t2 VALUES(8,9,0);}
62 } {1 {no such table: t2}}
64 db2 eval {INSERT INTO t2 VALUES(8,9,0);}
65 db2 eval {SELECT * FROM t2 ORDER BY x}
68 db2 eval {DELETE FROM t2 WHERE x==8}
69 db2 eval {SELECT * FROM t2 ORDER BY x}
72 db2 eval {DELETE FROM t2}
73 db2 eval {SELECT * FROM t2}
77 INSERT INTO t2 VALUES(7,6,5);
78 INSERT INTO t2 VALUES(4,3,2);
79 SELECT * FROM t2 ORDER BY x;
83 db2 eval {DROP TABLE t2;}
84 set r [catch {db2 eval {SELECT * FROM t2}} msg]
86 } {1 {no such table: t2}}
93 CREATE TEMPORARY TABLE t2(x,y);
94 INSERT INTO t2 VALUES(1,2);
95 SELECT * FROM t2;
100 catchsql {SELECT * FROM t2}
101 } {1 {no such table: t2}}
105 CREATE TEMPORARY TABLE t2(x,y);
106 INSERT INTO t2 VALUES(1,2);
107 SELECT * FROM t2;
112 catchsql {SELECT * FROM t2}
115 set r [catch {db2 eval {SELECT * FROM t2}} msg]
117 } {1 {no such table: t2}}
123 CREATE INDEX i2 ON t2(x);
129 SELECT y FROM t2 WHERE x=1;
135 SELECT y FROM t2 WHERE x=1;
140 CREATE INDEX i2 ON t2(x);
141 DROP TABLE t2;
153 CREATE TEMP TABLE t2(x,y);
154 INSERT INTO t2 VALUES(10,20);
155 SELECT * FROM t2;
160 CREATE TABLE t2(x,y,z);
161 INSERT INTO t2 VALUES(9,8,7);
162 SELECT * FROM t2;
167 SELECT * FROM t2;
172 SELECT * FROM temp.t2;
177 SELECT * FROM main.t2;
179 } {1 {no such table: main.t2}}
189 } {0 {t1 t2}}
192 SELECT * FROM main.t2;
198 SELECT * FROM t2;
203 DROP TABLE t2; -- should drop TEMP
204 SELECT * FROM t2; -- data should be from MAIN
211 SELECT * FROM t2;
216 DROP TABLE t2;
217 SELECT * FROM t2;
219 } {1 {no such table: t2}}
224 CREATE TEMP TABLE t2(x unique,y);
225 INSERT INTO t2 VALUES(1,2);
226 SELECT * FROM t2;
231 CREATE TABLE t2(x unique, y);
232 INSERT INTO t2 VALUES(3,4);
233 SELECT * FROM t2;
238 SELECT * FROM t2;
250 } {0 {t1 t2}}
253 SELECT * FROM t2;
258 SELECT * FROM t2;
263 DROP TABLE t2; -- drops TEMP.T2
264 SELECT * FROM t2; -- uses MAIN.T2
269 SELECT * FROM t2;
276 SELECT * FROM t2;
290 CREATE INDEX mask ON t2(x);
291 SELECT * FROM t2;
296 # SELECT * FROM t2;
301 SELECT * FROM t2;
306 SELECT y FROM t2 WHERE x=3
311 SELECT y FROM t2 WHERE x=3
316 INSERT INTO t2 VALUES(1,2);
317 SELECT y FROM t2 WHERE x=1;
322 SELECT y FROM t2 WHERE x=3
327 SELECT y FROM t2 WHERE x=1;
332 SELECT y FROM t2 WHERE x=3