Lines Matching refs:id
52 do_execsql_test 1.1.1 { CREATE VIRTUAL TABLE rt1 USING rtree(id, x1,x2) }
56 do_execsql_test 1.2.1 { CREATE VIRTUAL TABLE rt2 USING rtree(id,x1,x2, y1,y2) }
61 CREATE VIRTUAL TABLE rt3 USING rtree(id, x1,x2, y1,y2, z1,z2)
67 CREATE VIRTUAL TABLE rt4 USING rtree(id, x1,x2, y1,y2, z1,z2, v1,v2)
73 CREATE VIRTUAL TABLE rt5 USING rtree(id, x1,x2, y1,y2, z1,z2, v1,v2, w1,w2)
84 id, x1,x2, y1,y2, z1,z2, v1,v2, w1,w2, a1,a2
89 id, x1,x2, y1,y2, z1,z2, v1,v2, w1,w2, a1,a2, b1, b2
126 do_execsql_test 4.0 { CREATE VIRTUAL TABLE rt USING rtree(id, x1, x2) }
145 SELECT typeof(id), id FROM rt
157 do_execsql_test 5.2 { SELECT id FROM rt } {100 101}
166 SELECT id IN(100, 101, 9223372036854775807) FROM rt ORDER BY 1;
177 CREATE VIRTUAL TABLE rtF USING rtree(id, x1,x2, y1,y2);
178 CREATE VIRTUAL TABLE rtI USING rtree_i32(id, x1,x2, y1,y2, z1,z2);
280 1 t1 "id x1 x2"
281 2 t2 "id x1 x2 y1 y2 z1 z2"
311 # VIRTUAL TABLE demo_index USING rtree( id, -- Integer primary key minX,
316 id, -- Integer primary key
378 1 {(id TEXT, x1 TEXT, x2 TEXT, y1 TEXT, y2 TEXT)} {id x1 x2 y1 y2}
379 2 {(id TEXT, x1 UNIQUE, x2 TEXT, y1 NOT NULL, y2 TEXT)} {id x1 x2 y1 y2}
380 3 {(id, x1 DEFAULT 4, x2 TEXT, y1 NOT NULL, y2 TEXT)} {id x1 x2 y1 y2}
453 CREATE VIRTUAL TABLE rt USING rtree(id, x1, x2);
454 CREATE TABLE t1(id INTEGER PRIMARY KEY, x1 REAL, x2 REAL);
459 3 "UPDATE %TBL% SET x1=-99 WHERE id=11"
478 id, -- Integer primary key
554 # efficient: SELECT * FROM demo_index WHERE id=28269;
555 do_vmstep_test 2.2 { SELECT * FROM demo_index WHERE id=28269 } {$step < 100}
563 SELECT id FROM demo_index
573 SELECT id FROM demo_index
581 # boxes that overlap with the 28269 zipcode: SELECT A.id FROM demo_index
583 # AND A.maxY>=B.minY AND A.minY<=B.maxY AND B.id=28269;
595 SELECT A.id FROM demo_index AS A, demo_index AS B
598 AND B.id=28269
601 SELECT A.id FROM demo_index AS A, demo_index AS B
604 AND B.id=28269;
616 # objects that overlap with the 35th parallel: SELECT id FROM demo_index
619 SELECT id FROM demo_index
623 SELECT id FROM demo_index
645 CREATE VIRTUAL TABLE rt USING rtree(id, a,b);
677 CREATE VIRTUAL TABLE rt USING rtree(id, x1,x2, y1,y2);
710 CREATE VIRTUAL TABLE rt USING rtree(id, minX, maxX);
719 set res1o [db eval {SELECT * FROM rt WHERE maxX < 30 ORDER BY +id}]
724 set res2o [db eval {SELECT * FROM rt WHERE maxX < 30 ORDER BY +id}]
754 # runs one query against an R-Tree like this: SELECT id FROM demo_index
755 # WHERE maxY>=35.0 AND minY<=35.0; Then for each "id" value
757 # following and binds the "id" value returned against the "?1"
758 # parameter: UPDATE demo_index SET maxY=maxY+0.5 WHERE id=?1;
764 id, -- Integer primary key
775 db eval { SELECT id FROM demo_index WHERE maxY>=35.0 AND minY<=35.0 } {
777 db eval { UPDATE demo_index SET maxY=maxY+0.5 WHERE id=$id }
831 db eval { SELECT * FROM rt ORDER BY +id } {
847 # auxiliary table as follows: CREATE TABLE demo_data( id INTEGER PRIMARY
855 id INTEGER PRIMARY KEY, -- primary key
864 id, -- Integer primary key
898 INSERT INTO demo_data(id) SELECT id FROM demo_index;
910 # demo_data.id=demo_index.id AND contained_in(demo_data.boundary,
915 WHERE demo_data.id=demo_index.id
977 id, u1,u2, v1,v2, +aux
998 1 "id x1,x2, +extra, y1,y2"
999 2 "extra, +id x1,x2, y1,y2"
1000 3 "id, x1,+x2, extra, y1,y2"
1007 CREATE VIRTUAL TABLE rrr USING rtree(+id, extra, x1, x2);
1076 id, -- Integer primary key
1086 id, -- Integer primary key
1091 id INTEGER PRIMARY KEY, -- primary key
1097 INSERT INTO demo_index2(id) VALUES(1);
1098 INSERT INTO demo_index(id) VALUES(1);
1099 INSERT INTO demo_data(id) VALUES(1);
1116 INSERT INTO demo_index2(id,minX,maxX,minY,maxY) VALUES
1220 # USING rtree_i32(id,x0,x1,y0,y1,z0,z1);
1222 CREATE VIRTUAL TABLE intrtree USING rtree_i32(id,x0,x1,y0,y1,z0,z1);
1400 CREATE VIRTUAL TABLE rtaux USING rtree(id, x1,x2, y1,y2, +e1, +e2);
1436 CREATE VIRTUAL TABLE rt1 USING rtree(id, a, b);
1443 CREATE VIRTUAL TABLE aux.rt1 USING rtree(id, a, b);
1472 CREATE VIRTUAL TABLE demo_index USING rtree(id, x1,x2, y1,y2);
1473 INSERT INTO demo_index SELECT id, a, b, a, b FROM rt1;
1483 CREATE VIRTUAL TABLE rt2 USING rtree_i32(id, a, b, c, d);