Home
last modified time | relevance | path

Searched refs:c0 (Results 1 – 25 of 80) sorted by relevance

1234

/sqlite-3.40.0/test/
H A Daffinity2.test64 CREATE TABLE ttt(c0, c1);
93 CREATE TABLE t0(c0 TEXT UNIQUE, c1);
94 INSERT INTO t0(c0) VALUES (-1);
95 SELECT quote(- x'ce'), quote(t0.c0), quote(- x'ce' >= t0.c0) FROM t0;
98 SELECT * FROM t0 WHERE - x'ce' >= t0.c0;
101 SELECT quote(+-+x'ce'), quote(t0.c0), quote(+-+x'ce' >= t0.c0) FROM t0;
107 SELECT quote(- 'ce'), quote(t0.c0), quote(- 'ce' >= t0.c0) FROM t0;
110 SELECT * FROM t0 WHERE - 'ce' >= t0.c0;
113 SELECT quote(+-+'ce'), quote(t0.c0), quote(+-+'ce' >= t0.c0) FROM t0;
116 SELECT * FROM t0 WHERE +-+'ce' >= t0.c0;
[all …]
H A Dcursorhint2.test61 t1 EQ(c0,1)
73 t2 {EQ(r[2],c0)}
85 t1 EQ(c0,10) t2 {AND(ISNULL(c1),EQ(r[3],c0))}
98 t2 {EQ(r[2],c0)} t3 {AND(EQ(r[6],c0),EQ(r[7],c1))}
112 x2 {EQ(c0,r[2])}
118 x2 {EQ(c0,r[2])}
124 x2 {EQ(c0,r[2])}
130 x2 {EQ(c0,r[2])}
136 x2 {EQ(c0,r[2])}
186 x2 {EQ(c0,r[2])}
[all …]
H A Dgencol1.test155 UPDATE t0 SET c1 = c0, c3 = c0;
159 UPDATE t0 SET c1 = c0, c3 = c0+1;
167 c0,
304 c0,
346 c0,
359 c0,
372 c0,
386 c0,
405 CREATE TABLE t0 (c0, c1 NOT NULL AS (c0==0));
507 SELECT c0, c1, c2 FROM t0 LEFT JOIN t1 ON c0=c1;
[all …]
H A Dunionall.test66 CREATE TABLE t0(c0 INT);
406 CREATE VIEW v0(c0) AS SELECT CAST(t0.c0 AS INTEGER) FROM t0;
414 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
417 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
420 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
424 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
427 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
430 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
434 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
437 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
[all …]
H A Dindexexpr2.test282 CREATE TABLE IF NOT EXISTS t0(c0);
287 CREATE INDEX i0 ON t0(ABS(c0));
292 CREATE INDEX i0 ON t0(c0);
293 } {{CREATE TABLE t0(c0)}}
301 CREATE TABLE t0(c0);
302 CREATE INDEX i0 ON t0(c0) WHERE c0 NOT NULL;
303 INSERT INTO t0(c0) VALUES (NULL);
314 1 " 0 == (34 BETWEEN c0 AND 33)"
315 2 " 1 != (34 BETWEEN c0 AND 33)"
316 3 "-1 < (34 BETWEEN c0 AND 33)"
[all …]
H A Dindex6.test420 CREATE TABLE t0(c0);
421 CREATE INDEX index_0 ON t0(c0) WHERE c0 NOT NULL;
423 SELECT * FROM t0 WHERE c0 OR 1;
431 CREATE INDEX IF NOT EXISTS i0 ON t0(c0, c1) WHERE c0 NOT NULL;
447 CREATE TABLE t0(c0);
472 SELECT c1 <= c0, c0 >= c1 FROM t0;
475 SELECT 2 FROM t0 WHERE c0 >= c1;
478 SELECT 3 FROM t0 WHERE c1 <= c0;
486 CREATE TABLE t0(c0);
487 CREATE INDEX i0 ON t0(0) WHERE c0 GLOB c0;
[all …]
H A DwhereL.test131 CREATE TABLE t0(c0);
133 CREATE VIEW v0(c0) AS SELECT CAST(0 AS INT) FROM t0;
134 SELECT 200, * FROM t0, v0 WHERE 0 = t0.c0 AND t0.c0 = v0.c0;
137 SELECT 200, * FROM t0, v0 WHERE t0.c0 = 0 AND t0.c0 = v0.c0;
140 SELECT 200, * FROM t0, v0 WHERE 0 = t0.c0 AND v0.c0 = t0.c0;
143 SELECT 200, * FROM t0, v0 WHERE t0.c0 = 0 AND v0.c0 = t0.c0;
H A Dview.test719 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
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
748 SELECT 1 FROM (SELECT t0.c0 AS c0, AVG(t0.c1) AS c1 FROM t0) WHERE c0<c1
754 CREATE TABLE t0(c0 TEXT);
755 CREATE VIEW v0(c0) AS SELECT t0.c0 FROM t0;
759 SELECT 0 IN (c0) FROM t0;
[all …]
H A Dexpr2.test20 CREATE TABLE t0(c0);
21 INSERT INTO t0(c0) VALUES ('val');
26 ( (0 IS NOT FALSE) OR NOT (0 IS FALSE OR (t0.c0 = 1)) ) IS 0
32 ( (0 IS NOT FALSE) OR NOT (0 IS FALSE OR (t0.c0 = 1)) ) IS 0
38 ( (0 IS NOT FALSE) OR NOT (0 IS 0 OR (t0.c0 = 1)) ) IS 0
43 SELECT ( (0 IS NOT FALSE) OR NOT (0 IS FALSE OR (t0.c0 = 1)) ) FROM t0
50 SELECT NOT (0 IS FALSE OR (t0.c0 = 1)) FROM t0
H A Dtkt-18458b1a.test34 CREATE TABLE t0(c0 COLLATE NOCASE);
35 INSERT INTO t0(c0) VALUES ('B');
36 CREATE VIEW v0(c0, c1) AS SELECT DISTINCT t0.c0, 'a' FROM t0;
40 SELECT count(*) FROM v0 WHERE c1 >= c0;
44 SELECT count(*) FROM v0 WHERE NOT NOT (c1 >= c0);
48 SELECT count(*) FROM v0 WHERE ((c1 >= c0) OR 0+0);
H A Dcursorhint.test67 } {{EQ(r[1],c0)}}
80 } {{EQ(c0,r[1])}}
93 } {AND(AND(EQ(c0,15),EQ(c2,22)),NE(rowid,98))}
98 } {AND(AND(LT(c1,15),GT(c2,22)),NE(c0,98))}
115 } {GT(c0,11)}
125 } {LT(c0,11)}
141 } {LE(c0,20)}
146 } {GE(c0,10)}
155 } {AND(AND(EQ(c0,22),GE(c1,10)),LE(c1,20))}
160 } {AND(AND(EQ(c0,22),GE(c1,10)),LE(c1,20))}
H A Dlike3.test185 CREATE TABLE t5c (c0 REAL);
187 INSERT INTO t5c(rowid, c0) VALUES (99,'+/');
188 SELECT * FROM t5c WHERE (c0 LIKE '+/');
197 INSERT INTO t0(c0) VALUES ('./');
198 SELECT * FROM t0 WHERE t0.c0 LIKE './';
206 INSERT INTO t0(c0) VALUES ('.1%');
207 SELECT * FROM t0 WHERE t0.c0 LIKE '.1%';
214 CREATE TABLE t0(c0 UNIQUE);
215 INSERT INTO t0(c0) VALUES(-1);
216 SELECT * FROM t0 WHERE t0.c0 GLOB '-*';
[all …]
H A Djoin2.test302 CREATE TABLE t0(c0);
303 CREATE TABLE t1(c0);
308 WHERE (t1.c0 BETWEEN 0 AND 0) > ('' AND t0.c0);
319 CREATE TABLE t0(c0 INT);
320 CREATE VIEW v0(c0) AS SELECT CAST(t0.c0 AS INTEGER) FROM t0;
321 INSERT INTO t0(c0) VALUES (0);
325 SELECT typeof(c0), c0 FROM v0 WHERE c0>='0'
329 SELECT * FROM t0, v0 WHERE v0.c0 >= '0';
333 SELECT * FROM t0 LEFT JOIN v0 WHERE v0.c0 >= '0';
337 SELECT * FROM t0 LEFT JOIN v0 ON v0.c0 >= '0';
[all …]
H A Drowvalue.test604 CREATE TABLE t0(c0 TEXT PRIMARY KEY);
605 INSERT INTO t0(c0) VALUES ('');
613 CREATE TABLE t0(c0 UNIQUE);
614 INSERT INTO t0(c0) VALUES('a');
619 SELECT ('B' COLLATE NOCASE, 0)> (t0.c0, 0) FROM t0;
623 SELECT ('B', 0)> (t0.c0 COLLATE nocase, 0) FROM t0;
639 CREATE TABLE t0(c0);
661 CREATE TABLE t0(c0 CHECK(((0, 0) > (0, c0))));
662 INSERT INTO t0(c0) VALUES(0) ON CONFLICT(c0) DO UPDATE SET c0 = 3;
671 CREATE TABLE t0(c0 PRIMARY KEY, c1);
[all …]
H A Dminmax4.test184 CREATE TABLE t0 (c0, c1);
186 INSERT INTO t0(c0) VALUES (1);
189 SELECT MIN(t0.c1), t0.c0 FROM t0 WHERE t0.c1 ISNULL;
223 CREATE TABLE t0(c0 UNIQUE, c1);
225 INSERT INTO t0(c0) 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 Dintreal.test62 CREATE TABLE t0 (c0);
65 INSERT INTO t0(c0) VALUES ('a');
90 CREATE TABLE t0 (c0 REAL, c1);
91 CREATE UNIQUE INDEX i0 ON t0(c1, 0 | c0);
92 INSERT INTO t0(c0) VALUES (4750228396194493326), (0);
93 UPDATE OR REPLACE t0 SET c0 = 'a', c1 = '';
H A DjoinH.test59 CREATE TABLE t0 (c0);
60 CREATE TABLE t1 (c0);
61 CREATE TABLE t2 (c0 , c1 , c2 , UNIQUE (c0), UNIQUE (c2 DESC));
64 CREATE VIEW v0(c0) AS SELECT FALSE;
68 SELECT * FROM t0 LEFT OUTER JOIN t1 ON v0.c0 INNER JOIN v0 INNER JOIN t2 ON (t2.c2 NOT NULL);
H A Djoin8.test303 CREATE TABLE t2(c0);
304 CREATE TABLE t2i(c0 INT);
305 CREATE TABLE t3(c0 INT);
312 SELECT DISTINCT t1.c0, t3.c0
316 SELECT t1.c0, t3.c0
320 SELECT DISTINCT t1.c0, t3.c0
324 SELECT t1.c0, t3.c0
328 SELECT DISTINCT t1.c0, t3.c0
332 SELECT DISTINCT +t1.c0, t3.c0
336 SELECT DISTINCT +t1.c0, t3.c0
[all …]
H A Daltertab3.test181 CREATE TABLE t0(c0);
188 {CREATE TABLE "t1"(c0)}
192 CREATE TABLE t2 (c0);
193 CREATE INDEX i2 ON t2((LIKELIHOOD(c0, 100) IN ()));
194 ALTER TABLE t2 RENAME COLUMN c0 TO c1;
200 {CREATE INDEX i2 ON t2((LIKELIHOOD(c0, 100) IN ()))}
666 …c0 , c1 AS (CASE TRUE NOT IN () WHEN NULL THEN CASE + 0xa ISNULL WHEN NOT + 0x9 THEN …
H A Dtkt-a7debbe0.test86 CREATE TABLE t0(c0);
87 INSERT INTO t0(c0) VALUES('');
88 CREATE VIEW v2(c0, c1) AS
89 SELECT 'B' COLLATE NOCASE, 'a' FROM t0 ORDER BY t0.c0;
91 SELECT v2.c1 BETWEEN v2.c0 AND v2.c1 as count FROM v2
98 SELECT v2.c1 BETWEEN v2.c0 AND v2.c1 as count FROM v2;
H A Ddistinct2.test236 CREATE TABLE t0 (c0, c1, c2, PRIMARY KEY (c0, c1));
243 SELECT DISTINCT t0.c0, t1._rowid_, t0.c1 FROM t1 CROSS JOIN t0 ORDER BY t0.c0;
249 SELECT DISTINCT t0.c0, t1._rowid_, t0.c1 FROM t1 CROSS JOIN t0 ORDER BY t0.c0;
281 CREATE TABLE t0 (c0, c1 NOT NULL DEFAULT 1, c2, PRIMARY KEY (c0, c1));
287 SELECT DISTINCT * FROM t0 WHERE NULL IS t0.c0;
298 SELECT DISTINCT * FROM t0 WHERE NULL IS c0;
/sqlite-3.40.0/ext/rtree/
H A Drtreefuzz001.test236 | 2064: 00 40 c0 00 00 00 00 00 00 00 00 05 de 40 00 00 .@...........@..
237 | 2080: 00 40 40 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .@@..@...@......
239 | 2112: 00 40 c0 00 00 00 00 00 00 00 00 05 dc 00 00 00 .@..............
240 | 2128: 00 3f 80 00 00 40 a0 00 00 40 c0 00 00 00 00 00 .?...@...@......
241 | 2144: 00 00 00 06 43 40 40 00 00 40 80 00 00 40 c0 00 ....C@@..@...@..
243 | 2176: 00 40 40 00 00 40 c0 00 00 40 e0 00 00 00 00 00 .@@..@...@......
244 | 2192: 00 00 00 06 41 3f 80 00 00 40 00 00 00 40 c0 00 ....A?...@...@..
246 | 2224: 00 3f 80 00 00 40 c0 00 00 40 e0 00 00 00 00 00 .?...@...@......
394 | 1792: 00 40 c0 00 00 40 c0 00 00 40 e0 00 00 00 00 00 .@...@...@......
407 | 2000: 00 00 00 06 46 40 c0 00 00 40 e0 00 00 40 c0 00 ....F@...@...@..
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5misc.test65 CREATE TABLE t0(c0);
70 INSERT INTO vt0(c0) VALUES ('xyz');
79 INSERT INTO vt0(c0) VALUES ('abc');
88 CREATE TABLE t0(c0);
91 INSERT INTO vt0(c0) VALUES ('xyz');
102 INSERT INTO vt0(c0) VALUES ('abc');
128 INSERT INTO vt0(c0) VALUES ('xyz');
133 INSERT INTO vt0(c0) VALUES ('abc');
163 INSERT INTO vt0(c0) SELECT '0' FROM s;
226 INSERT INTO vt0(c0) VALUES (x'd1');
[all …]
H A Dfts5savepoint.test56 CREATE VIRTUAL TABLE vt0 USING fts5(c0);
57 CREATE VIRTUAL TABLE vt1 USING fts4(c0);
58 INSERT INTO vt1(c0) VALUES(0);
63 UPDATE vt1 SET c0 = 0;
64 INSERT INTO vt1(c0) VALUES (0), (0);
65 UPDATE vt0 SET c0 = 0;
66 INSERT INTO vt1(c0) VALUES (0);
67 UPDATE vt1 SET c0 = 0;
69 UPDATE vt1 SET c0 = 0;
/sqlite-3.40.0/ext/misc/
H A Dshathree.c85 u64 c0, c1, c2, c3, c4; in KeccakF1600Step() local
129 c0 = a00^a10^a20^a30^a40; in KeccakF1600Step()
135 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
138 d4 = c3^ROL64(c0, 1); in KeccakF1600Step()
196 c0 = a00^a20^a40^a10^a30; in KeccakF1600Step()
202 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
205 d4 = c3^ROL64(c0, 1); in KeccakF1600Step()
269 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
272 d4 = c3^ROL64(c0, 1); in KeccakF1600Step()
336 d1 = c0^ROL64(c2, 1); in KeccakF1600Step()
[all …]

1234