Home
last modified time | relevance | path

Searched refs:x2 (Results 1 – 25 of 117) sorted by relevance

12345

/sqlite-3.40.0/test/
H A Dcursorhint2.test112 x2 {EQ(c0,r[2])}
118 x2 {EQ(c0,r[2])}
124 x2 {EQ(c0,r[2])}
130 x2 {EQ(c0,r[2])}
136 x2 {EQ(c0,r[2])}
145 x2 {EQ(c0,r[2])}
151 x2 {EQ(c0,r[2])}
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%'
184 SELECT * FROM x1 LEFT JOIN x2 ON (a=x) WHERE coalesce(x2.b, 1)
[all …]
H A Dnormalize.test136 0x2
141 0x2
150 0x2
161 0x2
167 0x2
173 0x2
178 0x2
183 0x2
189 0x2
194 0x2
[all …]
H A DcollateB.test21 CREATE TABLE t3(x2 INT);
22 SELECT * FROM t3, t2, t1 WHERE x2=b AND x1=a AND a=1;
27 INSERT INTO t3(x2) VALUES(11),(22),(33);
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;
[all …]
H A Dsqldiff1.test33 ATTACH 'test2.db' AS x2;
34 DELETE FROM x2.t1 WHERE a=49;
35 DELETE FROM x2.t2 WHERE a=48;
36 INSERT INTO x2.t1(a,b) VALUES(1234,'hello');
37 INSERT INTO x2.t2(a,b) VALUES(50.5,'xyzzy');
38 INSERT INTO x2.t2(a,b) VALUES(51.5,'');
39 INSERT INTO x2.t2(a,b) VALUES(52.5,''||X'0d0a');
40 INSERT INTO x2.t2(a,b) VALUES(53.5,'one'||X'0a0d');
41 INSERT INTO x2.t2(a,b) VALUES(54.5,'one'||X'0a'||'two');
42 CREATE TABLE x2.t3(a,b,c);
[all …]
H A Dfts3defer.test474 INSERT INTO x2 SELECT * FROM x2;
475 INSERT INTO x2 SELECT * FROM x2;
476 INSERT INTO x2 SELECT * FROM x2;
477 INSERT INTO x2 SELECT * FROM x2;
478 INSERT INTO x2 SELECT * FROM x2;
479 INSERT INTO x2 SELECT * FROM x2;
480 INSERT INTO x2 SELECT * FROM x2;
481 INSERT INTO x2 SELECT * FROM x2;
482 INSERT INTO x2 SELECT * FROM x2;
483 INSERT INTO x2 SELECT * FROM x2;
[all …]
H A DselectD.test44 } {111 x1 222 x2 333 x3 444 x4}
52 } {111 x1 222 x2 333 x3 444 x4}
76 } {333 x3 222 x2}
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 {}}
[all …]
H A Dfts4growth.test107 CREATE VIRTUAL TABLE x2 USING fts4;
130 INSERT INTO x2(x2) VALUES('merge=4,4');
137 INSERT INTO x2(x2) VALUES('merge=4,4');
139 INSERT INTO x2(x2) VALUES('merge=4,4');
150 INSERT INTO x2(x2) VALUES('merge=1000,4');
286 DROP TABLE IF EXISTS x2;
289 CREATE VIRTUAL TABLE x2 USING fts4;
303 execsql { DELETE FROM x2 WHERE docid = $d }
307 INSERT INTO x2(x2) VALUES('optimize');
318 INSERT INTO x2 SELECT words FROM t1 LIMIT 50;
[all …]
H A Dsavepoint7.test32 SAVEPOINT x2;
35 RELEASE x2;
45 SAVEPOINT x2;
47 RELEASE x2;
57 SAVEPOINT x2;
59 RELEASE x2;
73 SAVEPOINT x2;
75 ROLLBACK TO x2;
88 SAVEPOINT x2;
91 ROLLBACK TO x2;
H A Dfts3first.test62 CREATE VIRTUAL TABLE x2 USING FTS4(a, b, c, order=DESC);
63 INSERT INTO x2(docid, a, b, c) SELECT docid, a, b, c FROM x1;
88 do_execsql_test 1.$x.$tn.2 {SELECT docid FROM x2 WHERE x2 MATCH $match} $rev
93 INSERT INTO x2(x2) VALUES('optimize');
111 SELECT snippet(x2, '[', ']', '...') FROM x2 WHERE x2 MATCH $match
140 SELECT mit(matchinfo(x2, 'x')) FROM x2 WHERE x2 MATCH $match
H A Dwith3.test49 x2 AS (SELECT 11),
51 SELECT * FROM x1 UNION ALL SELECT * FROM x2
56 x2 AS (SELECT 13)
68 SELECT * FROM (WITH x2(y) AS (SELECT * FROM x1) SELECT y+a FROM x1, x2);
206 SELECT x1.x||x2.x||x3.x||x4.x FROM c AS x1, c AS x2, c AS x3, c AS x4
216 |--SCAN x2
223 SELECT x1.x||x2.x||x3.x||x4.x FROM c AS x1, c AS x2, c AS x3, c AS x4
H A Dquota2.test27 foreach dir {quota2a/x1 quota2a/x2 quota2a quota2b quota2c} {
30 foreach dir {quota2a quota2a/x1 quota2a/x2 quota2b quota2c} {
263 set ::h2 [sqlite3_quota_fopen quota2a/x2/b.txt a]
266 } {{*/quota2a/* 4000 300 {PWD/quota2a/x2/b.txt 200 1 0} {PWD/quota2a/x1/a.txt 100 0 0}}}
271 } {{*/quota2a/* 4000 800 {PWD/quota2a/x1/c.txt 500 1 0} {PWD/quota2a/x2/b.txt 200 1 0} {PWD/quota2a…
276 file exists quota2a/x2/b.txt
284 } {{*/quota2a/* 4000 700 {PWD/quota2a/x1/c.txt 500 1 1} {PWD/quota2a/x2/b.txt 200 1 0}}}
289 } {{*/quota2a/* 4000 200 {PWD/quota2a/x2/b.txt 200 0 0}}}
294 file exists quota2a/x2/b.txt
H A Dscanstatus.test144 CREATE TABLE x2(i INTEGER, j, k);
145 INSERT INTO x2 SELECT i, j, i || ' ' || j FROM x1;
146 CREATE INDEX x2j ON x2(j);
147 CREATE INDEX x2ij ON x2(i, j);
148 SELECT * FROM x2 WHERE j BETWEEN 'three' AND 'two'
153 zExplain {SEARCH x2 USING INDEX x2j (j>? AND j<?)}
157 SELECT * FROM x2 WHERE i=1 AND j='two'
161 zExplain {SEARCH x2 USING INDEX x2ij (i=? AND j=?)}
165 SELECT * FROM x2 WHERE i=5 AND j='two'
169 zExplain {SEARCH x2 USING INDEX x2ij (i=? AND j=?)}
[all …]
H A Dwith2.test60 x2 AS (SELECT i FROM t2),
61 x3 AS (SELECT * FROM x1, x2 WHERE x1.a IN x2 AND x2.i IN x1)
70 x2 AS (
74 SELECT * FROM x2;
78 WITH x2 AS (
82 SELECT * FROM x2;
86 WITH x2 AS (
90 SELECT * FROM x2;
438 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 (
[all …]
H A Dmisc3.test225 CREATE TABLE x2 (c, e);
226 INSERT INTO x2 VALUES(1,'one');
227 INSERT INTO x2 VALUES(2,'two');
228 INSERT INTO x2 VALUES(3,'three');
229 INSERT INTO x2 VALUES(4,'four');
230 SELECT x2.c AS c, e, b FROM x2 LEFT JOIN
238 SELECT x2.c AS c, e, b FROM x2 LEFT JOIN
H A Dvacuum5.test35 ATTACH 'test2.db' AS x2;
37 CREATE TABLE x2.t2(c,d);
45 PRAGMA x2.integrity_check;
71 VACUUM x2;
85 PRAGMA x2.integrity_check;
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5fault8.test62 CREATE VIRTUAL TABLE x2 USING fts5(a);
63 INSERT INTO x2(x2, rank) VALUES('crisismerge', 2);
64 INSERT INTO x2(x2, rank) VALUES('pgsz', 32);
65 INSERT INTO x2 VALUES('a b c d');
66 INSERT INTO x2 VALUES('e f g h');
67 INSERT INTO x2 VALUES('i j k l');
68 INSERT INTO x2 VALUES('m n o p');
69 INSERT INTO x2 VALUES('q r s t');
70 INSERT INTO x2 VALUES('u v w x');
71 INSERT INTO x2 VALUES('y z a b');
[all …]
H A Dfts5update.test94 CREATE VIRTUAL TABLE x2 USING fts5(x, detail=%DETAIL%);
95 INSERT INTO x2(x2, rank) VALUES('crisismerge', 2);
96 INSERT INTO x2 VALUES('a b c');
97 INSERT INTO x2 VALUES('a b c');
101 execsql { DELETE FROM x2 WHERE rowid = 2 }
102 execsql { INSERT INTO x2(rowid, x) VALUES(2, 'a b c') }
106 INSERT INTO x2(x2) VALUES('integrity-check');
111 execsql { UPDATE x2 SET x=x WHERE rowid=2 }
115 INSERT INTO x2(x2) VALUES('integrity-check');
H A Dfts5fault4.test102 CREATE VIRTUAL TABLE x2 USING fts5(x);
103 INSERT INTO x2(rowid, x) VALUES(10, 'a b c'); -- 3
104 INSERT INTO x2(rowid, x) VALUES(20, 'a b c'); -- 6
105 INSERT INTO x2(rowid, x) VALUES(30, 'a b c'); -- 2
106 INSERT INTO x2(rowid, x) VALUES(40, 'a b c'); -- 5
107 INSERT INTO x2(rowid, x) VALUES(50, 'a b c'); -- 1
118 SELECT rowid || '-' || rank FROM x2 WHERE x2 MATCH 'b' AND
134 SELECT rank, x FROM x2 WHERE x2 MATCH 'b' AND
/sqlite-3.40.0/ext/rtree/
H A DrtreeA.test28 CREATE VIRTUAL TABLE t1 USING rtree(id, x1, x2, y1, y2);
34 set x2 [expr $i+5]
36 execsql { INSERT INTO t1 VALUES($i, $i, $x2, $i, $y2) }
109 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12"
123 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12"
140 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12"
150 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12"
208 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12"
237 2 "UPDATE t1 SET x1=x1+1, x2=x2+1"
255 SELECT * FROM t1 WHERE x1>0 AND x1<100 AND x2>0 AND x2<100;
H A Drtree_perf.tcl17 set x2 [expr {$x1+rand()*50}]
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
110 if {$x2 > $xmax} {set xmax $x2}
143 foreach {rowid x1 x2 y1 y2} $cell break
146 set x2 [expr {$x2*$xscale + $xoff}]
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 Drtree1.test138 CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2);
161 SELECT "the key", "x dim.", "x2'dim" FROM t1;
211 } {1 {rtree constraint failed: t1.(x1<=x2)}}
297 UPDATE t3 SET x2=5;
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);
[all …]
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);
H A Drtreedoc.test180 foreach {tn x1 x2 y1 y2 ok} {
280 1 t1 "id x1 x2"
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 Drtree8.test36 execsql { CREATE VIRTUAL TABLE t1 USING rtree_i32(id, x1, x2) }
43 lappend res $x1 $x2
54 db eval {SELECT x1, x2 FROM t1}
120 CREATE VIRTUAL TABLE t1 USING rtree_i32(id, x1, x2);
134 CREATE VIRTUAL TABLE t1 USING rtree_i32(id, x1, x2);
162 CREATE VIRTUAL TABLE t2 USING rtree_i32(id, x1, x2)
194 CREATE VIRTUAL TABLE t1 USING rtree(id,x1,x2,y1,y2);

12345