Lines Matching refs:values
29 insert into t1 values(1,0,0);
30 insert into t1 values(2,0,1);
31 insert into t1 values(3,1,0);
32 insert into t1 values(4,1,1);
33 insert into t1 values(5,null,0);
34 insert into t1 values(6,null,1);
35 insert into t1 values(7,null,null);
54 # Check to see how the CASE expression handles NULL values. The
99 # Check to see that NULL values are ignored in aggregate functions.
109 # Check to see how WHERE clauses handle NULL values. A NULL value
139 # The DISTINCT keyword on a SELECT statement should treat NULL values
148 # A UNION to two queries should treat NULL values
157 # The UNIQUE constraint only applies to non-null values
162 insert into t2 values(1,1);
163 insert into t2 values(2,null);
164 insert into t2 values(3,null);
165 insert into t2 values(4,1);
172 insert into t3 values(1,1,1);
173 insert into t3 values(2,null,1);
174 insert into t3 values(3,null,1);
175 insert into t3 values(4,1,1);