Home
last modified time | relevance | path

Searched refs:c1 (Results 1 – 25 of 146) sorted by relevance

123456

/sqlite-3.40.0/test/
H A Drowvalue4.test154 CREATE TABLE c1(a, b, c, d);
180 INSERT INTO c1(c, d) SELECT a, b FROM c1;
182 CREATE INDEX c1ab ON c1(a, b);
183 CREATE INDEX c1cd ON c1(c, d);
188 {SEARCH c1 USING INDEX c1cd (c=?)}
191 {SEARCH c1 USING INDEX c1cd (c=?)}
197 {SEARCH c1 USING INDEX c1cd (c>?)}
200 {SEARCH c1 USING INDEX c1ab (a=?)}
203 {SEARCH c1 USING INDEX c1ab (a=?)}
206 {SEARCH c1 USING INDEX c1ab (a=?)}
[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;
35 |--SCAN c1
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;
51 |--SCAN c1
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;
70 |--SCAN c1
102 |--SCAN c1
[all …]
H A Drowvalue3.test95 CREATE TABLE c1(a, b, c, d);
115 2 { CREATE INDEX c1ab ON c1(a, b); }
116 3 { CREATE INDEX c1ba ON c1(b, a); }
118 4 { CREATE INDEX c1cd ON c1(c, d); }
119 5 { CREATE INDEX c1dc ON c1(d, c); }
128 5 "SELECT c, d FROM c1 WHERE (c, d) IN (SELECT d, c FROM c1)"
131 6 "SELECT c, d FROM c1 WHERE (c,d) IN (SELECT d, c FROM c1) ORDER BY c DESC"
135 SELECT c, d FROM c1 WHERE (c,d) IN (SELECT d, c FROM c1)
140 SELECT c, d FROM c1 WHERE (c,d) IN (SELECT d, c FROM c1)
145 SELECT c, d FROM c1 WHERE (c,d) IN (SELECT d, c FROM c1)
[all …]
H A Dupdate2.test123 CREATE INDEX c1d ON c1(d, b);
124 CREATE UNIQUE INDEX c1c ON c1(c, b);
126 INSERT INTO c1 VALUES(1, 'a', 1, 1);
127 INSERT INTO c1 VALUES(2, 'a', 15, 2);
128 INSERT INTO c1 VALUES(3, 'a', 3, 3);
129 INSERT INTO c1 VALUES(4, 'a', 4, 4);
137 SELECT * FROM c1 ORDER BY a;
152 DELETE FROM c1;
162 CREATE INDEX c1d ON c1(d);
163 CREATE UNIQUE INDEX c1c ON c1(c);
[all …]
H A Dfkey8.test30 CREATE TABLE c1(b REFERENCES p1);
35 CREATE TABLE c1(b REFERENCES p1 ON DELETE CASCADE);
49 CREATE TRIGGER ct1 AFTER DELETE ON c1 BEGIN
57 CREATE TABLE cc1(d REFERENCES c1);
118 INSERT INTO c1 VALUES(1);
119 INSERT INTO c1 VALUES(2);
186 c1 PRIMARY KEY,
188 FOREIGN KEY(c1) REFERENCES t1(c2)
190 CREATE INDEX t1c1 ON t1(c1);
236 CREATE TABLE c1(b);
[all …]
H A Dgencol1.test20 CREATE TABLE t0(c0 AS(TYPEOF(c1)), c1);
153 CREATE TABLE t0(c0 PRIMARY KEY, c1, c2 AS (c0+c1-c3) REFERENCES t0, c3);
168 c1 a UNIQUE AS (1),
170 c3 REFERENCES t0(c1)
210 CREATE TABLE t0(c0 NOT NULL AS(c1), c1);
295 c1 AS (1),
296 c2 CHECK (1 = c1)
305 c1 AS(c0 + c2),
499 CREATE TABLE t1(c1, c2 AS (c1 ISNULL));
507 SELECT c0, c1, c2 FROM t0 LEFT JOIN t1 ON c0=c1;
[all …]
H A Dwal_common.tcl28 upvar $ckv1 c1
31 set c1 [expr {($c1 + $v1 + $c2)&0xFFFFFFFF}]
32 set c2 [expr {($c2 + $v2 + $c1)&0xFFFFFFFF}]
43 upvar $ckv1 c1
53 wal_cksum_intlist c1 c2 $values
61 set c1 0
63 wal_cksum $endian c1 c2 $blob
64 append blob [binary format II $c1 $c2]
86 set c1 0
88 wal_cksum_intlist c1 c2 [lrange $hdr 0 9]
[all …]
H A Dcollate1.test66 CREATE TABLE collate1t1(c1, c2);
115 CREATE TABLE collate1t1(c1, c2);
141 SELECT c1, c2 FROM collate1t1
147 SELECT c1, c2 FROM collate1t1
185 SELECT c1, c2
242 SELECT a as c1, b as c2 FROM collate1t1 ORDER BY c1;
247 SELECT a as c1, b as c2 FROM collate1t1 ORDER BY c1 COLLATE binary;
253 FROM collate1t1 ORDER BY c1;
383 INSERT INTO c1 VALUES(2, 'abb');
384 INSERT INTO c1 VALUES(3, 'wxz');
[all …]
H A Dtkt-f973c7ac31.test19 CREATE TABLE t(c1 INTEGER, c2 INTEGER);
27 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
[all …]
H A Dreindex.test71 proc c1 {a b} {
77 db collate c1 c1
81 a TEXT PRIMARY KEY COLLATE c1,
113 proc c1 {a b} {
139 REINDEX c1;
150 REINDEX c1;
152 } {1 {no such collation sequence: c1}}
155 db2 collate c1 c1
159 REINDEX c1;
179 c1 UNIQUE DEFAULT NULL
[all …]
H A Dcollate3.test35 CREATE TABLE collate3t1(c1 UNIQUE);
192 SELECT * FROM collate3t1 ORDER BY c1;
227 SELECT * FROM collate3t1 GROUP BY c1;
232 SELECT DISTINCT c1 FROM collate3t1;
239 SELECT c1 FROM collate3t1 UNION SELECT c1 FROM collate3t1;
244 SELECT c1 FROM collate3t1 EXCEPT SELECT c1 FROM collate3t1;
249 SELECT c1 FROM collate3t1 INTERSECT SELECT c1 FROM collate3t1;
254 SELECT c1 FROM collate3t1 UNION ALL SELECT c1 FROM collate3t1;
279 SELECT c1 FROM collate3t1 UNION ALL SELECT c1 FROM collate3t1 ORDER BY 1;
315 UPDATE collate3t1 SET c1 = 'xxx';
[all …]
H A Dintreal.test63 CREATE TABLE t1 (c1 REAL);
64 INSERT INTO t1(c1) VALUES (8366271098608253588);
67 set D [db one {SELECT c1 FROM t1}]
70 SELECT * FROM t1 WHERE (t1.c1 = CAST(8366271098608253588 AS REAL));
74 SELECT * FROM t0, t1 WHERE (t1.c1 = CAST(8366271098608253588 AS REAL));
80 t1.c1 >= CAST(8366271098608253588 AS REAL)
81 AND t1.c1 <= CAST(8366271098608253588 AS REAL)
90 CREATE TABLE t0 (c0 REAL, c1);
91 CREATE UNIQUE INDEX i0 ON t0(c1, 0 | c0);
93 UPDATE OR REPLACE t0 SET c0 = 'a', c1 = '';
[all …]
H A Dalterdropcol2.test141 ALTER TABLE c1 DROP v
149 CREATE TABLE c1(u, v, w AS (u+v));
151 ALTER TABLE c1 DROP v
156 CREATE TABLE c1(u, v, w AS (u+v) STORED);
158 ALTER TABLE c1 DROP u
167 CREATE TABLE c1(u, v, w);
172 ALTER TABLE c1 DROP w
177 CREATE TABLE c1(u, v, w);
180 ALTER TABLE c1 DROP w
185 CREATE TABLE c1(u, v, w);
[all …]
H A Djoin2.test148 CREATE TABLE c1(k INTEGER PRIMARY KEY, v1);
152 INSERT INTO c1 VALUES(1, 2);
156 INSERT INTO c1 VALUES(111, 1112);
179 |--SCAN c1
187 |--SCAN c1
192 DROP TABLE c1;
195 CREATE TABLE c1(k UNIQUE, v1);
199 INSERT INTO c1 VALUES(1, 2);
203 INSERT INTO c1 VALUES(111, 1112);
226 |--SCAN c1
[all …]
H A DtriggerA.test65 SELECT CAST(x AS TEXT) AS c1 FROM t1 UNION SELECT y FROM t1;
66 SELECT * FROM v3 ORDER BY c1;
72 SELECT CAST(x AS TEXT) AS c1 FROM t1
135 INSERT INTO result1(a) VALUES(old.c1);
137 DELETE FROM v3 WHERE c1 BETWEEN '8' AND 'eight';
145 INSERT INTO result2(a,b) VALUES(old.c1, new.c1);
147 UPDATE v3 SET c1 = c1 || '-extra' WHERE c1 BETWEEN '8' and 'eight';
157 INSERT INTO result1(a) VALUES(old.c1);
159 DELETE FROM v4 WHERE c1 BETWEEN '8' AND 'eight';
167 INSERT INTO result2(a,b) VALUES(old.c1, new.c1);
[all …]
H A Dbestindex9.test83 CREATE TABLE x(c1, c2, c3);
85 SELECT DISTINCT c1 FROM t1 ORDER BY c1
91 CREATE TABLE x(c1, c2, c3);
93 SELECT DISTINCT c1 FROM t1 GROUP BY c1
97 CREATE TABLE x(c1, c2, c3);
100 SELECT DISTINCT c1 FROM t1, t2
H A Dminmax4.test184 CREATE TABLE t0 (c0, c1);
185 CREATE INDEX i0 ON t0(c1, c1 + 1 DESC);
189 SELECT MIN(t0.c1), t0.c0 FROM t0 WHERE t0.c1 ISNULL;
223 CREATE TABLE t0(c0 UNIQUE, c1);
224 INSERT INTO t0(c1) VALUES (0);
226 CREATE VIEW v0(c0, c1) AS
227 SELECT t0.c1, t0.c0 FROM t0 WHERE CAST(t0.rowid AS INT) = 1;
230 SELECT c0, c1 FROM v0;
233 SELECT v0.c0, MIN(v0.c1) FROM v0;
H A Dview.test647 CREATE TABLE t1(c1);
648 CREATE VIEW v1 AS SELECT c1 FROM (SELECT t1.c1 FROM t1);
717 CREATE TABLE t0(c0 TEXT, c1);
719 CREATE VIEW v0(c0, c1) AS SELECT t0.c0, AVG(t0.c1) FROM t0;
723 SELECT c0, typeof(c0), c1, typeof(c1) FROM v0;
732 SELECT 1 FROM v0 WHERE c1<c0
735 SELECT 1 FROM v0 WHERE c0<c1
739 SELECT c0<c1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0)
742 SELECT c1<c0 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0)
745 SELECT 1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0) WHERE c1<c0
[all …]
H A Dshell6.test26 CREATE TABLE c1(x, y REFERENCES p1);
28 CREATE INDEX 'c1_y' ON 'c1'('y'); --> p1(a)
48 CREATE TABLE c1('x y z' REFERENCES p1);
49 CREATE INDEX i1 ON c1('x y z') WHERE "x y z" IS NOT NULL;
55 CREATE TABLE c1('x y z' REFERENCES p1);
56 CREATE INDEX i1 ON c1('x y z') WHERE "x y z" IS NOT 12;
58 CREATE INDEX 'c1_x y z' ON 'c1'('x y z'); --> p1(b b b)
92 CREATE TABLE c1(x INTEGER PRIMARY KEY REFERENCES p1(b));
H A Dpragma4.test214 CREATE TABLE main.c1 (a, b, c REFERENCES t1(a));
218 do_execsql_test 4.5.1 { SELECT * FROM pragma_foreign_key_list('c1') } {
226 execsql { DROP TABLE c1 } db3
233 do_execsql_test 4.5.4 { SELECT * FROM pragma_foreign_key_list('c1') }
239 CREATE TABLE main.c1 (a, b, c REFERENCES t1(a));
241 INSERT INTO main.c1 VALUES(1, 2, 3);
244 do_execsql_test 4.6.1 { pragma foreign_key_check('c1') } {
245 c1 1 t1 0
253 do_execsql_test 4.6.4 { pragma foreign_key_check('c1') } {c1 1 t1 0}
H A Dalterdropcol.test214 CREATE TABLE c1(x, y, z REFERENCES p1(c));
218 ALTER TABLE c1 DROP COLUMN z;
220 SELECT sql FROM sqlite_schema WHERE name IN ('c1', 'c2');
222 {CREATE TABLE c1(x, y)}
230 ALTER TABLE c1 DROP COLUMN x
234 CREATE VIEW v1 AS SELECT x, y FROM c1;
237 ALTER TABLE c1 DROP COLUMN x
241 CREATE TRIGGER tr AFTER INSERT ON c1 BEGIN
246 ALTER TABLE c1 DROP COLUMN y
250 CREATE TRIGGER tr AFTER INSERT ON c1 BEGIN
[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]
93 set c1 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
123 set c1 0
125 wal_cksum $endian c1 c2 $blob
[all …]
/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.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');
120 INSERT INTO t1 VALUES('a1 b1 c1');
122 INSERT INTO t1 VALUES('a1 b1 c1');
147 INSERT INTO t1 VALUES('a1 b1 c1');
149 INSERT INTO t1 VALUES('a1 b1 c1');
[all …]
/sqlite-3.40.0/ext/misc/
H A Dshathree.c85 u64 c0, c1, c2, c3, c4; in KeccakF1600Step() local
130 c1 = a01^a11^a21^a31^a41; in KeccakF1600Step()
134 d0 = c4^ROL64(c1, 1); in KeccakF1600Step()
136 d2 = c1^ROL64(c3, 1); in KeccakF1600Step()
201 d0 = c4^ROL64(c1, 1); in KeccakF1600Step()
203 d2 = c1^ROL64(c3, 1); in KeccakF1600Step()
268 d0 = c4^ROL64(c1, 1); in KeccakF1600Step()
270 d2 = c1^ROL64(c3, 1); in KeccakF1600Step()
335 d0 = c4^ROL64(c1, 1); in KeccakF1600Step()
337 d2 = c1^ROL64(c3, 1); in KeccakF1600Step()
[all …]

123456