1 CSQL>create table t1(f1 int,f2 int);
3 CSQL>insert into t1 values(12,23);
4 Statement Executed: Rows Affected = 1
5 CSQL>insert into t1 values(13,24);
6 Statement Executed: Rows Affected = 1
7 CSQL>insert into t1 values(14,25);
8 Statement Executed: Rows Affected = 1
9 CSQL>insert into t1 values(15,26);
10 Statement Executed: Rows Affected = 1
11 CSQL>insert into t1 values(NULL,27);
12 Statement Executed: Rows Affected = 1
13 CSQL>insert into t1 values(NULL,28);
14 Statement Executed: Rows Affected = 1
15 CSQL>insert into t1 values(16,29);
16 Statement Executed: Rows Affected = 1
17 CSQL>insert into t1 values(12,NULL);
18 Statement Executed: Rows Affected = 1
19 CSQL>insert into t1 values(17,NULL);
20 Statement Executed: Rows Affected = 1
21 CSQL>insert into t1 values(NULL,31);
22 Statement Executed: Rows Affected = 1
23 CSQL>insert into t1 values(12,32);
24 Statement Executed: Rows Affected = 1
25 CSQL>select * from t1;
26 ---------------------------------------------------------
28 ---------------------------------------------------------
41 CSQL>select * from t1 where f1 is null;
42 ---------------------------------------------------------
44 ---------------------------------------------------------
49 CSQL>select * from t1 where f1 is not null;
50 ---------------------------------------------------------
52 ---------------------------------------------------------
62 CSQL>select * from t1 where f2 is null;
63 ---------------------------------------------------------
65 ---------------------------------------------------------
69 CSQL>select * from t1 where f2 is not null;
70 ---------------------------------------------------------
72 ---------------------------------------------------------
83 CSQL>select * from t1 where f1 is null or f2 is not null;
84 ---------------------------------------------------------
86 ---------------------------------------------------------
97 CSQL>select * from t1 where f2 is null or f1 is not null;
98 ---------------------------------------------------------
100 ---------------------------------------------------------
113 Statement prepare failed with error -19