Lines Matching refs:c0

282   CREATE TABLE IF NOT EXISTS t0(c0);
283   INSERT INTO t0(c0) VALUES (-9223372036854775808);
287   CREATE INDEX i0 ON t0(ABS(c0));
292   CREATE INDEX i0 ON t0(c0);
293 } {{CREATE TABLE t0(c0)}}
301   CREATE TABLE t0(c0);
302   CREATE INDEX i0 ON t0(c0) WHERE c0 NOT NULL;
303   INSERT INTO t0(c0) VALUES (NULL);
307   SELECT * FROM t0 WHERE ~('' BETWEEN t0.c0 AND TRUE);
310   SELECT ~('' BETWEEN t0.c0 AND TRUE) FROM t0;
314   1 " 0  ==  (34 BETWEEN c0 AND 33)"
315   2 " 1  !=  (34 BETWEEN c0 AND 33)"
316   3 "-1   <  (34 BETWEEN c0 AND 33)"
317   4 "-1  <=  (34 BETWEEN c0 AND 33)"
318   5 " 1   >  (34 BETWEEN c0 AND 33)"
319   6 " 1  >=  (34 BETWEEN c0 AND 33)"
320   7 " 1   -  (34 BETWEEN c0 AND 33)"
321   8 "-1   +  (34 BETWEEN c0 AND 33)"
322   9 " 1   |  (34 BETWEEN c0 AND 33)"
323  10 " 1  <<  (34 BETWEEN c0 AND 33)"
324  11 " 1  >>  (34 BETWEEN c0 AND 33)"
325  12 " 1  ||  (34 BETWEEN c0 AND 33)"
327   do_execsql_test 8.3.$tn.1 "SELECT * FROM t0 WHERE $expr ORDER BY c0" { {} }