Lines Matching refs:c2
153 CREATE TABLE t0(c0 PRIMARY KEY, c1, c2 AS (c0+c1-c3) REFERENCES t0, c3);
169 c2,
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);
223 CREATE TABLE t0 (c0 GENERATED ALWAYS AS (1), c1 UNIQUE, c2 UNIQUE);
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',
350 FOREIGN KEY(c1) REFERENCES t0(c2)
362 c2 BLOB UNIQUE DEFAULT x'00',
363 FOREIGN KEY(c1) REFERENCES t0(c2)
375 c2 BLOB UNIQUE DEFAULT x'00',
376 FOREIGN KEY(c1) REFERENCES t0(c2)
388 c2 BLOB UNIQUE DEFAULT x'00',
389 FOREIGN KEY(c1) REFERENCES t0(c2)
441 CREATE TABLE t0(c0 AS(1 >= 1), c1 UNIQUE AS(TYPEOF(c0)), c2);
493 CREATE TABLE t1(c1, c2 AS(1));
495 SELECT c0, c1, c2 FROM t0 LEFT JOIN t1;
499 CREATE TABLE t1(c1, c2 AS (c1 ISNULL));
500 SELECT c0, c1, c2 FROM t0 LEFT JOIN t1;
507 SELECT c0, c1, c2 FROM t0 LEFT JOIN t1 ON c0=c1;
542 CREATE TABLE t0(c0 UNIQUE AS(0), c1, c2);
547 UPDATE t0 SET c1=0, c2=0 WHERE c0>=0;