Lines Matching refs:t2

55     CREATE TEMP TABLE t2(x,y,z);
56     INSERT INTO t2 VALUES(4,5,6);
58   db2 eval {SELECT * FROM t2}
62   catchsql {SELECT * FROM t2}
63 } {1 {no such table: t2}}
65   catchsql {INSERT INTO t2 VALUES(8,9,0);}
66 } {1 {no such table: t2}}
68   db2 eval {INSERT INTO t2 VALUES(8,9,0);}
69   db2 eval {SELECT * FROM t2 ORDER BY x}
72   db2 eval {DELETE FROM t2 WHERE x==8}
73   db2 eval {SELECT * FROM t2 ORDER BY x}
76   db2 eval {DELETE FROM t2}
77   db2 eval {SELECT * FROM t2}
81      INSERT INTO t2 VALUES(7,6,5);
82      INSERT INTO t2 VALUES(4,3,2);
83      SELECT * FROM t2 ORDER BY x;
87   db2 eval {DROP TABLE t2;}
88   set r [catch {db2 eval {SELECT * FROM t2}} msg]
90 } {1 {no such table: t2}}
97     CREATE TEMPORARY TABLE t2(x,y);
98     INSERT INTO t2 VALUES(1,2);
99     SELECT * FROM t2;
104   catchsql {SELECT * FROM t2}
105 } {1 {no such table: t2}}
109     CREATE TEMPORARY TABLE t2(x,y);
110     INSERT INTO t2 VALUES(1,2);
111     SELECT * FROM t2;
116   catchsql {SELECT * FROM t2}
119   set r [catch {db2 eval {SELECT * FROM t2}} msg]
121 } {1 {no such table: t2}}
127     CREATE INDEX i2 ON t2(x);
133     SELECT y FROM t2 WHERE x=1;
139     SELECT y FROM t2 WHERE x=1;
144     CREATE INDEX i2 ON t2(x);
145     DROP TABLE t2;
157     CREATE TEMP TABLE t2(x,y);
158     INSERT INTO t2 VALUES(10,20);
159     SELECT * FROM t2;
164     CREATE TABLE t2(x,y,z);
165     INSERT INTO t2 VALUES(9,8,7);
166     SELECT * FROM t2;
171     SELECT * FROM t2;
176     SELECT * FROM temp.t2;
181     SELECT * FROM main.t2;
193 } {0 {t1 t2}}
196     SELECT * FROM main.t2;
202     SELECT * FROM t2;
207     DROP TABLE t2;     -- should drop TEMP
208     SELECT * FROM t2;  -- data should be from MAIN
215     SELECT * FROM t2;
220     DROP TABLE t2;
221     SELECT * FROM t2;
223 } {1 {no such table: t2}}
228     CREATE TEMP TABLE t2(x unique,y);
229     INSERT INTO t2 VALUES(1,2);
230     SELECT * FROM t2;
235     CREATE TABLE t2(x unique, y);
236     INSERT INTO t2 VALUES(3,4);
237     SELECT * FROM t2;
242     SELECT * FROM t2;
256 } {0 {t1 t2}}
259     SELECT * FROM t2;
264     SELECT * FROM t2;
269     DROP TABLE t2;     -- drops TEMP.T2
270     SELECT * FROM t2;  -- uses MAIN.T2
275     SELECT * FROM t2;
282     SELECT * FROM t2;
297     CREATE INDEX mask ON t2(x);
298     SELECT * FROM t2;
303 #    SELECT * FROM t2;
308     SELECT * FROM t2;
313     SELECT y FROM t2 WHERE x=3
318     SELECT y FROM t2 WHERE x=3
323     INSERT INTO t2 VALUES(1,2);
324     SELECT y FROM t2 WHERE x=1;
329     SELECT y FROM t2 WHERE x=3
334     SELECT y FROM t2 WHERE x=1;
339     SELECT y FROM t2 WHERE x=3