Lines Matching refs:t4
211 CREATE TEMP TABLE t4(x);
212 INSERT INTO t4 VALUES(1);
213 SELECT * FROM t4;
218 INSERT INTO t4 SELECT x+1 FROM t4;
219 SELECT * FROM t4;
223 # verify that a temporary table is used to copy t4 to t4
225 EXPLAIN INSERT INTO t4 SELECT x+2 FROM t4;
231 # page number used by "t4" above.
237 # Verify that "t4" begins on page 3.
239 SELECT rootpage FROM sqlite_temp_master WHERE name='t4';
245 INSERT INTO t4 SELECT one FROM test1 WHERE three=7;
246 SELECT * FROM t4
250 # verify that no temporary table is used to copy test1 to t4
252 EXPLAIN INSERT INTO t4 SELECT one FROM test1;