Lines Matching refs:c1

647     CREATE TABLE t1(c1);
648     CREATE VIEW v1 AS SELECT c1 FROM (SELECT t1.c1 FROM t1);
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