test/tools/csql/exp.test089.ksh

   1 echo "<<<<<<<<<<<<<<<<<<<<<<<< UPDATE t1 SET f1=f1+NULL >>>>>>>>>>>>>>>>>>>>>>";
   2 echo create table t1(f1 int not null,f2 int,f3 int);
   3 Statement Executed
   4 echo insert into t1 values(1,2,3);
   5 Statement Executed: Rows Affected = 1
   6 echo insert into t1 values(2,NULL,4);
   7 Statement Executed: Rows Affected = 1
   8 echo insert into t1 values(3,4,NULL);
   9 Statement Executed: Rows Affected = 1
  10 echo insert into t1 values(10,20,30);
  11 Statement Executed: Rows Affected = 1
  12 echo insert into t1 values(11,NULL,NULL);
  13 Statement Executed: Rows Affected = 1
  14 echo commit;
  15 echo select * from t1;
  16 ---------------------------------------------------------
  17         t1.f1   t1.f2   t1.f3
  18 ---------------------------------------------------------
  19         1       2       3
  20         2       NULL    4
  21         3       4       NULL
  22         10      20      30
  23         11      NULL    NULL
  24
  25 echo update t1 set f1=f1+NULL;
  26 Statement execute failed with error -22
  27 echo commit;
  28 echo select * from t1;
  29 ---------------------------------------------------------
  30         t1.f1   t1.f2   t1.f3
  31 ---------------------------------------------------------
  32         1       2       3
  33         2       NULL    4
  34         3       4       NULL
  35         10      20      30
  36         11      NULL    NULL
  37
  38 echo drop table t1;
  39 Statement Executed