Home
last modified time | relevance | path

Searched refs:x0 (Results 1 – 24 of 24) sorted by relevance

/sqlite-3.40.0/ext/rtree/
H A DrtreeI.test29 CREATE VIRTUAL TABLE t2 USING rtree(id,x0,x1);
30 INSERT INTO t2(id,x0,x1) VALUES(1,2,3);
33 SELECT 123 FROM t1, t2 WHERE (a,0)>(x0,0);
36 SELECT 123 FROM t1, t2 WHERE (a,0.1)>(x0,0);
39 SELECT 123 FROM t1, t2 WHERE (a,0)>=(x0,0);
42 SELECT 123 FROM t1, t2 WHERE (a,0)<=(x0,0);
45 SELECT 123 FROM t1, t2 WHERE (a,0)<(x0,0);
48 SELECT 123 FROM t1, t2 WHERE (x0,0)<(a,0);
51 SELECT 123 FROM t1, t2 WHERE (x0,0)<(a,0.1);
54 SELECT 123 FROM t1, t2 WHERE x1<5 AND id<99 AND (a,0)>(x0,0);
[all …]
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);
104 set x0 [expr {int(rand()*(10000 - $dx))}]
105 set x1 [expr {$x0+$dx}]
109 db eval {INSERT INTO t2 VALUES($id,$x0,$x1,$y0,$y1)}
121 set x0 [expr {int(rand()*(10000 - $dx))}]
122 set x1 [expr {$x0+$dx}]
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
467 x0 = GeoX(p,ii); in geopolyXformFunc()
777 double x0, double y0, in pointBeneathLine() argument
784 if( x0<=x1 || x0>x2 ) return 0; in pointBeneathLine()
786 if( x0<=x2 || x0>x1 ) return 0; in pointBeneathLine()
789 if( x0!=x1 ) return 0; in pointBeneathLine()
899 GeoCoord x0, in geopolyAddOneSegment() argument
909 if( x0>x1 ){ in geopolyAddOneSegment()
910 GeoCoord t = x0; in geopolyAddOneSegment()
911 x0 = x1; 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 Drtree1.test665 CREATE VIRTUAL TABLE t16 USING rtree(id,x0,x1,y0,+aux1,x1);
740 CREATE VIRTUAL TABLE rt0 USING rtree(id, x0, x1);
746 SELECT * FROM t1 JOIN t0 ON x0>a RIGHT JOIN rt0 ON true WHERE +x0 = 0;
749 SELECT * FROM t1 JOIN t0 ON x0>a RIGHT JOIN rt0 ON true WHERE x0 = 0;
753 SELECT * FROM t1 JOIN t0 ON true RIGHT JOIN rt0 ON x0>a WHERE +x0 = 0;
756 SELECT * FROM t1 JOIN t0 ON true RIGHT JOIN rt0 ON x0>a WHERE x0 = 0;
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
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 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);
1224 SELECT typeof(x0) FROM intrtree;
/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 {
44 .c create rectangle $x0 $z0 $x1 $z1
51 foreach {id x0 x1 y0 y1 z0 z1} $::data {
H A Dformat4.test41 CREATE TABLE t1(x0,x1,x2,x3,x4,x5,x6,x7,x8,x9);
54 UPDATE t1 SET x0=1, x1=1, x2=1, x3=1, x4=1, x5=1, x6=1, x7=1, x8=1, x9=1
60 UPDATE t1 SET x0=2, x1=2, x2=2, x3=2, x4=2, x5=2, x6=2, x7=2, x8=2, x9=2
H A Dsort.test115 } {x-123.0 x-2.15 x-2b x-3.141592653 x-4221.0 x0.0013442 x1.6 x11.0}
120 } {x-123.0 x-2.15 x-2b x-3.141592653 x-4221.0 x0.0013442 x1.6 x11.0}
125 } {x-4221.0 x-123.0 x-3.141592653 x-2.15 x-2b x0.0013442 x1.6 x11.0}
130 } {x11.0 x1.6 x0.0013442 x-4221.0 x-3.141592653 x-2b x-2.15 x-123.0}
135 } {x11.0 x1.6 x0.0013442 x-2b x-2.15 x-3.141592653 x-123.0 x-4221.0}
205 } {x-123.0 x-2.15 x-2b x-3.141592653 x-4.0e9 x-4221.0 x0.0013442 x01234567890123456789 x1.6 x11.0 x…
210 } {x5.0e10 x2.7 x11.0 x1.6 x01234567890123456789 x0.0013442 x-4221.0 x-4.0e9 x-3.141592653 x-2b x-2…
H A Dfunc4.test64 SELECT tointeger('-0x0');
67 SELECT tointeger('0x0');
238 SELECT toreal('-0x0');
241 SELECT toreal('0x0');
H A Dmisc1.test37 set cmd "CREATE TABLE manycol(x0 text"
52 execsql {SELECT x0, x10, x25, x50, x75 FROM manycol}
290 set ::where {WHERE x0>=0}
300 regsub "x0>=0" $::where "x0=0" ::where
310 execsql {SELECT x1 FROM manycol WHERE x0=100}
313 regsub "x0=0" $::where "x0=100" ::where
317 execsql {SELECT x1 FROM manycol WHERE x0=100}
323 execsql {SELECT x1 FROM manycol WHERE x0=100}
H A Dspeedtest1.c1442 unsigned d, x0, x1, span; in twoCoords() local
1448 x0 = speedtest1_random()%(mx-d) + 1; in twoCoords()
1449 x1 = x0 + d; in twoCoords()
1450 *pX0 = x0; in twoCoords()
1484 unsigned x0, x1, y0, y1, z0, z1; in testset_rtree() local
1497 twoCoords(p1, p2, mxCoord, &x0, &x1); in testset_rtree()
1501 sqlite3_bind_int(g.pStmt, 2, x0); in testset_rtree()
H A Dcsv01.test88 schema='CREATE TABLE x(x0,x1,x2,x3,x4)',
95 } {x0 x1 x2 x3 x4}
H A Dhexlit.test22 hexlit1 100 0x0 0
H A Dalter.test894 CREATE VIRTUAL TABLE t2 USING rtree(id,x0,x1);
H A DcorruptL.test52 | 4064: 65 65 28 69 64 2c 78 30 20 50 52 49 4d 41 52 59 ee(id,x0 PRIMARY
H A De_fkey.test2936 INSERT INTO t0 VALUES('x0', NULL);
/sqlite-3.40.0/ext/rtree/util/
H A Drandomshape.tcl18 set x0 [expr {$cx + rand()*$p3 + $p4}]
19 set ans "\[\[$x0,$cy\]"
28 append ans ",\[$x0,$cy\]\]"
/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
334 x0 = p->aCoord[0]; 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/tool/
H A Dshowwal.c78 unsigned int x0 = a32[0]; in extendCksum() local
81 x0 = swab32(x0); in extendCksum()
84 pCksum->s0 += x0 + pCksum->s1; in extendCksum()