Lines Matching refs:x0

31   CREATE VIRTUAL TABLE rt1 USING rtree(id,x0,x1,y0,y1);
96     CREATE TABLE t2(id,x0,x1,y0,y1);
97     CREATE VIRTUAL TABLE rt2 USING rtree(id,x0,x1,y0,y1);
104     set x0 [expr {int(rand()*(10000 - $dx))}]
105     set x1 [expr {$x0+$dx}]
109     db eval {INSERT INTO t2 VALUES($id,$x0,$x1,$y0,$y1)}
121   set x0 [expr {int(rand()*(10000 - $dx))}]
122   set x1 [expr {$x0+$dx}]
125 …set ans [db eval {SELECT id FROM t2 WHERE x1>=$x0 AND x0<=$x1 AND y1>=$y0 AND y0<=$y1 ORDER BY id}]
127     SELECT id FROM rt2 WHERE id MATCH breadthfirstsearch($x0,$x1,$y0,$y1) ORDER BY id
133 set ans [db eval {SELECT id FROM t2 WHERE x1>=0 AND x0<=5000 AND y1>=0 AND y0<=5000 ORDER BY id}]
137 set ans [db eval {SELECT id FROM t2 WHERE x1>=0 AND x0<=10000 AND y1>=0 AND y0<=10000 ORDER BY id}]