Lines Matching refs:c0

717   CREATE TABLE t0(c0 TEXT, c1);
718   INSERT INTO t0(c0, c1) VALUES (-1, 0);
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;
729 do_execsql_test view-27.2 { SELECT c0<c1 FROM v0 } 1
730 do_execsql_test view-27.3 { SELECT c1<c0 FROM v0 } 0
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
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;
756   INSERT INTO t0(c0) VALUES ('0');
759   SELECT 0 IN (c0) FROM t0;
762   SELECT 0 IN (c0) FROM (SELECT c0 FROM t0);