Home
last modified time | relevance | path

Searched refs:x1 (Results 1 – 25 of 185) sorted by relevance

12345678

/sqlite-3.40.0/ext/rtree/
H A Drtree6.test129 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
130 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
131 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
132 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
133 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
134 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5;
140 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
141 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
142 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND
143 x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5 AND x1>0.5
[all …]
H A Drtree1.test138 CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2);
211 } {1 {rtree constraint failed: t1.(x1<=x2)}}
378 CREATE VIRTUAL TABLE t6 USING rtree(ii, x1, x2);
492 CREATE TABLE source(idx, x1, x2, y1, y2);
552 set res(2) {1 {rtree constraint failed: t1.(x1<=x2)}}
590 CREATE VIRTUAL TABLE t10 USING rtree(ii, x1, x2);
634 CREATE VIRTUAL TABLE t10 USING rtree_i32(ii, x1, x2);
650 CREATE VIRTUAL TABLE rt USING rtree(id, x1,x2, y1,y2);
665 CREATE VIRTUAL TABLE t16 USING rtree(id,x0,x1,y0,+aux1,x1);
692 CREATE VIRTUAL TABLE rt1 USING rtree(id, x1, x2, +aux);
[all …]
H A Drtree5.test28 execsql { CREATE VIRTUAL TABLE t1 USING rtree_i32(id, x1, x2, y1, y2) }
37 execsql { SELECT typeof(x1) FROM t1 }
41 execsql { SELECT x1==5 FROM t1 }
44 execsql { SELECT x1==5.2 FROM t1 }
47 execsql { SELECT x1==5.0 FROM t1 }
51 execsql { SELECT count(*) FROM t1 WHERE x1==5 }
55 execsql { SELECT count(*) FROM t1 WHERE x1==5.2 }
59 execsql { SELECT count(*) FROM t1 WHERE x1==5.0 }
76 x1=2147483643 AND x2=2147483647 AND
H A DrtreeI.test29 CREATE VIRTUAL TABLE t2 USING rtree(id,x0,x1);
30 INSERT INTO t2(id,x0,x1) VALUES(1,2,3);
54 SELECT 123 FROM t1, t2 WHERE x1<5 AND id<99 AND (a,0)>(x0,0);
57 SELECT 123 FROM t1, t2 WHERE x1<5 AND id<99 AND (a,0.5)>(x0,0);
60 SELECT 123 FROM t1, t2 WHERE x1<5 AND id<99 AND (a,0)>=(x0,0);
63 SELECT 123 FROM t1, t2 WHERE x1<5 AND id<99 AND (a,0)<(x0,0);
66 SELECT 123 FROM t1, t2 WHERE 5>x1 AND 99>id AND (x0,0)<(a,0);
69 SELECT 123 FROM t1, t2 WHERE 5>x1 AND 99>id AND (x0,0)<(a,0.5);
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);
105 set x1 [expr {$x0+$dx}]
109 db eval {INSERT INTO t2 VALUES($id,$x0,$x1,$y0,$y1)}
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
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}]
/sqlite-3.40.0/ext/lsm1/test/
H A Dlsm1_simple.test24 PRAGMA table_info(x1);
42 UPDATE x1 SET d = d+1.0 WHERE a=15;
55 DELETE FROM x1 WHERE a=15;
76 PRAGMA table_info(x1);
103 SELECT * FROM x1 WHERE a=?
107 SELECT * FROM x1 WHERE a>?
111 SELECT * FROM x1 WHERE a<?
123 INSERT INTO x1 VALUES('one', 1);
124 INSERT INTO x1 VALUES('two', 2);
130 SELECT b FROM x1 WHERE a = 'two'
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5fault1.test144 SELECT count(*) FROM x1 WHERE x1.a LIKE '%abc%' OR x1.b LIKE '%abc%'}
148 execsql { SELECT count(*) FROM x1 WHERE x1 MATCH 'abc' }
153 execsql { SELECT count(*) FROM x1 WHERE x1 MATCH 'abcd' }
165 execsql { SELECT count(*) FROM x1 WHERE x1 MATCH 'a*' }
217 INSERT INTO x1(x1, rank) VALUES('automerge', 0);
219 INSERT INTO x1 VALUES('a b c'); -- 1
220 INSERT INTO x1 VALUES('a b c'); -- 2
255 execsql { INSERT INTO x1(x1, rank) VALUES('pgsz', 32) }
263 execsql { INSERT INTO x1(x1) VALUES('integrity-check') }
271 execsql { INSERT INTO x1(x1) VALUES('optimize') }
[all …]
H A Dfts5simple.test345 INSERT INTO x1(x1, rank) VALUES('pgsz', 32);
352 SELECT rowid, x, x1 FROM x1 WHERE x1 MATCH '*reads'
416 INSERT INTO x1(x1, rank) VALUES('pgsz', 32);
423 execsql { INSERT INTO x1(x1) VALUES('optimize'); }
427 INSERT INTO x1(x1) VALUES('optimize');
428 INSERT INTO x1(x1) VALUES('integrity-check');
435 INSERT INTO x1(x1, rank) VALUES('pgsz', 32);
446 INSERT INTO x1(x1) VALUES('optimize');
447 INSERT INTO x1(x1) VALUES('integrity-check');
459 INSERT INTO x1(x1) VALUES('integrity-check');
[all …]
H A Dfts5ubsan.test25 CREATE VIRTUAL TABLE x1 USING fts5(x);
33 INSERT INTO x1 (rowid, x) VALUES($BIG, 'aaa aba acc');
34 INSERT INTO x1 (rowid, x) VALUES($SMALL, 'aaa abc acb');
39 SELECT rowid, x FROM x1('ab*');
43 SELECT rowid, x FROM x1('ac*');
48 CREATE VIRTUAL TABLE x1 USING fts5(x);
52 INSERT INTO x1 (rowid, x) VALUES($BIG, 'aaa aba acc');
53 INSERT INTO x1 (rowid, x) VALUES($SMALL, 'aaa abc acb');
57 INSERT INTO x1 (x1) VALUES('optimize');
H A Dfts5first.test22 CREATE VIRTUAL TABLE x1 USING fts5(a, b);
39 do_catchsql_test 1.$tn { SELECT * FROM x1($expr) } $res($ok)
45 INSERT INTO x1 VALUES('a b c', 'b c a');
60 do_execsql_test 2.$tn { SELECT EXISTS (SELECT rowid FROM x1($expr)) } $match
66 DELETE FROM x1;
67 INSERT INTO x1 VALUES('b a', 'c a');
68 INSERT INTO x1 VALUES('a a', 'c c');
69 INSERT INTO x1 VALUES('a b', 'a a');
78 SELECT fts5_test_queryphrase(x1) FROM x1($expr) LIMIT 1
/sqlite-3.40.0/test/
H A Dfts3first.test40 CREATE VIRTUAL TABLE x1 USING FTS4(a, b, c);
41 INSERT INTO x1(docid,a,b,c) VALUES(0, 'K H D S T', 'V M N Y K', 'S Z N Q S');
42 INSERT INTO x1(docid,a,b,c) VALUES(1, 'K N J L W', 'S Z W J Q', 'D U W S E');
43 INSERT INTO x1(docid,a,b,c) VALUES(2, 'B P M O I', 'R P H W S', 'R J L L E');
44 INSERT INTO x1(docid,a,b,c) VALUES(3, 'U R Q M L', 'M J K A V', 'Q W J T J');
45 INSERT INTO x1(docid,a,b,c) VALUES(4, 'N J C Y N', 'R U D X V', 'B O U A Q');
63 INSERT INTO x2(docid, a, b, c) SELECT docid, a, b, c FROM x1;
87 do_execsql_test 1.$x.$tn.1 {SELECT docid FROM x1 WHERE x1 MATCH $match} $res
92 INSERT INTO x1(x1) VALUES('optimize');
107 SELECT snippet(x1, '[', ']', '...') FROM x1 WHERE x1 MATCH $match
[all …]
H A De_blobclose.test25 INSERT INTO x1 VALUES(-1, $dots);
26 INSERT INTO x1 VALUES(-10, $dots);
27 INSERT INTO x1 VALUES(-100, $dots);
28 INSERT INTO x1 VALUES(-1000, $dots);
29 INSERT INTO x1 VALUES(-10000, $dots);
40 sqlite3_blob_open db main x1 b -1 0 B
59 sqlite3_blob_open db main x1 b -100 1 B1
124 sqlite3_blob_open db main x1 b -10 1 B
126 INSERT INTO x1 VALUES(1, 'abc');
127 SELECT * FROM x1 WHERE a=1;
[all …]
H A Dupfrom2.test231 INSERT INTO x1 VALUES
245 SELECT * FROM x1;
252 SELECT * FROM x1;
268 DROP TABLE x1;
270 INSERT INTO x1 VALUES
277 SELECT * FROM x1;
285 SELECT * FROM x1;
359 1 "UPDATE x1 SET a=5 FROM x1" x1
360 2 "UPDATE x1 AS grapes SET a=5 FROM x1 AS grapes" grapes
361 3 "UPDATE x1 SET a=5 FROM x2, x1" x1
[all …]
H A DcollateB.test22 SELECT * FROM t3, t2, t1 WHERE x2=b AND x1=a AND a=1;
26 INSERT INTO t2(b,x1) VALUES(11,1),(22,2),(33,3);
28 SELECT *,'|' FROM t3, t2, t1 WHERE x2=b AND x1=a AND a=1;
31 SELECT *,'|' FROM t3, t1, t2 WHERE x2=b AND x1=a AND a=1;
34 SELECT *,'|' FROM t2, t3, t1 WHERE x2=b AND x1=a AND a=1;
37 SELECT *,'|' FROM t2, t1, t3 WHERE x2=b AND x1=a AND a=1;
40 SELECT *,'|' FROM t1, t2, t3 WHERE x2=b AND x1=a AND a=1;
43 SELECT *,'|' FROM t1, t2, t3 WHERE x2=b AND x1=a AND a=1;
46 SELECT *,'|' FROM t3, t2, t1 WHERE b=x2 AND a=x1 AND 1=a;
49 SELECT *,'|' FROM t3, t1, t2 WHERE b=x2 AND a=x1 AND 1=a;
[all …]
H A Dspeedtest1.c747 x1 = swizzle(i,maxb); in testset_main()
766 x1 = swizzle(i,maxb); in testset_main()
785 x1 = swizzle(i,maxb); in testset_main()
1115 x1 = swizzle(i,maxb); in testset_main()
1135 x1 = swizzle(i,maxb); in testset_main()
1449 x1 = x0 + d; in twoCoords()
1451 *pX1 = x1; in twoCoords()
1669 unsigned x1, len; in testset_orm() local
2137 unsigned x1, x2; in testset_debug1() local
2142 x1 = swizzle(i, n); in testset_debug1()
[all …]
H A Dupfrom3.test50 CREATE TABLE x1(o, n);
51 INSERT INTO x1 VALUES(1, 11);
52 INSERT INTO x1 VALUES(2, 12);
53 INSERT INTO x1 VALUES(3, 13);
54 INSERT INTO x1 VALUES(4, 14);
67 INSERT INTO x1 VALUES(11, 21);
68 INSERT INTO x1 VALUES(12, 22);
69 INSERT INTO x1 VALUES(13, 23);
70 INSERT INTO x1 VALUES(14, 24);
72 INSERT INTO x1 VALUES(21, 31);
[all …]
H A Dfts4merge5.test33 CREATE VIRTUAL TABLE x1 USING fts3;
34 INSERT INTO x1(x1) VALUES('nodesize=64');
35 INSERT INTO x1(x1) VALUES('maxpending=64');
39 INSERT INTO x1(docid, content) SELECT * FROM t1;
45 INSERT INTO x1(x1) VALUES('merge=1,2');
52 INSERT INTO x1(x1) VALUES('integrity-check');
H A Dquota2.test27 foreach dir {quota2a/x1 quota2a/x2 quota2a quota2b quota2c} {
30 foreach dir {quota2a quota2a/x1 quota2a/x2 quota2b quota2c} {
240 set ::h1 [sqlite3_quota_fopen quota2a/x1/a.txt a]
245 } {{*/quota2a/* 4000 100 {PWD/quota2a/x1/a.txt 100 1 0}}}
268 set ::h3 [sqlite3_quota_fopen quota2a/x1/c.txt a]
271 } {{*/quota2a/* 4000 800 {PWD/quota2a/x1/c.txt 500 1 0} {PWD/quota2a/x2/b.txt 200 1 0} {PWD/quota2a…
273 file exists quota2a/x1/a.txt
279 file exists quota2a/x1/c.txt
282 sqlite3_quota_remove quota2a/x1
291 file exists quota2a/x1/a.txt
[all …]
H A Dshell6.test62 CREATE TABLE x1(a, b, c, UNIQUE(a, b));
63 CREATE TABLE y1(a, b, c, FOREIGN KEY(b, a) REFERENCES x1(a, b));
66 CREATE INDEX 'y1_b_a' ON 'y1'('b', 'a'); --> x1(a,b)
70 CREATE TABLE x1(a COLLATE nocase, b, UNIQUE(a));
71 CREATE TABLE y1(a COLLATE rtrim REFERENCES x1(a));
73 CREATE INDEX 'y1_a' ON 'y1'('a' COLLATE nocase); --> x1(a)
77 CREATE TABLE x1(a PRIMARY KEY COLLATE nocase, b);
78 CREATE TABLE y1(a REFERENCES x1);
80 CREATE INDEX 'y1_a' ON 'y1'('a' COLLATE nocase); --> x1(a)
84 CREATE TABLE x1(a, b COLLATE nocase, c COLLATE rtrim, PRIMARY KEY(c, b, a));
[all …]
H A Dcursorhint2.test105 CREATE TABLE x1(x, y);
110 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE b IS NULL;
116 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE b IS +NULL;
122 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 1 = (b IS NULL)
128 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 1 = coalesce(b, 1)
134 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE 1 = coalesce(b, 1)
155 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE b IS NOT +NULL
161 SELECT * FROM x1 LEFT JOIN x2 ON (a=x)
168 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE x2.b = 32+32
176 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE x2.b LIKE 'abc%'
[all …]
H A DselectD.test44 } {111 x1 222 x2 333 x3 444 x4}
52 } {111 x1 222 x2 333 x3 444 x4}
84 } {111 x1 222 x2 444 x4 555 x5}
92 } {111 x1 222 x2 444 x4 555 x5}
117 } {111 x1 x2 x3 x4}
128 } {111 x1 x2 x3 x4}
137 } {111 x1 x2 222 x3 x4}
145 } {111 x1 x2 222 x3 {}}
152 } {111 x1 111 x2 222 x3 {}}
169 WHERE x1.d>5
[all …]
H A DwhereD.test276 CREATE TABLE x1(a, b, c, d, e);
277 CREATE INDEX x1a ON x1(a);
278 CREATE INDEX x1bc ON x1(b, c);
279 CREATE INDEX x1cd ON x1(c, d);
281 INSERT INTO x1 VALUES(1, 2, 3, 4, 'A');
282 INSERT INTO x1 VALUES(5, 6, 7, 8, 'B');
288 SELECT e FROM x1 WHERE b=2 OR c=7;
291 SELECT c FROM x1 WHERE b=2 OR c=7;
295 SELECT e FROM x1 WHERE a=1 OR b=10;
298 SELECT c FROM x1 WHERE a=1 OR b=10;
[all …]
H A Dwherelimit2.test205 CREATE INDEX x1bc ON x1(b, c);
206 INSERT INTO x1 VALUES(1,1,1,1);
207 INSERT INTO x1 VALUES(2,1,2,2);
208 INSERT INTO x1 VALUES(3,2,1,3);
209 INSERT INTO x1 VALUES(4,2,2,3);
210 INSERT INTO x1 VALUES(5,3,1,2);
211 INSERT INTO x1 VALUES(6,3,2,1);
216 DELETE FROM x1 ORDER BY a LIMIT 2;
217 SELECT a FROM x1;
229 SELECT a FROM x1;
[all …]
H A Dscanstatus.test96 CREATE TABLE x1(i INTEGER PRIMARY KEY, j);
97 INSERT INTO x1 VALUES(1, 'one');
98 INSERT INTO x1 VALUES(2, 'two');
99 INSERT INTO x1 VALUES(3, 'three');
100 INSERT INTO x1 VALUES(4, 'four');
101 CREATE INDEX x1j ON x1(j);
103 SELECT * FROM x1 WHERE i=2;
107 nLoop 1 nVisit 1 nEst 1.0 zName x1
112 SELECT * FROM x1 WHERE j='two'
120 SELECT * FROM x1 WHERE j<'two'
[all …]
/sqlite-3.40.0/ext/rbu/
H A Drbuvacuum4.test71 CREATE TABLE x1(a, b, c, d, PRIMARY KEY(c, b)) WITHOUT ROWID;
72 INSERT INTO x1 VALUES(1, 1, 1, 1);
73 INSERT INTO x1 VALUES(1, 1, 2, 1);
74 INSERT INTO x1 VALUES(1, 2, 2, 1);
76 INSERT INTO x1 VALUES(NULL, 2, 3, NULL);
77 INSERT INTO x1 VALUES(NULL, 2, 4, NULL);
78 INSERT INTO x1 VALUES(NULL, 2, 5, NULL);
80 CREATE INDEX x1ad ON x1(d, a);
81 CREATE INDEX x1null ON x1(d, a) WHERE d>15;
87 SELECT count(*) fROM x1

12345678