Home
last modified time | relevance | path

Searched refs:c2 (Results 1 – 25 of 108) sorted by relevance

12345

/sqlite-3.40.0/test/
H A Dtkt-f973c7ac31.test27 2 "CREATE INDEX i1 ON t(c1, c2)"
34 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='2' ORDER BY c2 DESC
39 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<=5 ORDER BY c2 DESC
44 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='5' ORDER BY c2 DESC
49 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<=5 ORDER BY c2 DESC
54 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<='5' ORDER BY c2 DESC
60 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='2' ORDER BY c2 ASC
65 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<=5 ORDER BY c2 ASC
70 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='5' ORDER BY c2 ASC
75 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<=5 ORDER BY c2 ASC
[all …]
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;
36 |--SCAN c2
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;
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;
170 FROM c AS c2 WHERE c2.x<10;
175 FROM c AS c2 WHERE c2.x<10;
188 FROM c AS c2 WHERE c2.x<10;
[all …]
H A Dwal_common.tcl29 upvar $ckv2 c2
31 set c1 [expr {($c1 + $v1 + $c2)&0xFFFFFFFF}]
32 set c2 [expr {($c2 + $v2 + $c1)&0xFFFFFFFF}]
44 upvar $ckv2 c2
53 wal_cksum_intlist c1 c2 $values
62 set c2 0
63 wal_cksum $endian c1 c2 $blob
64 append blob [binary format II $c1 $c2]
87 set c2 0
88 wal_cksum_intlist c1 c2 [lrange $hdr 0 9]
[all …]
H A Djoin2.test153 INSERT INTO c2 VALUES(2, 3);
161 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);
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);
193 DROP TABLE c2;
200 INSERT INTO c2 VALUES(2, 3);
208 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
211 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v1+1);
223 SELECT v1, v3 FROM c1 LEFT JOIN c2 ON (c2.k=v1) LEFT JOIN c3 ON (c3.k=v2);
[all …]
H A Dcollate1.test66 CREATE TABLE collate1t1(c1, c2);
74 SELECT c2 FROM collate1t1 ORDER BY 1;
115 CREATE TABLE collate1t1(c1, c2);
141 SELECT c1, c2 FROM collate1t1
147 SELECT c1, c2 FROM collate1t1
178 SELECT c1 COLLATE binary, c2 COLLATE hex
185 SELECT c1, c2
191 SELECT c1 COLLATE binary, c2 COLLATE hex
252 SELECT a COLLATE binary as c1, b as c2
283 SELECT c2 FROM collate1t1 ORDER BY 1;
[all …]
H A Dgencol1.test169 c2,
225 SELECT quote(0 = t0.c2 OR t0.c1 BETWEEN t0.c2 AND 1) FROM t0;
296 c2 CHECK (1 = c1)
305 c1 AS(c0 + c2),
306 c2 AS(c1) CHECK(c2)
309 } {1 {generated column loop on "c2"}}
348 c2 BLOB UNIQUE DEFAULT x'00',
362 c2 BLOB UNIQUE DEFAULT x'00',
375 c2 BLOB UNIQUE DEFAULT x'00',
388 c2 BLOB UNIQUE DEFAULT x'00',
[all …]
H A Dovfl.test21 # CREATE TABLE t1(c1 TEXT, c2 TEXT);
23 # with 2000 rows. In each row, c2 spans multiple overflow pages. The text
25 # at least one row where the first byte of c2 is also the first byte of
30 set c2 [string repeat abcdefghij 200]
33 CREATE TABLE t1(c1 TEXT, c2 TEXT);
38 execsql { INSERT INTO t1 VALUES($c1, $c2) }
44 SELECT sum(length(c2)) FROM t1;
H A Dpragma4.test215 CREATE TABLE aux.c2 (d, e, r REFERENCES t2(d));
221 do_execsql_test 4.5.2 { SELECT * FROM pragma_foreign_key_list('c2') } {
227 execsql { DROP TABLE c2 } db2
234 do_execsql_test 4.5.5 { SELECT * FROM pragma_foreign_key_list('c2') }
240 CREATE TABLE aux.c2 (d, e, r REFERENCES t2(d));
242 INSERT INTO aux.c2 VALUES(4, 5, 6);
247 do_execsql_test 4.6.2 { pragma foreign_key_check('c2') } {
248 c2 1 t2 0
251 execsql { DROP TABLE c2 } db2
255 pragma foreign_key_check('c2')
[all …]
H A Dwalcksum.test41 foreach {offset c1 c2} [log_checksum_calc $data $iFrame $endian] {}
47 expr {$c1==$expect1 && $c2==$expect2}
58 foreach {offset c1 c2} [log_checksum_calc $data $iFrame $endian] {}
60 set bin [binary format II $c1 $c2]
94 set c2 0
95 wal_cksum $endian c1 c2 [string range $data 0 23]
99 wal_cksum $endian c1 c2 [string range $data $n [expr $n+7]]
102 list [expr $n+16] $c1 $c2
124 set c2 0
125 wal_cksum $endian c1 c2 $blob
[all …]
H A Dclosure01.test165 CREATE VIRTUAL TABLE c2
171 SELECT count(*), min(id), max(id) FROM c2 WHERE root=1;
175 SELECT id FROM c2 WHERE root=10;
179 SELECT id FROM c2 WHERE root=12;
183 SELECT id FROM c2 WHERE root IN (10,12) ORDER BY id;
187 SELECT id FROM c2 WHERE root IN (10,12) ORDER BY +id;
211 SELECT DISTINCT id FROM c2
219 SELECT id FROM c2
224 SELECT id FROM c2
H A Dupfrom4.test62 CREATE TABLE c2(x INT,c INT);
63 INSERT INTO c2(x,c) VALUES(2,2),(8,8),(NULL,NULL);
70 UPDATE t1 SET b=c1.b, c=c2.c
71 FROM dual, c1 NATURAL RIGHT JOIN c2
88 UPDATE t1 SET b=c1.b, c=c2.c
89 FROM dual, c1 NATURAL RIGHT JOIN c2
H A Dfkey5.test47 CREATE TABLE c2(x INTEGER PRIMARY KEY references p2);
99 PRAGMA foreign_key_check(c2);
104 PRAGMA main.foreign_key_check(c2);
109 PRAGMA temp.foreign_key_check(c2);
111 } {1 {no such table: temp.c2}}
172 INSERT INTO c2 VALUES(79),(77),(76);
175 } {c2 76 p2 0 c2 79 p2 0}
178 PRAGMA foreign_key_check(c2);
180 } {c2 76 p2 0 c2 79 p2 0}
183 INSERT INTO c6 SELECT x FROM c2;
[all …]
H A Dreindex.test74 proc c2 {a b} {
78 db collate c2 c2
82 b TEXT UNIQUE COLLATE c2,
127 REINDEX c2;
166 } {1 {no such collation sequence: c2}}
H A Dfkey8.test133 CREATE TABLE c2(
141 INSERT INTO c2 VALUES(13, 13);
142 INSERT OR REPLACE INTO c2 VALUES(13, 13);
143 DELETE FROM c2;
187 c2 NUMERIC,
188 FOREIGN KEY(c1) REFERENCES t1(c2)
191 CREATE UNIQUE INDEX t1c1unique ON t1(c2);
H A Drowvalue9.test126 CREATE TABLE c2(x BLOB, y BLOB);
127 INSERT INTO c2 VALUES(1, 1);
130 SELECT * FROM c1 WHERE (a, b) IN (SELECT x, y FROM c2)
134 SELECT * FROM c1 WHERE (a, b) IN (SELECT x, y FROM c2)
137 SELECT * FROM c1 WHERE (a, +b) IN (SELECT x, y FROM c2)
141 SELECT c1.rowid FROM c1 WHERE b = (SELECT y FROM c2);
144 SELECT c1.rowid FROM c1 WHERE (a, b) = (SELECT x, y FROM c2);
H A Dshell8.test88 set c2 ".ar cC ar1 ."
99 set c2 ".ar -cC ar1 ."
110 set c2 ".ar --directory ar1 --create ."
121 set c2 ".ar -C ar1 -c ."
148 catchcmd test_ar.db $c2
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
297 } {SEARCH v0 USING COVERING INDEX v3 (ANY(c1) AND c2=?)}
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5prefix.test205 INSERT INTO t2 SELECT c1||' '||c1, c2||' '||c2 FROM t2; -- 2
206 INSERT INTO t2 SELECT c1||' '||c1, c2||' '||c2 FROM t2; -- 4
207 INSERT INTO t2 SELECT c1||' '||c1, c2||' '||c2 FROM t2; -- 8
208 INSERT INTO t2 SELECT c1||' '||c1, c2||' '||c2 FROM t2; -- 16
209 INSERT INTO t2 SELECT c1||' '||c1, c2||' '||c2 FROM t2; -- 32
210 INSERT INTO t2 SELECT c1||' '||c1, c2||' '||c2 FROM t2; -- 64
211 INSERT INTO t2 SELECT c1||' '||c1, c2||' '||c2 FROM t2; -- 128
212 INSERT INTO t2 SELECT c1||' '||c1, c2||' '||c2 FROM t2; -- 256
213 INSERT INTO t2 SELECT c1||' '||c1, c2||' '||c2 FROM t2; -- 512
214 INSERT INTO t2 SELECT c1||' '||c1, c2||' '||c2 FROM t2; -- 1024
[all …]
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');
126 do_execsql_test 8.0.3 { SELECT rowid FROM t1('c2') } {2}
130 do_execsql_test 8.0.8 { SELECT rowid FROM t1('c2') ORDER BY rowid DESC } {2}
136 do_execsql_test 8.1.3 { SELECT rowid FROM t1('c2') } {2}
140 do_execsql_test 8.2.3 { SELECT rowid FROM t1('c2') ORDER BY rowid DESC} {2}
148 INSERT INTO t1 VALUES('a2 b2 c2');
159 INSERT INTO t1 VALUES('a2 b2 c2', '1 2 3');
/sqlite-3.40.0/src/
H A Dutf.c291 int c2 = *(zIn++); in sqlite3VdbeMemTranslate() local
292 c2 += (*(zIn++))<<8; in sqlite3VdbeMemTranslate()
293 if( c2<0xdc00 || c2>=0xe000 ){ in sqlite3VdbeMemTranslate()
297 c = ((c&0x3ff)<<10) + (c2&0x3ff) + 0x10000; in sqlite3VdbeMemTranslate()
302 int c2 = (*zIn++); in sqlite3VdbeMemTranslate()
303 c2 += ((*zIn++)<<8); in sqlite3VdbeMemTranslate()
320 int c2 = (*(zIn++))<<8; in sqlite3VdbeMemTranslate() local
321 c2 += *(zIn++); in sqlite3VdbeMemTranslate()
322 if( c2<0xdc00 || c2>=0xe000 ){ in sqlite3VdbeMemTranslate()
331 int c2 = ((*zIn++)<<8); in sqlite3VdbeMemTranslate()
[all …]
H A Dtest_quota.c257 int c, c2, cx; in quotaStrglob() local
276 while( c2!=c && c2!=cx ){ in quotaStrglob()
277 c2 = *(z++); in quotaStrglob()
291 c2 = *(zGlob++); in quotaStrglob()
292 if( c2=='^' ){ in quotaStrglob()
294 c2 = *(zGlob++); in quotaStrglob()
296 if( c2==']' ){ in quotaStrglob()
298 c2 = *(zGlob++); in quotaStrglob()
300 while( c2 && c2!=']' ){ in quotaStrglob()
306 if( c==c2 ){ in quotaStrglob()
[all …]
H A Dfunc.c764 if( c2!=c ) continue; in patternCompare()
782 c2 = sqlite3Utf8Read(&zPattern); in patternCompare()
783 if( c2=='^' ){ in patternCompare()
785 c2 = sqlite3Utf8Read(&zPattern); in patternCompare()
787 if( c2==']' ){ in patternCompare()
791 while( c2 && c2!=']' ){ in patternCompare()
797 if( c==c2 ){ in patternCompare()
800 prior_c = c2; in patternCompare()
810 c2 = Utf8Read(zString); in patternCompare()
811 if( c==c2 ) continue; in patternCompare()
[all …]
/sqlite-3.40.0/mptest/
H A Dmptest.c137 int c, c2; in strglob() local
155 while( c2!=c ){ in strglob()
156 c2 = *(z++); in strglob()
170 c2 = *(zGlob++); in strglob()
171 if( c2=='^' ){ in strglob()
173 c2 = *(zGlob++); in strglob()
175 if( c2==']' ){ in strglob()
177 c2 = *(zGlob++); in strglob()
179 while( c2 && c2!=']' ){ in strglob()
185 if( c==c2 ){ in strglob()
[all …]
/sqlite-3.40.0/ext/misc/
H A Dshathree.c85 u64 c0, c1, c2, c3, c4; in KeccakF1600Step() local
131 c2 = a02^a12^a22^a32^a42; in KeccakF1600Step()
135 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
137 d3 = c2^ROL64(c4, 1); in KeccakF1600Step()
202 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
204 d3 = c2^ROL64(c4, 1); in KeccakF1600Step()
269 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
271 d3 = c2^ROL64(c4, 1); in KeccakF1600Step()
336 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
338 d3 = c2^ROL64(c4, 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);

12345