Lines Matching refs:values

26     insert into t1 values(1,0,0);
27     insert into t1 values(2,0,1);
28     insert into t1 values(3,1,0);
29     insert into t1 values(4,1,1);
30     insert into t1 values(5,null,0);
31     insert into t1 values(6,null,1);
32     insert into t1 values(7,null,null);
51 # Check to see how the CASE expression handles NULL values.  The
96 # Check to see that NULL values are ignored in aggregate functions.
113 # Check to see how WHERE clauses handle NULL values.  A NULL value
143 # The DISTINCT keyword on a SELECT statement should treat NULL values
152 # A UNION to two queries should treat NULL values
194 # The UNIQUE constraint only applies to non-null values
200       insert into t2 values(1,1);
201       insert into t2 values(2,null);
202       insert into t2 values(3,null);
203       insert into t2 values(4,1);
210       insert into t3 values(1,1,1);
211       insert into t3 values(2,null,1);
212       insert into t3 values(3,null,1);
213       insert into t3 values(4,1,1);