Lines Matching full:where

109 # Check to see how WHERE clauses handle NULL values.  A NULL value
110 # is the same as UNKNOWN.  The WHERE clause should only select those
115     select a from t1 where b<10
120     select a from t1 where not b>10
125     select a from t1 where b<10 or c=1;
130     select a from t1 where b<10 and c=1;
135     select a from t1 where not (b<10 and c=1);
188     SELECT x FROM t4 WHERE y=NULL;
193     SELECT x FROM t4 WHERE y IN (33,NULL);
198     SELECT x FROM t4 WHERE y<33 ORDER BY x;
203     SELECT x FROM t4 WHERE y>6 ORDER BY x;
208     SELECT x FROM t4 WHERE y!=33 ORDER BY x;
214     SELECT x FROM t4 WHERE y=NULL;
219     SELECT x FROM t4 WHERE y IN (33,NULL);
224     SELECT x FROM t4 WHERE y<33 ORDER BY x;
229     SELECT x FROM t4 WHERE y>6 ORDER BY x;
234     SELECT x FROM t4 WHERE y!=33 ORDER BY x;