Lines Matching refs:id

63   CREATE VIRTUAL TABLE demo_index USING rtree(id, x1,x2, y1,y2);
69   SELECT id FROM demo_index WHERE id MATCH circle(45.3, 22.9, 5.0)
77   SELECT id FROM demo_index WHERE id MATCH qcircle(45.3, 22.9, 5.0, 1)
94   SELECT id FROM demo_index WHERE id MATCH box(43,46, 21,25);
123   CREATE VIRTUAL TABLE rt1 USING rtree(id, x1,x2);
124   CREATE VIRTUAL TABLE rt2 USING rtree(id, x1,x2, y1,y2);
125   CREATE VIRTUAL TABLE rt3 USING rtree(id, x1,x2, y1,y2, z1,z2);
138     SELECT id FROM $tbl WHERE id MATCH box();
152   SELECT * FROM rt2 WHERE id MATCH box(22,23, 24,25); 
172   SELECT * FROM rt1 WHERE id MATCH box(1,1);
192   SELECT * FROM rt1 WHERE id MATCH box(1,1);
209   CREATE VIRTUAL TABLE r1 USING rtree(id, minX,maxX, minY,maxY);
222   SELECT count(*) FROM r1 WHERE id MATCH box(0,150,199,201)
237   1 "SELECT count(*) FROM r1 WHERE id MATCH box(1,2,3)" {1.0 2.0 3.0}
238   2 "SELECT count(*) FROM r1 WHERE id MATCH box(10001)" {10001.0}
239   3 "SELECT count(*) FROM r1 WHERE id MATCH box(-10001)" {-10001.0}
246   CREATE VIRTUAL TABLE myrtree USING rtree(id, x1,x2);
260   SELECT * FROM myrtree WHERE id MATCH box(4, 5);
293   SELECT * FROM myrtree WHERE id MATCH box(4, 5);