Lines Matching refs:c0

604   CREATE TABLE t0(c0 TEXT PRIMARY KEY);
605   INSERT INTO t0(c0) VALUES ('');
606   SELECT (t0.c0, TRUE) > (CAST(0 AS REAL), FALSE) FROM t0;
607   SELECT 2 FROM t0 WHERE (t0.c0, TRUE) > (CAST('' AS REAL), FALSE);
613   CREATE TABLE t0(c0 UNIQUE);
614   INSERT INTO t0(c0) VALUES('a');
615   SELECT (t0.c0, 0) < ('B' COLLATE NOCASE, 0) FROM t0;
616   SELECT 2 FROM t0 WHERE (t0.c0, 0) < ('B' COLLATE NOCASE, 0);
619   SELECT ('B' COLLATE NOCASE, 0)> (t0.c0, 0) FROM t0;
620   SELECT 2 FROM t0 WHERE ('B' COLLATE NOCASE, 0)> (t0.c0, 0);
623   SELECT ('B', 0)> (t0.c0 COLLATE nocase, 0) FROM t0;
624   SELECT 2 FROM t0 WHERE ('B', 0)> (t0.c0 COLLATE nocase, 0);
627   SELECT (t0.c0 COLLATE nocase, 0) < ('B', 0) FROM t0;
628   SELECT 2 FROM t0 WHERE (t0.c0 COLLATE nocase, 0) < ('B', 0);
639   CREATE TABLE t0(c0);
642   SELECT (c0, x'') != (NULL, 0) FROM t1 LEFT JOIN t0;
645   SELECT 2 FROM t1 LEFT JOIN t0 ON (c0, x'') != (NULL, 0);
648   SELECT 21 FROM t0 RIGHT JOIN t1 ON (c0, x'') != (NULL, 0);
651   SELECT 3 FROM t1 LEFT JOIN t0 WHERE (c0, x'') != (NULL, 0);
654   SELECT 31 FROM t0 RIGHT JOIN t1 WHERE (c0, x'') != (NULL, 0);
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);
673    SELECT (SELECT c0,c1  FROM t0)  FROM t0;