Lines Matching refs:c0

64   CREATE TABLE ttt(c0, c1);
65   CREATE INDEX ii ON ttt(CAST(c0 AS NUMERIC)); 
69   SELECT * FROM ttt WHERE CAST(c0 AS NUMERIC) > c1 GROUP BY rowid; 
72   SELECT * FROM ttt INDEXED BY ii WHERE CAST(c0 AS NUMERIC) > c1 GROUP BY rowid;
93   CREATE TABLE t0(c0 TEXT UNIQUE, c1);
94   INSERT INTO t0(c0) VALUES (-1);
95   SELECT quote(- x'ce'), quote(t0.c0), quote(- x'ce' >= t0.c0) FROM t0;
98   SELECT * FROM t0 WHERE - x'ce' >= t0.c0;
101   SELECT quote(+-+x'ce'), quote(t0.c0), quote(+-+x'ce' >= t0.c0) FROM t0;
104   SELECT * FROM t0 WHERE +-+x'ce' >= t0.c0;
107   SELECT quote(- 'ce'), quote(t0.c0), quote(- 'ce' >= t0.c0) FROM t0;
110   SELECT * FROM t0 WHERE - 'ce' >= t0.c0;
113   SELECT quote(+-+'ce'), quote(t0.c0), quote(+-+'ce' >= t0.c0) FROM t0;
116   SELECT * FROM t0 WHERE +-+'ce' >= t0.c0;
127     CREATE TABLE t0(c0 REAL UNIQUE);
128     INSERT INTO t0(c0) VALUES (3175546974276630385);
129     SELECT 3175546974276630385 < c0 FROM t0;
132     SELECT 1 FROM t0 WHERE 3175546974276630385 < c0;