Lines Matching refs:id

31   CREATE VIRTUAL TABLE rt1 USING rtree(id,x0,x1,y0,y1);
55   SELECT id FROM rt1 WHERE id MATCH Qcircle(0.0, 0.0, 50.0, 3) ORDER BY id;
58   SELECT id FROM rt1 WHERE id MATCH Qcircle('x:0 y:0 r:50.0 e:3') ORDER BY id;
61   SELECT id FROM rt1 WHERE id MATCH Qcircle(100.0, 0.0, 50.0, 3) ORDER BY id;
64   SELECT id FROM rt1 WHERE id MATCH Qcircle(0.0, 200.0, 50.0, 3) ORDER BY id;
72   SELECT id FROM rt1 WHERE id MATCH Qcircle('r:1000 e:3') AND id%100==0
77   SELECT id FROM rt1 WHERE id MATCH Qcircle('r:1000 e:4') ORDER BY +id
82   SELECT id FROM rt1 WHERE id MATCH Qcircle(0,0,1000,5) ORDER BY +id
88   SELECT id FROM rt1 WHERE id=18 AND id MATCH Qcircle(0,0,1000,5)
96     CREATE TABLE t2(id,x0,x1,y0,y1);
97     CREATE VIRTUAL TABLE rt2 USING rtree(id,x0,x1,y0,y1);
108     set id [expr {$i+10000}]
109     db eval {INSERT INTO t2 VALUES($id,$x0,$x1,$y0,$y1)}
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}]
135   SELECT id FROM rt2 WHERE id MATCH breadthfirstsearch(0,5000,0,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}]
139   SELECT id FROM rt2 WHERE id MATCH breadthfirstsearch(0,10000,0,10000) ORDER BY id