Lines Matching refs:x0
29 CREATE VIRTUAL TABLE t2 USING rtree(id,x0,x1);
30 INSERT INTO t2(id,x0,x1) VALUES(1,2,3);
33 SELECT 123 FROM t1, t2 WHERE (a,0)>(x0,0);
36 SELECT 123 FROM t1, t2 WHERE (a,0.1)>(x0,0);
39 SELECT 123 FROM t1, t2 WHERE (a,0)>=(x0,0);
42 SELECT 123 FROM t1, t2 WHERE (a,0)<=(x0,0);
45 SELECT 123 FROM t1, t2 WHERE (a,0)<(x0,0);
48 SELECT 123 FROM t1, t2 WHERE (x0,0)<(a,0);
51 SELECT 123 FROM t1, t2 WHERE (x0,0)<(a,0.1);
54 SELECT 123 FROM t1, t2 WHERE x1<5 AND id<99 AND (a,0)>(x0,0);
57 SELECT 123 FROM t1, t2 WHERE x1<5 AND id<99 AND (a,0.5)>(x0,0);
60 SELECT 123 FROM t1, t2 WHERE x1<5 AND id<99 AND (a,0)>=(x0,0);
63 SELECT 123 FROM t1, t2 WHERE x1<5 AND id<99 AND (a,0)<(x0,0);
66 SELECT 123 FROM t1, t2 WHERE 5>x1 AND 99>id AND (x0,0)<(a,0);
69 SELECT 123 FROM t1, t2 WHERE 5>x1 AND 99>id AND (x0,0)<(a,0.5);