Lines Matching refs:t
25 CREATE TABLE t(x, y);
29 SELECT * FROM r_tree, t
30 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND t.x<=max_y
33 |--SCAN t
38 SELECT * FROM t, r_tree
39 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND t.x<=max_y
42 |--SCAN t
47 SELECT * FROM t, r_tree
48 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND ?<=max_y
51 |--SCAN t
56 SELECT * FROM t, r_tree
60 `--SCAN t
64 INSERT INTO t VALUES(0, 0);
65 INSERT INTO t VALUES(0, 1);
66 INSERT INTO t VALUES(0, 2);
67 INSERT INTO t VALUES(0, 3);
68 INSERT INTO t VALUES(0, 4);
69 INSERT INTO t VALUES(0, 5);
70 INSERT INTO t VALUES(0, 6);
71 INSERT INTO t VALUES(0, 7);
72 INSERT INTO t VALUES(0, 8);
73 INSERT INTO t VALUES(0, 9);
75 INSERT INTO t SELECT x+1, y FROM t;
76 INSERT INTO t SELECT x+2, y FROM t;
77 INSERT INTO t SELECT x+4, y FROM t;
78 INSERT INTO r_tree SELECT NULL, x-1, x+1, y-1, y+1 FROM t;
86 SELECT * FROM r_tree, t
87 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND t.x<=max_y
90 |--SCAN t
95 SELECT * FROM t, r_tree
96 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND t.x<=max_y
99 |--SCAN t
104 SELECT * FROM t, r_tree
105 WHERE t.x>=min_x AND t.x<=max_x AND t.y>=min_y AND ?<=max_y
108 |--SCAN t
113 SELECT * FROM t, r_tree
117 `--SCAN t