Lines Matching refs:id

26   CREATE VIRTUAL TABLE rt USING rtree(id, x1, x2, y1, y2, z1, z2);
30   SELECT * FROM rt WHERE id MATCH cube(0, 0, 0, 2, 2, 2);
33   SELECT * FROM rt WHERE id MATCH cube(3, 3, 3, 2, 2, 2);
48   SELECT id FROM rt WHERE id MATCH cube(2.5, 2.5, 2.5, 1, 1, 1) ORDER BY id;
51   SELECT id FROM rt WHERE id MATCH cube(5.5, 5.5, 5.5, 1, 1, 1) ORDER BY id;
56   CREATE VIRTUAL TABLE rt32 USING rtree_i32(id, x1, x2, y1, y2, z1, z2);
66   SELECT id FROM rt32 WHERE id MATCH cube(3, 3, 3, 1, 1, 1) ORDER BY id;
69   SELECT id FROM rt32 WHERE id MATCH cube(5.5, 5.5, 5.5, 1, 1, 1) ORDER BY id;
74   SELECT id FROM rt32 WHERE id MATCH cube(5.5, 5.5, 1, 1, 1) ORDER BY id;
78     SELECT id FROM rt WHERE id MATCH randomblob($x)
82   SELECT id FROM rt WHERE id MATCH CAST( 
94   CREATE VIRTUAL TABLE rt2 USING rtree(id, xmin, xmax, ymin, ymax);
120   SELECT id FROM rt2 WHERE id MATCH circle(0.0, 0.0, 2.0);
125   SELECT id FROM rt2 WHERE id MATCH circle(5.0, 5.0, 2.0);