Home
last modified time | relevance | path

Searched refs:y2 (Results 1 – 25 of 35) sorted by relevance

12

/sqlite-3.40.0/ext/rtree/
H A Drtree_perf.tcl19 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]] {
70 foreach {x1 x2 y1 y2} [lrange $data 0 [expr $NQUERY*4-1]] {
H A Dviewrtree.tcl108 foreach {rowid x1 x2 y1 y2} $cell break
112 if {$y2 > $ymax} {set ymax $y2}
143 foreach {rowid x1 x2 y1 y2} $cell break
148 set y2 [expr {$y2*$yscale + $yoff}]
150 set id [.c create rectangle $x1 $y1 $x2 $y2]
168 foreach {rowid x1 x2 y1 y2} $cell break
177 foreach {rowid x1 x2 y1 y2} $cell break
H A Drtree3.test61 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
74 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
88 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2, +a1, +a2);
122 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
152 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
175 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
197 execsql { CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2) }
226 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2, z1, z2);
246 CREATE VIRTUAL TABLE rt USING rtree(ii, x1, x2, y1, y2);
266 faultsim_test_result {1 {rtree constraint failed: rt.(y1<=y2)}} \
H A Drtreedoc.test180 foreach {tn x1 x2 y1 y2 ok} {
190 foreach {tn x1 x2 y1 y2 z1 z2 ok} {
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}
682 foreach {tn 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"
[all …]
H A Drtreedoc3.test48 binary scan $cell WIIII rowid x1 x2 y1 y2
49 lappend res [list $rowid $x1 $x2 $y1 $y2]
217 proc pq_test_result {id x1 x2 y1 y2} {
218 #pq_debug "pq_test_result $id $x1 $x2 $y1 $y2"
232 || $y1!=[lindex $N(aCoord) 2] || $y2!=[lindex $N(aCoord) 3]
271 CREATE VIRTUAL TABLE rt USING rtree_i32(id, x1,x2, y1,y2);
285 db eval { SELECT id, x1,x2, y1,y2 FROM rt WHERE id MATCH qbox() } {
286 pq_test_result $id $x1 $x2 $y1 $y2
H A Drtree1.test58 execsql { CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2) }
80 CREATE VIRTUAL TABLE aux.'a" "b' USING rtree(ii, x1, x2, y1, y2);
185 CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2);
208 } {1 {rtree constraint failed: t1.(y1<=y2)}}
227 CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2);
247 } {1 {rtree constraint failed: t1.(y1<=y2)}}
467 CREATE VIRTUAL TABLE t8 USING rtree(idx, x1, x2, y1, y2);
484 CREATE VIRTUAL TABLE t1 USING rtree_i32(idx, x1, x2, y1, y2);
492 CREATE TABLE source(idx, x1, x2, y1, y2);
650 CREATE VIRTUAL TABLE rt USING rtree(id, x1,x2, y1,y2);
[all …]
H A Dtkt3363.test27 execsql { CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2) }
40 SELECT count(*) FROM t1 WHERE +y2>4000425.0;
46 SELECT count(*) FROM t1 WHERE y2>4000425.0;
H A Drtreeconnect.test30 CREATE VIRTUAL TABLE r1 USING rtree(id, x1, x2, y1, y2);
31 CREATE TABLE t1(id, x1, x2, y1, y2);
35 INSERT INTO r1 VALUES(new.id, new.x1, new.x2, new.y1, new.y2);
H A Drtree7.test43 CREATE VIRTUAL TABLE rt USING rtree(id, x1, x2, y1, y2);
61 execsql_intout { SELECT sum(x1), sum(x2), sum(y1), sum(y2) FROM rt }
67 SELECT sum(x1), sum(x2), sum(y1), sum(y2) FROM rt
H A Drtree5.test28 execsql { CREATE VIRTUAL TABLE t1 USING rtree_i32(id, x1, x2, y1, y2) }
77 y1=-2147483648 AND y2=-2147483643
H A Drtreedoc2.test63 CREATE VIRTUAL TABLE demo_index USING rtree(id, x1,x2, y1,y2);
124 CREATE VIRTUAL TABLE rt2 USING rtree(id, x1,x2, y1,y2);
125 CREATE VIRTUAL TABLE rt3 USING rtree(id, x1,x2, y1,y2, z1,z2);
307 CREATE VIRTUAL TABLE xyz USING rtree(x, x1,x2, y1,y2);
H A DrtreeA.test28 CREATE VIRTUAL TABLE t1 USING rtree(id, x1, x2, y1, y2);
35 set y2 [expr $i+5]
36 execsql { INSERT INTO t1 VALUES($i, $i, $x2, $i, $y2) }
H A Drtree9.test26 CREATE VIRTUAL TABLE rt USING rtree(id, x1, x2, y1, y2, z1, z2);
56 CREATE VIRTUAL TABLE rt32 USING rtree_i32(id, x1, x2, y1, y2, z1, z2);
H A Drtreecheck.test57 CREATE VIRTUAL TABLE r1 USING $module (id, x1, x2, y1, y2);
139 CREATE VIRTUAL TABLE r3 USING rtree_i32(id, x1, x2, y1, y2);
/sqlite-3.40.0/test/
H A Din5.test191 CREATE TABLE y2(c);
197 INSERT INTO y2 VALUES('one');
198 INSERT INTO y2 VALUES('two');
199 INSERT INTO y2 VALUES('three');
203 SELECT a FROM y1 WHERE b NOT IN (SELECT a FROM y2);
206 SELECT a FROM y1 WHERE b IN (SELECT a FROM y2);
210 CREATE INDEX y2c ON y2(c);
211 SELECT a FROM y1 WHERE b NOT IN (SELECT a FROM y2);
214 SELECT a FROM y1 WHERE b IN (SELECT a FROM y2);
H A Dunionall2.test42 CREATE TABLE y2(c INTEGER, d);
50 SELECT * FROM y1 CROSS JOIN y2 WHERE y1.a=y2.c AND y2.c IN (
H A DmallocE.test43 SELECT x, y2 FROM (SELECT a+b AS x, b+c AS y2 FROM t1, t2 WHERE c>5)
44 LEFT JOIN t2 USING(x) WHERE y2>11;
H A Dwith2.test438 ds0(m, n, x, y, x2, y2, title, size, mark, label, markmode) AS (
441 ds(m, n, x, y, x2, y2, title, size, mark, label, markmode) AS (
444 y2,
449 d(m, n, x, y, x2, y2, labelx,labely,title,size,mark,label,markmode) AS (
450 SELECT m, n, x, y, x2, y2, x, y, title, size, mark, label, markmode
459 SELECT coalesce(miny, min(min(y2),
460 min(y))), coalesce(maxy, max(max(y2),
476 SELECT MIN(abs(y2-y)) FROM d WHERE y2 != y
H A Dbackcompat.test455 CREATE VIRTUAL TABLE t1 USING rtree(id, x1, x2, y1, y2);
457 foreach {id x1 x2 y1 y2} {
484 if {$x1 >= $x2 || $y1 >= $y2} { error "$x1 $x2 $y1 $y2" }
485 append contents "INSERT INTO t1 VALUES($id, $x1, $x2, $y1, $y2);"
491 4 "SELECT id FROM t1 WHERE y1>10 AND x1>0 AND x2<50 AND y2<550"
505 INSERT INTO t1 SELECT id+100, x1+10.0, x2+10.0, y1-10.0, y2-10.0 FROM t1;
513 INSERT INTO t1 SELECT id+200, x1+20.0, x2+20.0, y1-20.0, y2-20.0 FROM t1;
H A Djoin5.test191 CREATE TABLE y2(a);
195 SELECT count(z) FROM y1 LEFT JOIN y2 ON x GROUP BY y;
199 SELECT count(z) FROM ( SELECT * FROM y1 ) LEFT JOIN y2 ON x GROUP BY y;
204 SELECT count(z) FROM v1 LEFT JOIN y2 ON x GROUP BY y;
208 SELECT count(z) FROM ( SELECT * FROM y1 ) LEFT JOIN y2 ON x
212 SELECT * FROM ( SELECT * FROM y1 ) LEFT JOIN y2 ON x
H A Dwhere3.test454 CREATE TABLE t72(x2 INTEGER PRIMARY KEY, y2);
470 SELECT x1 FROM t71 LEFT JOIN t72 ON x2=y1 WHERE y2 IS NULL;
473 SELECT x1 FROM t71 LEFT JOIN t72 ON x2=y1 WHERE y2 IS NOT NULL;
476 SELECT x1 FROM t71 LEFT JOIN t72 ON x2=y1 AND y2 IS NULL;
479 SELECT x1 FROM t71 LEFT JOIN t72 ON x2=y1 AND y2 IS NOT NULL;
H A Dmisc3.test309 CREATE TABLE y2(b);
312 INSERT INTO y3(c) SELECT b FROM y2 ORDER BY b LIMIT 1;
320 INSERT INTO y2 SELECT a FROM y1;
H A Dunionvtab.test168 CREATE TEMP TABLE y2(one, two, three INTEGER PRIMARY KEY);
174 2 {y1 y2 y3} {0 {}}
175 3 {x1 y2 y3} {1 {source table schema mismatch}}
176 4 {x1 y2 x3} {1 {source table schema mismatch}}
H A DwhereD.test360 CREATE TABLE y2(x, y);
361 CREATE INDEX y2xy ON y2(x, y);
363 INSERT INTO y2 VALUES(3, 3);
367 SELECT * FROM y1 LEFT JOIN y2 ON ((x=1 AND y=b) OR (x=2 AND y=b))
/sqlite-3.40.0/src/
H A Din-operator.md9 x IN (y1,y2,y3,...,yN)
80 x IN (y1,y2)
84 x=y1 OR x=y2

12