Home
last modified time | relevance | path

Searched refs:c3 (Results 1 – 25 of 52) sorted by relevance

123

/sqlite-3.40.0/test/
H A Dwith6.test26 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
30 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
37 `--SCAN c3
42 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
46 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
53 `--SCAN c3
61 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
65 SELECT c1.x||c2.x||c3.x FROM c c1, c c2, c c3;
72 `--SCAN c3
104 `--SCAN c3
[all …]
H A Djoin2.test161 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
164 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
168 SELECT DISTINCT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
172 SELECT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
176 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
184 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
194 DROP TABLE c3;
208 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
215 SELECT DISTINCT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
219 SELECT v1, v3 FROM c1 LEFT JOIN c2 LEFT JOIN c3 ON (c3.k=v1+1);
[all …]
H A Dshell8.test91 set c3 ".ar cCf ar1 test_xyz.db ."
102 set c3 ".ar -cCar1 -ftest_xyz.db ."
113 set c3 ".ar --creat --dir ar1 --file test_xyz.db ."
124 set c3 ".ar -c --directory ar1 --file test_xyz.db ."
156 catchcmd ":memory:" $c3
H A Dfkey5.test48 CREATE TABLE c3(x INTEGER PRIMARY KEY references p3);
209 INSERT INTO c3 VALUES(68),(67),(65);
212 } {c3 65 p3 0 c3 68 p3 0}
215 PRAGMA foreign_key_check(c3);
217 } {c3 65 p3 0 c3 68 p3 0}
220 INSERT INTO c7 SELECT x FROM c3;
222 DELETE FROM c3;
H A DwhereL.test56 CREATE TABLE c3(x COLLATE binary, y COLLATE nocase, z COLLATE binary);
57 CREATE INDEX c3x ON c3(x);
58 INSERT INTO c3 VALUES('ABC', 'ABC', 'abc');
59 SELECT * FROM c3 WHERE x=y AND y=z AND z='abc';
66 SELECT * FROM c3 WHERE x='abc' AND y='abc' AND z='abc';
H A Dgencol1.test153 CREATE TABLE t0(c0 PRIMARY KEY, c1, c2 AS (c0+c1-c3) REFERENCES t0, c3);
155 UPDATE t0 SET c1 = c0, c3 = c0;
159 UPDATE t0 SET c1 = c0, c3 = c0+1;
170 c3 REFERENCES t0(c1)
173 INSERT INTO t0(c0,c2,c3) VALUES(0,0,1);
176 REPLACE INTO t0(c0,c2,c3) VALUES(0,0,0),(0,0,0);
349 c3 BLOB GENERATED ALWAYS AS (1),
361 c3 BLOB GENERATED ALWAYS AS (1),
373 c3 BLOB GENERATED ALWAYS AS (1),
385 c3 BLOB GENERATED ALWAYS AS (1),
H A Dbestindex9.test83 CREATE TABLE x(c1, c2, c3);
91 CREATE TABLE x(c1, c2, c3);
97 CREATE TABLE x(c1, c2, c3);
H A De_totalchanges.test132 CREATE TABLE c3(a, b, FOREIGN KEY(a) REFERENCES p1 ON DELETE SET DEFAULT);
141 INSERT INTO c3 VALUES(3, 'iii');
154 DROP TABLE c3;
157 CREATE TABLE c3(a, b, FOREIGN KEY(a) REFERENCES p1 ON UPDATE SET DEFAULT);
166 INSERT INTO c3 VALUES(3, 'iii');
H A Dnulls1.test261 CREATE TABLE v0 (c1, c2, c3);
262 CREATE INDEX v3 ON v0 (c1, c2, c3);
287 SELECT c1, c2, ifnull(c3, 'NULL') FROM v0
288 WHERE c2=10 ORDER BY c1, c3 NULLS LAST
295 SELECT c1, c2, ifnull(c3, 'NULL') FROM v0
296 WHERE c2=10 ORDER BY c1, c3 NULLS LAST
H A Dfkey7.test33 CREATE TABLE c3(a, b REFERENCES par(c));
50 do_tblsread_test 1.4 { UPDATE par SET c=? WHERE b=? } {c3 par}
51 do_tblsread_test 1.5 { UPDATE par SET a=?,b=?,c=? WHERE b=? } {c1 c2 c3 par s1}
H A Dskipscan1.test381 CREATE TABLE t1 (c1, c2, c3, c4, PRIMARY KEY(c4, c3));
389 SELECT DISTINCT quote(c1), quote(c2), quote(c3), quote(c4), '|'
390 FROM t1 WHERE t1.c3 = 1;
393 SELECT DISTINCT quote(c1), quote(c2), quote(c3), quote(c4), '|'
394 FROM t1 WHERE t1.c3 = 1;
397 |--SEARCH t1 USING INDEX sqlite_autoindex_t1_1 (ANY(c4) AND c3=?)
H A Dindex2.test68 execsql {EXPLAIN SELECT c9 FROM t1 ORDER BY c1, c2, c3, c4, c5}
70 execsql {SELECT c9 FROM t1 ORDER BY c1, c2, c3, c4, c5, c6 LIMIT 5}
H A Dpushdown.test20 INSERT INTO t1 VALUES(3, 'b3', 'c3');
41 } {c3}
H A Dfuzzer2.test47 foreach c3 $LETTERS {
49 db eval {INSERT INTO x1_rules VALUES(0, $c1||$c2, $c3||$c4, $cost)}
H A Dfts4merge4.test64 foreach c3 "a b c d e f g h i j" {
65 lappend doc "$c1$c2$c3"
H A Dfkey8.test151 CREATE TABLE c3(x REFERENCES p3);
155 INSERT INTO c3 VALUES(1);
156 INSERT INTO c3 VALUES(2);
H A Drowvalue4.test297 CREATE TABLE c3(d);
300 SELECT * FROM c2 CROSS JOIN c3 WHERE
301 ( (a, b) == (SELECT x, y FROM c1) AND c3.d = c ) OR
302 ( c == (SELECT x, y FROM c1) AND c3.d = c )
H A Daltertab2.test55 CREATE TABLE c3(x, FOREIGN KEY (x) REFERENCES p1(a));
64 {CREATE TABLE c3(x, FOREIGN KEY (x) REFERENCES "p2"(a))}
74 {CREATE TABLE c3(x, FOREIGN KEY (x) REFERENCES "p2"(a))}
85 {CREATE TABLE c3(x, FOREIGN KEY (x) REFERENCES "p3"(a))}
H A DwhereD.test224 CREATE TABLE t(c0,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17);
228 CREATE INDEX tc3 ON t(c3);
247 c0=1 or c1=1 or c2=1 or c3=1 or
257 c0=1 or c1=1 or c2=1 or c3=1 or
267 c0=1 or c1=1 or c2=1 or c3=1 or
/sqlite-3.40.0/ext/recover/
H A Drecovercorrupt2.test195 | 3280: 00 00 00 00 00 00 00 00 00 00 c3 b0 96 7e fb 4e .............~.N
198 | 3328: 00 00 00 00 00 00 00 00 00 00 00 00 00 c3 a3 d6 ................
204 | 3440: c3 bb d8 96 86 c2 e8 2b 2e 10 05 06 1f 2c 07 6d .......+.....,.m
208 | 3520: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 c3 ................
211 | 3568: 00 00 00 00 00 00 00 00 00 00 00 00 00 c3 ab 23 ...............#
220 | 3712: 00 c3 c4 1e ff 0f fc e6 ff 28 0a 05 06 1f 20 07 .........(.... .
222 | 3744: 7a 00 00 00 00 00 00 00 00 00 00 c3 a7 90 ed d9 z...............
227 | 3824: 38 78 79 7a 00 00 00 00 00 00 00 00 c3 b0 e3 4c 8xyz...........L
230 | 3872: 00 00 00 c3 b6 a3 74 f1 9c 33 f8 24 06 05 06 1f ......t..3.$....
232 | 3904: 78 79 7a 00 00 00 00 00 00 c3 88 00 c2 ca 4c 4d xyz...........LM
[all …]
/sqlite-3.40.0/ext/misc/
H A Dshathree.c85 u64 c0, c1, c2, c3, c4; in KeccakF1600Step() local
132 c3 = a03^a13^a23^a33^a43; in KeccakF1600Step()
136 d2 = c1^ROL64(c3, 1); in KeccakF1600Step()
138 d4 = c3^ROL64(c0, 1); in KeccakF1600Step()
203 d2 = c1^ROL64(c3, 1); in KeccakF1600Step()
205 d4 = c3^ROL64(c0, 1); in KeccakF1600Step()
270 d2 = c1^ROL64(c3, 1); in KeccakF1600Step()
272 d4 = c3^ROL64(c0, 1); in KeccakF1600Step()
337 d2 = c1^ROL64(c3, 1); in KeccakF1600Step()
339 d4 = c3^ROL64(c0, 1); in KeccakF1600Step()
[all …]
/sqlite-3.40.0/ext/rbu/
H A Drbuexpr.test62 CREATE TABLE t1(c1, c2, c3, i INTEGER PRIMARY KEY);
69 CREATE INDEX i2 ON t1( c1 || c2 || c3 );
70 CREATE INDEX i3 ON t1( length(c1) + length(c2) - 1, c3||i );
76 CREATE TABLE data_t1(c1, c2, c3, i, rbu_control);
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5determin.test45 INSERT INTO TBL VALUES('c1 c2 c3', 'c1 c2 c3');
H A Dfts5corrupt3.test1366 | 3248: 34 33 31 35 66 36 39 c3 bf c3 bf 7e c3 bf c3 89 4315f69....~....
1394 | 3696: 33 31 c3 94 30 35 35 35 33 34 39 34 65 34 37 32 31..05553494e472
1875 | 2960: 05 02 20 16 37 c3 b0 35 32 30 32 37 37 34 33 31 .. .7..520277431
1986 | 2544: 30 35 34 34 31 34 32 34 63 34 c3 b0 35 32 30 32 05441424c4..5202
3281 | 80: c3 90 c1 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
4440 | 80: 0e c3 0e ba 0e b0 0e a8 0e 9f 0e 96 0e 8e 0e 85 ................
5068 | 80: 0e c3 0e ba 0e b0 0e a8 0e 9f 0e 96 0e 8e 0e 85 ................
5285 | 80: 0e c3 0e ba 0e b0 0e a8 0e 9f 0e 96 0e 8e 0e 85 ................
5746 | 80: 0e c3 0e ba 0e b0 0e a8 0e 9f 0e 96 0e 8e 0e 85 ................
5990 | 80: 0e c3 0e ba 0e b0 0e a8 0e 9f 0e 96 0e 8e 0e 85 ................
[all …]
H A Dfts5auto.test324 CREATE VIRTUAL TABLE yy USING fts5(c1, c2, c3);
325 INSERT INTO yy(rowid, c1, c2, c3) VALUES(-56789, $a, $b, $c);
326 INSERT INTO yy(rowid, c1, c2, c3) VALUES(250, $a, $b, $c);
335 4 {c1 : x} 5 {c2 : x} 6 {c3 : x}
336 7 {c1 : y} 8 {c2 : y} 9 {c3 : y}
337 10 {c1 : z} 11 {c2 : z} 12 {c3 : z}

123