Home
last modified time | relevance | path

Searched refs:y1 (Results 1 – 25 of 46) sorted by relevance

12

/sqlite-3.40.0/test/
H A Dmisc3.test308 CREATE TABLE y1(a);
314 INSERT INTO y1 VALUES(1);
315 INSERT INTO y1 VALUES(2);
316 INSERT INTO y1 SELECT a+2 FROM y1;
317 INSERT INTO y1 SELECT a+4 FROM y1;
318 INSERT INTO y1 SELECT a+8 FROM y1;
319 INSERT INTO y1 SELECT a+16 FROM y1;
320 INSERT INTO y2 SELECT a FROM y1;
322 SELECT count(*) FROM y1;
327 DELETE FROM y1;
[all …]
H A Dshow_speedtest1_rtree.tcl28 foreach {x0 y0 x1 y1} [.c bbox all] break
35 foreach {id x0 x1 y0 y1 z0 z1} $::data {
36 .c create rectangle $x0 $y0 $x1 $y1
43 foreach {id x0 x1 y0 y1 z0 z1} $::data {
51 foreach {id x0 x1 y0 y1 z0 z1} $::data {
52 .c create rectangle $y0 $z0 $y1 $z1
H A Dshell6.test63 CREATE TABLE y1(a, b, c, FOREIGN KEY(b, a) REFERENCES x1(a, b));
64 CREATE INDEX y1i ON y1(a, c, b);
66 CREATE INDEX 'y1_b_a' ON 'y1'('b', 'a'); --> x1(a,b)
71 CREATE TABLE y1(a COLLATE rtrim REFERENCES x1(a));
73 CREATE INDEX 'y1_a' ON 'y1'('a' COLLATE nocase); --> x1(a)
78 CREATE TABLE y1(a REFERENCES x1);
80 CREATE INDEX 'y1_a' ON 'y1'('a' COLLATE nocase); --> x1(a)
85 CREATE TABLE y1(d, e, f, FOREIGN KEY(d, e, f) REFERENCES x1);
87 CREATE INDEX 'y1_d_e_f' ON 'y1'('d' COLLATE rtrim, 'e' COLLATE nocase, 'f'); --> x1(c,b,a)
H A Dnockpt.test115 CREATE TABLE y1(a PRIMARY KEY, b UNIQUE, c);
116 INSERT INTO y1 VALUES('a', 'b', 'c');
117 INSERT INTO y1 VALUES('d', 'e', 'f');
121 SELECT * FROM y1;
124 UPDATE y1 SET c='g' WHERE a='d';
141 SELECT * FROM y1;
H A Dwith3.test78 CREATE TABLE y1(a, b);
79 CREATE INDEX y1a ON y1(a);
82 INSERT INTO y1 SELECT i%10, i FROM cnt;
89 SELECT * FROM cnt, y1 WHERE i=a
98 `--SEARCH y1 USING INDEX y1a (a=?)
103 SELECT * FROM cnt, y1 WHERE i=a
111 |--SCAN y1
H A Din5.test190 CREATE TABLE y1(a, b);
193 INSERT INTO y1 VALUES(1, 'one');
194 INSERT INTO y1 VALUES('two', 'two');
195 INSERT INTO y1 VALUES(3, '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);
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 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);"
489 2 "SELECT id FROM t1 WHERE y1<100"
490 3 "SELECT id FROM t1 WHERE y1<100 AND x1>0"
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 Dunionall2.test41 CREATE TABLE y1(a INTEGER, b);
50 SELECT * FROM y1 CROSS JOIN y2 WHERE y1.a=y2.c AND y2.c IN (
H A Djoin5.test189 CREATE TABLE y1(x, y, z);
190 INSERT INTO y1 VALUES(0, 0, 1);
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;
203 CREATE VIEW v1 AS SELECT x, y, z FROM y1;
208 SELECT count(z) FROM ( SELECT * FROM y1 ) LEFT JOIN y2 ON x
212 SELECT * FROM ( SELECT * FROM y1 ) LEFT JOIN y2 ON x
/sqlite-3.40.0/ext/rtree/
H A DrtreeE.test31 CREATE VIRTUAL TABLE rt1 USING rtree(id,x0,x1,y0,y1);
96 CREATE TABLE t2(id,x0,x1,y0,y1);
97 CREATE VIRTUAL TABLE rt2 USING rtree(id,x0,x1,y0,y1);
107 set y1 [expr {$y0+$dy}]
109 db eval {INSERT INTO t2 VALUES($id,$x0,$x1,$y0,$y1)}
124 set y1 [expr {$y0+$dy}]
125 …set ans [db eval {SELECT id FROM t2 WHERE x1>=$x0 AND x0<=$x1 AND y1>=$y0 AND y0<=$y1 ORDER BY id}]
127 SELECT id FROM rt2 WHERE id MATCH breadthfirstsearch($x0,$x1,$y0,$y1) ORDER BY id
133 set ans [db eval {SELECT id FROM t2 WHERE x1>=0 AND x0<=5000 AND y1>=0 AND y0<=5000 ORDER BY id}]
137 set ans [db eval {SELECT id FROM t2 WHERE x1>=0 AND x0<=10000 AND y1>=0 AND y0<=10000 ORDER BY id}]
H A Drtree_perf.tcl18 set y1 [expr {rand()*1000}]
20 lappend data $x1 $x2 $y1 $y2
39 foreach {x1 x2 y1 y2} $data {
50 foreach {x1 x2 y1 y2} $data {
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
111 if {$y1 < $ymin} {set ymin $y1}
143 foreach {rowid x1 x2 y1 y2} $cell break
147 set y1 [expr {$y1*$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 DrtreeH.test22 CREATE VIRTUAL TABLE t1 USING rtree(id,x0,x1,y0,y1,+label,+other);
23 INSERT INTO t1(x0,x1,y0,y1,label) VALUES
86 INSERT INTO t1(id, x0,x1,y0,y1,label)
91 SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
97 WHERE x0>=49 AND x1<=50 AND y0>=49 AND y1<=50;
98 SELECT label FROM t1 WHERE x0>=48 AND x1<=50 AND y0>=48 AND y1<=50
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 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 Dgeopoly.c463 GeoCoord x1, y1, x0, y0; in geopolyXformFunc() local
472 GeoY(p,ii) = y1; in geopolyXformFunc()
778 double x1, double y1, in pointBeneathLine() argument
782 if( x0==x1 && y0==y1 ) return 2; in pointBeneathLine()
790 if( y0<y1 && y0<y2 ) return 0; in pointBeneathLine()
794 y = y1 + (y2-y1)*(x0-x1)/(x2-x1); in pointBeneathLine()
902 GeoCoord y1, in geopolyAddOneSegment() argument
914 y0 = y1; in geopolyAddOneSegment()
915 y1 = t; in geopolyAddOneSegment()
919 pSeg->C = (y1-y0)/(x1-x0); in geopolyAddOneSegment()
[all …]
H A DrtreeG.test31 CREATE VIRTUAL TABLE t1 USING rtree(id,x0,x1,y0,y1);
39 SELECT id from t1 WHERE x0>8 AND x1<16 AND y0>2 AND y1<25;
49 SELECT id from t1 WHERE x0>8 AND x1<16 AND y0>2 AND y1<25;
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 DrtreeC.test126 CREATE VIRTUAL TABLE t3 USING rtree(z, x1,x2, y1,y2);
306 CREATE TABLE ydir(y1);
326 ON (y1 BETWEEN ymin AND ymax)
339 ON (y1 BETWEEN ymin AND ymax)
354 ON (y1 BETWEEN ymin AND ymax)
367 ON (y1 BETWEEN ymin AND ymax)
H A DrtreeB.test25 CREATE VIRTUAL TABLE t1 USING rtree(ii, x0, y0, x1, y1);
37 CREATE VIRTUAL TABLE t1 USING rtree(ii, x0, y0, x1, y1);
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5rank.test105 CREATE VIRTUAL TABLE y1 USING fts5(z, detail=%DETAIL%);
106 INSERT INTO y1 VALUES('test xyz');
107 INSERT INTO y1 VALUES('test test xyz test');
108 INSERT INTO y1 VALUES('test test xyz');
112 SELECT rowid FROM y1('test OR tset');
116 SELECT rowid FROM y1('test OR tset') ORDER BY bm25(y1)
120 SELECT rowid FROM y1('test OR tset') ORDER BY +rank
124 SELECT rowid FROM y1('test OR tset') ORDER BY rank
128 SELECT rowid FROM y1('test OR xyz') ORDER BY rank
/sqlite-3.40.0/src/
H A Dtest_rtree.c330 double x0,x1,y0,y1; /* Dimensions of box being tested */ in bfs_query_func() local
337 y1 = p->aCoord[3]; in bfs_query_func()
345 }else if( x0>=bx0 && x1<=bx1 && y0>=by0 && y1<=by1 ){ in bfs_query_func()
347 }else if( x1>=bx0 && x0<=bx1 && y1>=by0 && y0<=by1 ){ in bfs_query_func()

12