Lines Matching refs:x2

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) }
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);
180 foreach {tn x1 x2 y1 y2 ok} {
187     catch { db eval { INSERT INTO rtF VALUES(NULL, $x1, $x2, $y1, $y2) } }
190 foreach {tn x1 x2 y1 y2 z1 z2 ok} {
199     catch { db eval { INSERT INTO rtI VALUES(NULL,$x1,$x2,$y1,$y2,$z1,$z2) } }
249     typeof(x1), typeof(x2), typeof(y1), typeof(y2), typeof(z1), typeof(z2)
264     typeof(x1), typeof(x2), typeof(y1), typeof(y2)
280   1 t1 "id x1 x2"
281   2 t2 "id x1 x2   y1 y2   z1 z2"
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);
460   4 "DELETE FROM %TBL% WHERE x2=14.5"
677   CREATE VIRTUAL TABLE rt USING rtree(id, x1,x2, y1,y2);
682 foreach {tn x1 x2 y1 y2} {
687   do_execsql_test 3.$tn.1 {INSERT INTO rt VALUES(23, $x1, $x2, $y1, $y2)}
689     SELECT (x2-x1)*(y2-y1) >= ($x2-$x1)*($y2-$y1) FROM rt
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);
1272     binary scan $cell WIIII rowid x1 x2 y1 y2
1273     lappend res [list $rowid $x1 $x2 $y1 $y2]
1349   CREATE VIRTUAL TABLE r1 USING rtree_i32(i, x1,x2, y1,y2);
1400   CREATE VIRTUAL TABLE rtaux USING rtree(id, x1,x2, y1,y2, +e1, +e2);
1472   CREATE VIRTUAL TABLE demo_index USING rtree(id, x1,x2, y1,y2);