Lines Matching refs:t4
213 CREATE TEMP TABLE t4(x);
214 INSERT INTO t4 VALUES(1);
215 SELECT * FROM t4;
220 INSERT INTO t4 SELECT x+1 FROM t4;
221 SELECT * FROM t4;
225 # verify that a temporary table is used to copy t4 to t4
227 EXPLAIN INSERT INTO t4 SELECT x+2 FROM t4;
233 # page number used by "t4" above.
239 # Verify that "t4" begins on page 3.
241 SELECT rootpage FROM sqlite_temp_master WHERE name='t4';
247 INSERT INTO t4 SELECT one FROM test1 WHERE three=7;
248 SELECT * FROM t4
252 # verify that no temporary table is used to copy test1 to t4
254 EXPLAIN INSERT INTO t4 SELECT one FROM test1;