Lines Matching refs:t2
53 CREATE TEMP TABLE t2(x,y,z);
54 INSERT INTO t2 VALUES(4,5,6);
56 db2 eval {SELECT * FROM t2}
60 catchsql {SELECT * FROM t2}
61 } {1 {no such table: t2}}
63 catchsql {INSERT INTO t2 VALUES(8,9,0);}
64 } {1 {no such table: t2}}
66 db2 eval {INSERT INTO t2 VALUES(8,9,0);}
67 db2 eval {SELECT * FROM t2 ORDER BY x}
70 db2 eval {DELETE FROM t2 WHERE x==8}
71 db2 eval {SELECT * FROM t2 ORDER BY x}
74 db2 eval {DELETE FROM t2}
75 db2 eval {SELECT * FROM t2}
79 INSERT INTO t2 VALUES(7,6,5);
80 INSERT INTO t2 VALUES(4,3,2);
81 SELECT * FROM t2 ORDER BY x;
85 db2 eval {DROP TABLE t2;}
86 set r [catch {db2 eval {SELECT * FROM t2}} msg]
88 } {1 {no such table: t2}}
95 CREATE TEMPORARY TABLE t2(x,y);
96 INSERT INTO t2 VALUES(1,2);
97 SELECT * FROM t2;
102 catchsql {SELECT * FROM t2}
103 } {1 {no such table: t2}}
107 CREATE TEMPORARY TABLE t2(x,y);
108 INSERT INTO t2 VALUES(1,2);
109 SELECT * FROM t2;
114 catchsql {SELECT * FROM t2}
117 set r [catch {db2 eval {SELECT * FROM t2}} msg]
119 } {1 {no such table: t2}}
125 CREATE INDEX i2 ON t2(x);
131 SELECT y FROM t2 WHERE x=1;
137 SELECT y FROM t2 WHERE x=1;
142 CREATE INDEX i2 ON t2(x);
143 DROP TABLE t2;
155 CREATE TEMP TABLE t2(x,y);
156 INSERT INTO t2 VALUES(10,20);
157 SELECT * FROM t2;
162 CREATE TABLE t2(x,y,z);
163 INSERT INTO t2 VALUES(9,8,7);
164 SELECT * FROM t2;
169 SELECT * FROM t2;
174 SELECT * FROM temp.t2;
179 SELECT * FROM main.t2;
181 } {1 {no such table: main.t2}}
191 } {0 {t1 t2}}
194 SELECT * FROM main.t2;
200 SELECT * FROM t2;
205 DROP TABLE t2; -- should drop TEMP
206 SELECT * FROM t2; -- data should be from MAIN
213 SELECT * FROM t2;
218 DROP TABLE t2;
219 SELECT * FROM t2;
221 } {1 {no such table: t2}}
226 CREATE TEMP TABLE t2(x unique,y);
227 INSERT INTO t2 VALUES(1,2);
228 SELECT * FROM t2;
233 CREATE TABLE t2(x unique, y);
234 INSERT INTO t2 VALUES(3,4);
235 SELECT * FROM t2;
240 SELECT * FROM t2;
252 } {0 {t1 t2}}
255 SELECT * FROM t2;
260 SELECT * FROM t2;
265 DROP TABLE t2; -- drops TEMP.T2
266 SELECT * FROM t2; -- uses MAIN.T2
271 SELECT * FROM t2;
278 SELECT * FROM t2;
292 CREATE INDEX mask ON t2(x);
293 SELECT * FROM t2;
298 # SELECT * FROM t2;
303 SELECT * FROM t2;
308 SELECT y FROM t2 WHERE x=3
313 SELECT y FROM t2 WHERE x=3
318 INSERT INTO t2 VALUES(1,2);
319 SELECT y FROM t2 WHERE x=1;
324 SELECT y FROM t2 WHERE x=3
329 SELECT y FROM t2 WHERE x=1;
334 SELECT y FROM t2 WHERE x=3