Home
last modified time | relevance | path

Searched refs:a2 (Results 1 – 25 of 44) sorted by relevance

12

/sqlite-3.40.0/test/
H A De_insert.test44 CREATE TABLE a2(a, b, c DEFAULT 'xyz');
150 1a "INSERT INTO a2 VALUES(1, 2, 3)" {}
153 2a "INSERT INTO a2(a, b) VALUES(1, 2)" {}
156 3a "INSERT INTO a2(a) VALUES(3),(4)" {}
171 1 "INSERT INTO a2 VALUES(1)" {a2 3 1}
172 2 "INSERT INTO a2 VALUES(1,2)" {a2 3 2}
173 3 "INSERT INTO a2 VALUES(1,2,3,4)" {a2 3 4}
174 4 "INSERT INTO a2 VALUES(1,2,3,4,5)" {a2 3 5}
190 3a "INSERT INTO a2 VALUES((SELECT count(*) FROM a2), 'x', 'y')" {}
270 5 "INSERT INTO a3(x, y) SELECT a2.a FROM a2,a1" {1 2}
[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);
56 CREATE INDEX t1a2 ON t1(a2);
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.test42 CREATE TABLE a2(x BLOB, y BLOB);
43 INSERT INTO a2(x, y) VALUES(1, 1);
44 INSERT INTO a2(x, y) VALUES(2, '2');
45 INSERT INTO a2(x, y) VALUES('3', 3);
46 INSERT INTO a2(x, y) VALUES('4', '4');
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)
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)
[all …]
H A Danalyze5.test190 set a2 [db eval "SELECT rowid FROM t1 WHERE $where ORDER BY +rowid"]
191 if {$a1==$a2} {
194 set res "a1=\[$a1\] a2=\[$a2\]"
237 set a2 [db eval "SELECT rowid FROM t1 WHERE $where ORDER BY +rowid"]
238 if {$a1==$a2} {
241 set res "a1=\[$a1\] a2=\[$a2\]"
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 Dautoindex5.test220 CREATE TABLE t1(a1, a2, a3);
221 CREATE INDEX t1a2 ON t1(a2, a1);
226 SELECT *, 'x' FROM t1 WHERE (a2=1 OR a3=2) AND a1 = (
H A Daltercol.test280 CREATE TABLE a2(a, b, c);
291 CREATE VIEW v2 AS SELECT x, x+x, a, a+a FROM a1, a2;
298 } {{CREATE VIEW v2 AS SELECT xxx, xxx+xxx, a, a+a FROM a1, a2}}
301 DROP TABLE a2;
303 CREATE TABLE a2(a INTEGER PRIMARY KEY, b, c);
304 CREATE VIEW v2 AS SELECT xxx, xxx+xxx, a, a+a FROM a1, a2;
311 } {{CREATE VIEW v2 AS SELECT x, x+x, a, a+a FROM a1, a2}}
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]}
H A De_select.test933 CREATE TABLE a2(one PRIMARY KEY, three);
934 INSERT INTO a2 VALUES(1, 1);
935 INSERT INTO a2 VALUES(3, 2);
936 INSERT INTO a2 VALUES(6, 3);
937 INSERT INTO a2 VALUES(10, 4);
943 4 "SELECT *, count(*) FROM a1 JOIN a2" {1 1 1 1 16}
944 5 "SELECT *, sum(three) FROM a1 NATURAL JOIN a2" {1 1 1 3}
945 6 "SELECT *, sum(three) FROM a1 NATURAL JOIN a2" {1 1 1 3}
946 7 "SELECT group_concat(three, ''), a1.* FROM a1 NATURAL JOIN a2" {12 1 1}
969 8.4 "SELECT max(a1.one)+min(two), a1.one, two, * FROM a1, a2 WHERE 1"
[all …]
H A Djoin.test887 SELECT a1, a2, a3, a4, a5
890 LEFT JOIN (SELECT a AS a2, b AS b2 FROM t1)
893 ON x2<=CASE WHEN x1 THEN CASE WHEN a2 THEN 1 ELSE -1 END ELSE 0 END
895 ON x2 IS TRUE AND b3=a2
904 ORDER BY a1, a2, a3, a4, a5;
H A Dmalloc3.test194 proc SQL {a1 {a2 ""}} {
199 if {$a2 == ""} {
202 lappend ::run_test_script -sql [list $id false [string trim $a2]]
H A DtriggerB.test111 'a0', 'a1', 'a2', 'a3', 'a4', 'a5', 'a6', 'a7', 'a8', 'a9',
/sqlite-3.40.0/ext/session/
H A Dsqlite3session.c667 a2 += n2; in sessionChangeEqual()
670 if( bRightPkOnly==0 ) a2 += sessionSerialLen(a2); in sessionChangeEqual()
704 if( *a2 ){ in sessionMergeRecord()
712 a2 += n2; in sessionMergeRecord()
742 u8 *a2 = *paTwo; in sessionMergeValue() local
747 if( a2 ){ in sessionMergeValue()
749 if( *a2 ){ in sessionMergeValue()
751 pRet = a2; in sessionMergeValue()
5475 a2 += nn2; in sessionAppendRecordMerge()
5534 a2 += n2; in sessionAppendPartialUpdate()
[all …]
/sqlite-3.40.0/ext/fts3/unicode/
H A Dparseunicode.tcl158 set a2 [list]
160 foreach elem $a { lappend a2 [expr "0x[string trim $elem]"] }
165 if {$b=="C" || $b=="S"} { set tl_lookup_table($a2) $c2 }
/sqlite-3.40.0/ext/misc/
H A Dfossildelta.c773 unsigned int a1, a2; /* Arguments to current operator */ member
876 pCur->a2 = deltaGetInt(&z, &i); in deltaparsevtabNext()
883 pCur->a2 = (unsigned int)(z - pCur->aDelta); in deltaparsevtabNext()
927 sqlite3_result_int(ctx, pCur->a2); in deltaparsevtabColumn()
929 sqlite3_result_blob(ctx, pCur->aDelta+pCur->a2, pCur->a1, in deltaparsevtabColumn()
996 pCur->a1 = pCur->a2 = 0; in deltaparsevtabFilter()
H A Dspellfix.c1001 EditDist3To *a2; in editDist3Core() local
1013 nByte = n*sizeof(m[0]) + sizeof(a2[0])*n2; in editDist3Core()
1021 a2 = (EditDist3To*)&m[n]; in editDist3Core()
1022 memset(a2, 0, sizeof(a2[0])*n2); in editDist3Core()
1033 a2[i2].nIns++; in editDist3Core()
1034 apNew = sqlite3_realloc64(a2[i2].apIns, sizeof(*apNew)*a2[i2].nIns); in editDist3Core()
1039 a2[i2].apIns = apNew; in editDist3Core()
1040 a2[i2].apIns[a2[i2].nIns-1] = p; in editDist3Core()
1063 b2 = a2[i2].nByte; in editDist3Core()
1067 for(k=0; k<a2[i2].nIns; k++){ in editDist3Core()
[all …]
/sqlite-3.40.0/ext/rtree/
H A Drtreefuzz001.test1085 | 4080: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 2c 61 32 29 nodeno,a0,a1,a2)
1091 | 3536: 71 fd c8 43 e4 bd a8 43 64 bb bd 43 f4 3d a2 43 q..C...Cd..C.=.C
1107 | 3792: 36 54 06 00 09 54 1b 17 01 00 00 04 00 00 a2 43 6T...T.........C
1109 | 3824: 00 40 25 44 00 00 a2 43 00 40 25 44 6c 69 6e 65 .@%D...C.@%Dline
1115 | 3920: 01 00 00 05 00 00 a2 43 00 00 5a 43 cd ac b3 43 .......C..ZC...C
1133 | 2928: 35 43 a2 00 00 43 c5 59 9a 43 36 a6 66 43 7d 59 5C...C.Y.C6.fC.Y
1143 | 3088: 00 00 00 00 00 00 00 00 54 43 a2 00 00 43 b6 00 ........TC...C..
1145 | 3120: 54 43 a2 00 00 43 b6 00 00 44 24 00 00 44 25 40 TC...C...D$..D%@
1146 | 3136: 00 00 00 00 00 00 00 00 54 43 a2 00 00 43 b6 00 ........TC...C..
1148 | 3168: 54 43 a2 00 00 43 b6 00 00 44 24 00 00 44 25 40 TC...C...D$..D%@
[all …]
/sqlite-3.40.0/ext/rbu/
H A Drbutemplimit.test91 foreach {a0 a1 a2} [lsort -integer [array names ::A]] {}
94 [expr $a2>1500000] [expr $a2<1700000]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5simple2.test64 INSERT INTO t1 VALUES('a2 b2 c2');
80 INSERT INTO t1 VALUES('a2 b2 c2');
121 INSERT INTO t1 VALUES('a2 b2 c2');
148 INSERT INTO t1 VALUES('a2 b2 c2');
159 INSERT INTO t1 VALUES('a2 b2 c2', '1 2 3');
H A Dfts5tokenizer.test129 CREATE VIRTUAL TABLE a2 USING fts5(
131 INSERT INTO a2 VALUES('abc\u1234def');
133 execsql { SELECT rowid FROM a2 WHERE a2 MATCH 'def' }
H A Dfts5_common.tcl458 foreach {a1 a2} [split $a .] {}
461 if {$a1==$b1} { return [expr $a2 - $b2] }
632 {a1 a2 a3 a4 a5 a6 a7 a8 a9}
H A Dfts5corrupt3.test2449 | 64: 43 27 a2 04 f4 e2 07 43 22 87 a2 95 30 30 71 71 C'.....C....00qq
3278 | 32: 0e a2 0e 89 0e 70 e5 50 e3 90 e1 d0 e0 40 de a0 .....p.P.....@..
3830 | 32: 0e a2 0e 89 0e 70 0e 55 0e 39 0e 1d 0e 04 0d ea .....p.U.9......
6252 | 4048: 06 a2 03 00 12 01 01 01 06 05 03 00 12 01 01 01 ................
11117 | 1968: 43 e7 6f e2 a9 87 21 a2 96 82 d7 17 55 4d 33 ff C.o...!.....UM3.
11151 | 2512: 1c 08 d0 2f 1e df 36 b0 b5 95 e2 4c 55 cd a2 e4 .../..6....LU...
11167 | 2768: de 19 71 96 7a 1b 93 a2 20 18 d6 a6 f2 8d 28 1d ..q.z... .....(.
11168 | 2784: c0 f3 a9 20 87 f7 dc 10 eb bf bc 1e cf 7a 54 a2 ... .........zT.
11170 | 2816: 7a 9e db 78 60 bd b6 87 a2 1b 57 7c 2c f2 8e fa z..x`.....W|,...
11186 | 3072: cd a2 d4 57 bc 27 ff 1d 16 7a 11 d6 3d df 04 89 ...W.'...z..=...
[all …]
H A Dfts5fault9.test94 INSERT INTO t4 VALUES('a1 a2 a3', 'a4 a5 a6', 'a7 a8 a9');
/sqlite-3.40.0/ext/recover/
H A Drecovercorrupt2.test210 | 3552: e9 a2 bd 05 04 ea 61 62 63 30 31 34 78 79 7a 00 ......abc014xyz.
218 | 3680: 05 06 1f 22 07 6e a2 a3 64 68 d4 a6 bd 61 62 63 .....n..dh...abc
249 | 3840: 01 7f 46 91 03 3f 97 fb f7 11 0c 03 06 01 6e a2 ..F..?........n.
254 | 3920: ab e0 8c 7c ff 0c 0d 0c 03 06 01 36 75 e9 a2 bd ...|.......6u...
/sqlite-3.40.0/ext/lsm1/
H A Dlsm_sorted.c3411 u8 *a2; int n2; in mergeWorkerMoveHierarchy() local
3414 a2 = fsPageData(apHier[i], &n2); in mergeWorkerMoveHierarchy()
3419 memcpy(a1, a2, n2); in mergeWorkerMoveHierarchy()
3421 int nEntry = pageGetNRec(a2, n2); in mergeWorkerMoveHierarchy()
3425 memcpy(a1, a2, iEof2 - 4); in mergeWorkerMoveHierarchy()
3426 memcpy(&a1[iEof1], &a2[iEof2], n2 - iEof2); in mergeWorkerMoveHierarchy()
3440 int nEntry = pageGetNRec(a2, n2); in mergeWorkerMoveHierarchy()
3443 memcpy(a1, a2, iEof2); in mergeWorkerMoveHierarchy()
3444 memcpy(&a1[iEof1], &a2[iEof2], n2 - iEof2); in mergeWorkerMoveHierarchy()

12