Lines Matching refs:c0

420   CREATE TABLE t0(c0);
421   CREATE INDEX index_0 ON t0(c0) WHERE c0 NOT NULL;
422   INSERT INTO t0(c0) VALUES (NULL);
423   SELECT * FROM t0 WHERE c0 OR 1;
430   CREATE TABLE IF NOT EXISTS t0 (c0, c1);
431   CREATE INDEX IF NOT EXISTS i0 ON t0(c0, c1) WHERE c0 NOT NULL;
432   INSERT INTO t0(c0, c1) VALUES(NULL, 'row');
433   SELECT * FROM t0 WHERE t0.c0 IS NOT 1;
437   SELECT * FROM t0 WHERE CASE c0 WHEN 0 THEN 0 ELSE 1 END;
447   CREATE TABLE t0(c0);
448   INSERT INTO t0(c0) VALUES (NULL);
449   CREATE INDEX i0 ON t0(1) WHERE c0 NOT NULL;
450   SELECT 1 FROM t0 WHERE (t0.c0 IS FALSE) IS FALSE;
453   SELECT 1 FROM t0 WHERE (t0.c0 IS FALSE) BETWEEN FALSE AND TRUE;
456   SELECT 1 FROM t0 WHERE TRUE BETWEEN (t0.c0 IS FALSE) AND TRUE;
459   SELECT 1 FROM t0 WHERE FALSE BETWEEN FALSE AND (t0.c0 IS FALSE);
462   SELECT 1 FROM t0 WHERE (c0 IS FALSE) IN (FALSE);
469   CREATE TABLE t0(c0 COLLATE NOCASE, c1);
470   CREATE INDEX i0 ON t0(0) WHERE c0 >= c1;
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;
498   SELECT COUNT(*) FROM t0 WHERE t0.c0 GLOB t0.c0;