Home | History | Annotate | Download | only in rtree

Lines Matching refs:y2

19   set y2 [expr {$y1+rand()*50}]
20 lappend data $x1 $x2 $y1 $y2
25 set sql1 {CREATE TABLE btree(ii INTEGER PRIMARY KEY, x1, x2, y1, y2)}
26 set sql2 {CREATE VIRTUAL TABLE rtree USING rtree(ii, x1, x2, y1, y2)}
39 foreach {x1 x2 y1 y2} $data {
40 db eval {INSERT INTO btree VALUES($ii, $x1, $x2, $y1, $y2)}
50 foreach {x1 x2 y1 y2} $data {
52 db eval {INSERT INTO rtree VALUES($ii, $x1, $x2, $y1, $y2)}
61 foreach {x1 x2 y1 y2} [lrange $data 0 [expr $NQUERY*4-1]] {
62 db eval {SELECT * FROM btree WHERE x1<$x1 AND x2>$x2 AND y1<$y1 AND y2>$y2}
70 foreach {x1 x2 y1 y2} [lrange $data 0 [expr $NQUERY*4-1]] {
71 db eval {SELECT * FROM rtree WHERE x1<$x1 AND x2>$x2 AND y1<$y1 AND y2>$y2}