Home
last modified time | relevance | path

Searched refs:a1 (Results 1 – 25 of 51) sorted by relevance

123

/sqlite-3.40.0/test/
H A De_insert.test43 CREATE TABLE a1(a, b);
242 2b "INSERT INTO a1 SELECT b, a FROM a1" {}
246 3b "INSERT INTO a1 SELECT b, a FROM a1" {}
250 4b "INSERT INTO a1 SELECT b, a FROM a1" {}
254 4b "INSERT INTO a1 SELECT min(b), min(a) FROM a1" {}
286 1 "INSERT INTO a1 SELECT a, b, c FROM a2" {a1 2 3}
287 2 "INSERT INTO a1 SELECT * FROM a2" {a1 2 3}
288 3 "INSERT INTO a1 SELECT * FROM a2 CROSS JOIN a1" {a1 2 5}
289 4 "INSERT INTO a1 SELECT * FROM a2 NATURAL JOIN a1" {a1 2 3}
290 5 "INSERT INTO a1 SELECT a2.a FROM a2,a1" {a1 2 1}
[all …]
H A Dtkt1537.test22 CREATE TABLE t1(id, a1, a2);
28 SELECT * FROM t1 LEFT JOIN t2 ON a1=b OR a2=+b;
33 SELECT * FROM t1 LEFT JOIN t2 ON a1=b OR a2=b;
38 SELECT * FROM t2 LEFT JOIN t1 ON a1=b OR a2=b;
44 SELECT * FROM t1 LEFT JOIN t2 ON b IN (a1,a2);
49 SELECT * FROM t2 LEFT JOIN t1 ON b IN (a2,a1);
55 CREATE INDEX t1a1 ON t1(a1);
58 SELECT * FROM t1 LEFT JOIN t2 ON a1=b OR a2=b;
63 SELECT * FROM t2 LEFT JOIN t1 ON a1=b OR a2=b;
70 SELECT * FROM t1 LEFT JOIN t2 ON b IN (a1,a2);
[all …]
H A Drowvalue9.test35 CREATE TABLE a1(c, b INTEGER, a TEXT, PRIMARY KEY(a, b));
59 SELECT (SELECT rowid FROM a1 WHERE a=x AND b=y) FROM a2
66 SELECT a1.rowid FROM a1, a2 WHERE a=x AND b=y;
69 SELECT a1.rowid FROM a1, a2 WHERE (a, b) = (x, y)
74 SELECT a1.rowid FROM a1, a2 WHERE coalesce(NULL,x)=a AND coalesce(NULL,y)=b
77 SELECT a1.rowid FROM a1, a2
82 SELECT a1.rowid FROM a1, a2 WHERE +x=a AND +y=b
85 SELECT a1.rowid FROM a1, a2 WHERE (+x, +y) = (a, b)
99 SELECT a1.rowid FROM a1 WHERE (a, b) IN (SELECT x, y FROM a2)
102 SELECT a1.rowid FROM a1, a2 WHERE EXISTS (
[all …]
H A Dscanstatus.test184 CREATE TABLE a1(a, b, c, d);
185 CREATE INDEX a1a ON a1(a);
186 CREATE INDEX a1bc ON a1(b, c);
189 INSERT INTO a1 SELECT x, x, x, x FROM d;
193 SELECT d FROM a1 WHERE (a=4 OR b=13)
197 zExplain {SEARCH a1 USING INDEX a1a (a=?)}
199 zExplain {SEARCH a1 USING INDEX a1bc (b=?)}
207 zExplain {SEARCH a1 USING INDEX a1a (a>? AND a<?)}
213 SELECT count(*) FROM a1 AS x, a1 AS y
224 SELECT count(*) FROM a1 WHERE a IN (1, 5, 10, 15);
[all …]
H A Danalyze5.test188 set a1 [db eval "SELECT rowid FROM t1 NOT INDEXED WHERE $w2\
191 if {$a1==$a2} {
194 set res "a1=\[$a1\] a2=\[$a2\]"
235 set a1 [db eval "SELECT rowid FROM t1 NOT INDEXED WHERE $w2\
238 if {$a1==$a2} {
241 set res "a1=\[$a1\] a2=\[$a2\]"
H A Daggnested.test24 CREATE TABLE t1(a1 INTEGER);
28 SELECT (SELECT group_concat(a1,'x') FROM t2) FROM t1;
34 (SELECT group_concat(a1,'x') || '-' || group_concat(b1,'y') FROM t2)
40 SELECT (SELECT group_concat(b1,a1) FROM t2) FROM t1;
45 SELECT (SELECT group_concat(a1,b1) FROM t2) FROM t1;
65 SELECT (SELECT GROUP_CONCAT(CASE WHEN a1=1 THEN'A' ELSE 'B' END) FROM t2),
H A Daltercol.test233 ALTER TABLE "blob" RENAME COLUMN "rid" TO "a1";
237 ALTER TABLE "blob" RENAME COLUMN "a1" TO [where];
279 CREATE TABLE a1(x INTEGER, y TEXT, z BLOB, PRIMARY KEY(x));
281 CREATE VIEW v1 AS SELECT x, y, z FROM a1;
285 ALTER TABLE a1 RENAME y TO yyy;
287 } {{CREATE VIEW v1 AS SELECT x, yyy, z FROM a1}}
291 CREATE VIEW v2 AS SELECT x, x+x, a, a+a FROM a1, a2;
294 ALTER TABLE a1 RENAME x TO xxx;
304 CREATE VIEW v2 AS SELECT xxx, xxx+xxx, a, a+a FROM a1, a2;
307 ALTER TABLE a1 RENAME xxx TO x;
[all …]
H A Dautoindex5.test220 CREATE TABLE t1(a1, a2, a3);
221 CREATE INDEX t1a2 ON t1(a2, a1);
222 CREATE INDEX t1a3 ON t1(a3, a1);
226 SELECT *, 'x' FROM t1 WHERE (a2=1 OR a3=2) AND a1 = (
H A DwhereG.test154 CREATE TABLE a(a1 PRIMARY KEY, a2);
158 SELECT * FROM a, b WHERE b1=a1 AND a2=5;
161 SELECT * FROM a, b WHERE a1=b1 AND a2=5;
164 SELECT * FROM a, b WHERE a2=5 AND b1=a1;
167 SELECT * FROM a, b WHERE a2=5 AND a1=b1;
H A Dpushdown.test65 INSERT INTO u1 VALUES('a1', 'b1', 'c1');
66 INSERT INTO u2 VALUES('a1', 'b1', 'c1');
H A DwhereJ.test39 a1,
49 CREATE INDEX ix0 on tx1(a1,curx,aid,cid,sid,ftype,fp,fyear DESC,edate DESC,fid);
50 CREATE INDEX ix1 on tx1(a1,curx,aid,ftype,fp,fyear DESC,fid,edate DESC,cid,sid);
51 CREATE INDEX ix2 on tx1(a1,curx,cid,sid,ftype,fp,fyear DESC,edate DESC,aid,fid);
52 CREATE INDEX ix3 on tx1(a1,curx,fid,ftype,fp,fyear DESC,cid,sid,aid,edate DESC);
53 CREATE INDEX ix4 on tx1(a1,curx,ftype,cid,sid,aid,edate DESC,fid,fp,fyear DESC);
54 CREATE INDEX ix5 on tx1(a1,curx,ftype,aid,fid,cid,sid,edate DESC,fp,fyear DESC);
55 …CREATE INDEX ix6 on tx1(ftype,fp,fyear DESC,cid,sid,edate DESC,a1,fid,aid,curx,est,rstat,cx,acode,…
56 …CREATE INDEX ix7 on tx1(cid,a1,curx,sid,ftype,est,fid,aid,edate,rstat,cx,fyear,fp,acode,tdate,gsta…
58 CREATE INDEX ix9 on tx1(aid,edate DESC,a1,curx);
H A De_select.test927 CREATE TABLE a1(one PRIMARY KEY, two);
928 INSERT INTO a1 VALUES(1, 1);
929 INSERT INTO a1 VALUES(2, 3);
930 INSERT INTO a1 VALUES(3, 6);
931 INSERT INTO a1 VALUES(4, 10);
946 7 "SELECT group_concat(three, ''), a1.* FROM a1 NATURAL JOIN a2" {12 1 1}
966 8.1 "SELECT count(*) FROM a1"
967 8.2 "SELECT count(*) FROM a1 WHERE 0"
968 8.3 "SELECT count(*) FROM a1 WHERE 1"
969 8.4 "SELECT max(a1.one)+min(two), a1.one, two, * FROM a1, a2 WHERE 1"
[all …]
H A Dunionvtab.test191 set sql "CREATE VIRTUAL TABLE temp.a1 USING unionvtab(\"VALUES [join $L ,]\")"
193 DROP TABLE IF EXISTS temp.a1;
194 CREATE VIRTUAL TABLE temp.a1 USING unionvtab(\"VALUES [join $L ,]\");
209 CREATE VIRTUAL TABLE temp.a1 USING unionvtab(`$sql`)
H A Ddbfuzz001.test94 | 48: 00 a1 00 92 00 83 00 74 00 65 00 56 00 47 00 00 .......t.e.V.G..
241 | 16: 01 a1 01 96 01 6f 01 54 00 00 00 00 00 00 00 00 .....o.T........
322 | 16: 01 a1 01 96 01 6f 01 54 00 00 00 00 00 00 00 00 .....o.T........
H A Dwidetab1.test34 CREATE INDEX a1 on a(pd, bn, vb, bc, cn); -- preferred index
49 |--SEARCH a USING COVERING INDEX a1 (pd>? AND pd<?)
H A Dfts3snippet.test570 INSERT INTO t5 VALUES('a1 a2 a3');
577 'a1 OR a2 OR a3 OR a4 OR a5 OR a6 OR a7 OR a8 OR a9 OR a10 OR ' ||
586 {[a1] [a2] [a3]}
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5simple2.test63 INSERT INTO t1 VALUES('a1 b1 c1');
79 INSERT INTO t1 VALUES('a1 b1 c1');
81 INSERT INTO t1 VALUES('a1 b1 c1');
92 INSERT INTO t1 VALUES('a1 b1 c1');
93 INSERT INTO t1 VALUES('a1 b1 c1');
94 INSERT INTO t1 VALUES('a1 b1 c1');
108 INSERT INTO t1 VALUES('a1 b1');
109 INSERT INTO t1 VALUES('a1 b2');
120 INSERT INTO t1 VALUES('a1 b1 c1');
122 INSERT INTO t1 VALUES('a1 b1 c1');
[all …]
H A Dfts5tokenizer.test121 CREATE VIRTUAL TABLE a1 USING fts5(x, tokenize=`ascii separators '\u1234'`);
122 INSERT INTO a1 VALUES('abc\u1234def');
124 execsql { SELECT rowid FROM a1 WHERE a1 MATCH 'def' }
H A Dfts5corrupt3.test2353 | 3424: 24 54 55 85 25 45 24 94 d1 a1 80 50 02 90 f1 94 $TU.%E$....P....
2355 | 3456: 94 e4 15 25 91 a1 70 50 02 90 f1 94 54 e4 14 24 ...%..pP....T..$
2363 | 3584: f4 e3 15 85 25 45 24 94 d1 a1 20 50 02 90 f1 94 ....%E$... P....
2365 | 3616: 94 e4 15 25 91 a1 10 50 02 90 f1 94 54 e4 14 24 ...%...P....T..$
2952 | 3328: 94 d1 a1 20 50 02 90 f1 94 54 e4 14 24 c4 52 04 ... P....T..$.R.
2953 | 3344: 74 54 f5 04 f4 c5 95 84 24 94 e4 15 25 91 a1 10 tT......$...%...
3833 | 80: 15 25 91 a1 70 50 02 90 f1 94 54 e4 14 24 c4 52 .%..pP....T..$.R
3841 | 208: 55 85 25 45 24 94 d1 a1 20 50 02 90 f1 94 54 e4 U.%E$... P....T.
3843 | 240: 15 25 91 a1 10 50 02 90 f1 94 54 e4 14 24 c4 52 .%...P....T..$.R
11377 | 3072: 09 74 b9 8e 59 a1 50 10 e0 f0 48 a9 f1 dd a1 ab .t..Y.P...H.....
[all …]
H A Dfts5_common.tcl458 foreach {a1 a2} [split $a .] {}
462 return [expr $a1 - $b1]
632 {a1 a2 a3 a4 a5 a6 a7 a8 a9}
/sqlite-3.40.0/ext/session/
H A Dsqlite3session.c666 a1 += n1; in sessionChangeEqual()
669 if( bLeftPkOnly==0 ) a1 += sessionSerialLen(a1); in sessionChangeEqual()
711 a1 += n1; in sessionMergeRecord()
741 u8 *a1 = *paOne; in sessionMergeValue() local
746 assert( a1 ); in sessionMergeValue()
759 pRet = a1; in sessionMergeValue()
761 *paOne = &a1[n1]; in sessionMergeValue()
5467 if( *a1==0 || *a1==0xFF ){ in sessionAppendRecordMerge()
5474 a1 += nn1; in sessionAppendRecordMerge()
5533 a1 += n1; in sessionAppendPartialUpdate()
[all …]
/sqlite-3.40.0/ext/misc/
H A Dfossildelta.c773 unsigned int a1, a2; /* Arguments to current operator */ member
872 pCur->a1 = deltaGetInt(&z, &i); in deltaparsevtabNext()
885 pCur->iNext = (int)(&z[pCur->a1] - pCur->aDelta); in deltaparsevtabNext()
922 sqlite3_result_int(ctx, pCur->a1); in deltaparsevtabColumn()
929 sqlite3_result_blob(ctx, pCur->aDelta+pCur->a2, pCur->a1, in deltaparsevtabColumn()
993 pCur->a1 = deltaGetInt(&a, &i); in deltaparsevtabFilter()
996 pCur->a1 = pCur->a2 = 0; in deltaparsevtabFilter()
/sqlite-3.40.0/ext/rbu/
H A Drbutemplimit.test91 foreach {a0 a1 a2} [lsort -integer [array names ::A]] {}
93 [expr $a1>1048576] [expr $a1<1200000] \
/sqlite-3.40.0/ext/recover/
H A Drecovercorrupt2.test206 | 3488: 43 a1 eb 44 14 dc 03 7b 2d 0f 05 06 1f 2a 07 d9 C..D....-....*..
217 | 3664: 00 00 00 00 00 00 43 b5 a1 a4 af 7b c6 60 29 0b ......C......`).
266 | 0: 0a 00 00 00 14 0f 62 00 0f 7a 0f a1 0f c9 0f d9 ......b..z......
275 | 4032: dd 07 04 01 01 01 0c 2e a1 07 04 01 01 01 03 df ................
/sqlite-3.40.0/ext/rtree/
H A Drtreefuzz001.test54 | 4000: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 29 51 01 07 nodeno,a0,a1)Q..
501 | 4000: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 29 51 01 07 nodeno,a0,a1)Q..
598 | 4000: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 29 51 01 07 nodeno,a0,a1)Q..
703 | 4000: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 29 51 01 07 nodeno,a0,a1)Q..
829 | 2976: 30 78 35 09 ce 14 04 00 01 15 0d a1 30 78 34 09 0x5.........0x4.
1034 | 2672: 00 00 00 0f a1 ff ff ff 04 00 00 00 06 00 00 00 ................
1085 | 4080: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 2c 61 32 29 nodeno,a0,a1,a2)

123