Lines Matching refs:x1
55 CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2);
60 rtree_strategy {SELECT * FROM t1 WHERE x1>10}
63 rtree_strategy {SELECT * FROM t1 WHERE x1>10 AND x2 LIKE '%x%'}
67 rtree_strategy {SELECT * FROM t1 WHERE x1<10}
71 rtree_strategy {SELECT * FROM t1,t2 WHERE k=ii AND x1<10}
75 rtree_strategy {SELECT * FROM t1,t2 WHERE k=+ii AND x1<10}
79 SELECT * FROM t1,t2 WHERE k=+ii AND x1<10
87 SELECT * FROM t1,t2 WHERE k=ii AND x1<10
103 SELECT * FROM t1,t2 WHERE v=+ii and x1<10 and x2>10
110 SELECT * FROM t1,t2 WHERE v=10 and x1<10 and x2>10
118 SELECT * FROM t1,t2 WHERE k=ii AND x1<v
126 CREATE VIRTUAL TABLE t3 USING rtree(id, x1, x2, y1, y2);
129 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
130 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
131 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
132 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
133 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
134 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5;
140 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
141 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
142 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
143 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5
149 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
150 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
151 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
152 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
153 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
154 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5
159 SELECT * FROM t3 WHERE x1>0.5 AND x1>0.8 AND x1>1.1
163 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
164 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
165 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
166 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
167 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
168 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>1.1
174 CREATE VIRTUAL TABLE t1 USING rtree(id,x0,x1,y0,y1);
177 DELETE FROM t1 WHERE x0>1 AND x1<2 OR y0<92;