Lines Matching full:where

42     set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
51   set sql {SELECT DISTINCT f1 FROM tbl1 WHERE f1>3 AND f1<5}
56     set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
82   execsql {SELECT count(*) FROM tbl2 WHERE f2>1000}
86   execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
94   execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
97   execsql {SELECT f1 FROM tbl2 WHERE f2=1000}
101   execsql {SELECT * FROM tbl2 WHERE 1000=f2}
106   execsql {SELECT * FROM tbl2 WHERE f2=1000}
115   execsql {SELECT f1 FROM tbl2 WHERE f2==2000}
119 # Make sure we can optimize functions in the WHERE clause that
130     SELECT * FROM aa, bb WHERE max(a,b)>2;
136     SELECT * FROM aa, bb WHERE b;
141     SELECT * FROM aa, bb WHERE NOT b;
146     SELECT * FROM aa, bb WHERE min(a,b);
151     SELECT * FROM aa, bb WHERE NOT min(a,b);
156     SELECT * FROM aa, bb WHERE CASE WHEN a=b-1 THEN 1 END;
161     SELECT * FROM aa, bb WHERE CASE WHEN a=b-1 THEN 0 ELSE 1 END;