Home
last modified time | relevance | path

Searched refs:y0 (Results 1 – 14 of 14) sorted by relevance

/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);
106 set y0 [expr {int(rand()*(10000 - $dy))}]
107 set y1 [expr {$y0+$dy}]
109 db eval {INSERT INTO t2 VALUES($id,$x0,$x1,$y0,$y1)}
123 set y0 [expr {int(rand()*(10000 - $dy))}]
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
[all …]
H A Dgeopoly.c463 GeoCoord x1, y1, x0, y0; in geopolyXformFunc() local
468 y0 = GeoY(p,ii); in geopolyXformFunc()
777 double x0, double y0, in pointBeneathLine() argument
790 if( y0<y1 && y0<y2 ) return 0; in pointBeneathLine()
791 if( y0>y1 && y0>y2 ) return 0; in pointBeneathLine()
795 if( y0==y ) return 2; in pointBeneathLine()
796 if( y0<y ) return 1; in pointBeneathLine()
900 GeoCoord y0, in geopolyAddOneSegment() argument
913 t = y0; in geopolyAddOneSegment()
914 y0 = y1; in geopolyAddOneSegment()
[all …]
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 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 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);
H A Drtree6.test174 CREATE VIRTUAL TABLE t1 USING rtree(id,x0,x1,y0,y1);
177 DELETE FROM t1 WHERE x0>1 AND x1<2 OR y0<92;
H A Drtreefuzz001.test58 | 4064: 65 65 28 69 64 2c 78 30 2c 78 31 2c 79 30 2c 79 ee(id,x0,x1,y0,y
505 | 4064: 65 65 28 69 64 2c 78 30 2c 78 31 2c 79 30 2c 79 ee(id,x0,x1,y0,y
561 INSERT INTO t1(id, x0,x1,y0,y1,label)
602 | 4064: 65 65 28 69 64 2c 78 30 2c 78 31 2c 79 30 2c 79 ee(id,x0,x1,y0,y
668 } {1 {rtree constraint failed: t1.(y0<=y1)}}
707 | 4064: 65 65 28 69 64 2c 78 30 2c 78 31 2c 79 30 2c 79 ee(id,x0,x1,y0,y
773 INSERT INTO t1(id, x0,x1,y0,y1,label)
808 | 4016: 5f 69 33 32 28 69 cc 2c 78 30 2c 78 31 2c 79 30 _i32(i.,x0,x1,y0
H A Drtree1.test665 CREATE VIRTUAL TABLE t16 USING rtree(id,x0,x1,y0,+aux1,x1);
H A Drtreedoc.test1220 # USING rtree_i32(id,x0,x1,y0,y1,z0,z1);
1222 CREATE VIRTUAL TABLE intrtree USING rtree_i32(id,x0,x1,y0,y1,z0,z1);
/sqlite-3.40.0/test/
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 Dspeedtest1.c653 int y0 = x/2; in est_square_root() local
656 for(n=0; y0>0 && n<10; n++){ in est_square_root()
657 y1 = (y0 + x/y0)/2; in est_square_root()
658 if( y1==y0 ) break; in est_square_root()
659 y0 = y1; in est_square_root()
661 return y0; in est_square_root()
1484 unsigned x0, x1, y0, y1, z0, z1; in testset_rtree() local
1498 twoCoords(p1, p2, mxCoord, &y0, &y1); in testset_rtree()
1503 sqlite3_bind_int(g.pStmt, 4, y0); in testset_rtree()
H A Djoin8.test434 CREATE TABLE y0(a INT);
440 SELECT * FROM y0 RIGHT JOIN y1 ON true INNER JOIN y2 ON true WHERE y2.c!=99 AND y2.c!=98;
/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
336 y0 = p->aCoord[2]; 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()
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5corrupt3.test13688 | 2384: 04 81 21 01 04 81 29 02 04 84 4b 03 02 79 30 09 ..!...)...K..y0.