Lines Matching full:values

27     insert into t1 values(1,0,0);
28     insert into t1 values(2,0,1);
29     insert into t1 values(3,1,0);
30     insert into t1 values(4,1,1);
31     insert into t1 values(5,null,0);
32     insert into t1 values(6,null,1);
33     insert into t1 values(7,null,null);
52 # Check to see how the CASE expression handles NULL values.  The
97 # Check to see that NULL values are ignored in aggregate functions.
107 # Check to see how WHERE clauses handle NULL values.  A NULL value
137 # The DISTINCT keyword on a SELECT statement should treat NULL values
146 # A UNION to two queries should treat NULL values
155 # The UNIQUE constraint only applies to non-null values
160     insert into t2 values(1,1);
161     insert into t2 values(2,null);
162     insert into t2 values(3,null);
163     insert into t2 values(4,1);
170     insert into t3 values(1,1,1);
171     insert into t3 values(2,null,1);
172     insert into t3 values(3,null,1);
173     insert into t3 values(4,1,1);
184     INSERT INTO t4 VALUES(1,11);
185     INSERT INTO t4 VALUES(2,NULL);