Lines Matching refs:y2
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
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)
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}
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"
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);