test/sql/Predicate/exp.test003.ksh

   1 echo CREATE TABLE t1 (f1 INT , f2 VARCHAR (12));
   2 Statement Executed
   3 echo INSERT INTO t1 VALUES(1, 'ABCD');
   4 Statement Executed: Rows Affected = 1
   5 echo INSERT INTO t1 VALUES(2, 'NULL');
   6 Statement Executed: Rows Affected = 1
   7 echo INSERT INTO t1 VALUES(3, NULL);
   8 Statement Executed: Rows Affected = 1
   9 echo INSERT INTO t1 VALUES(4, 'ABCEF');
  10 Statement Executed: Rows Affected = 1
  11 echo INSERT INTO t1 (f1) VALUES (5);
  12 Statement Executed: Rows Affected = 1
  13 echo INSERT INTO t1 VALUES(6, 'ABCFF');
  14 Statement Executed: Rows Affected = 1
  15 echo select * from t1;
  16 ---------------------------------------------------------
  17         t1.f1   t1.f2
  18 ---------------------------------------------------------
  19         1       ABCD
  20         2       NULL
  21         3       NULL
  22         4       ABCEF
  23         5       NULL
  24         6       ABCFF
  25
  26 echo select * from t1 where f2 is null;
  27 ---------------------------------------------------------
  28         t1.f1   t1.f2
  29 ---------------------------------------------------------
  30         3       NULL
  31         5       NULL
  32
  33 echo select * from t1 where f2 is not null;
  34 ---------------------------------------------------------
  35         t1.f1   t1.f2
  36 ---------------------------------------------------------
  37         1       ABCD
  38         2       NULL
  39         4       ABCEF
  40         6       ABCFF
  41
  42 Statement Executed