test/tools/csql/exp.test038.ksh

   1 echo create table t1 (f1 int, f2 char(10), f3 bigint);
   2 Statement Executed
   3 echo insert into t1 values(10,'india',1234321);
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 (f1, f2 ) values(20,'INDIA');
   6 Statement Executed: Rows Affected = 1
   7 echo insert into t1 (f2, f3 ) values('orissa',123432);
   8 Statement Executed: Rows Affected = 1
   9 echo insert into t1 (f1, f3 ) values(30,123432);
  10 Statement Executed: Rows Affected = 1
  11 echo select * from t1;
  12 ---------------------------------------------------------
  13         t1.f1   t1.f2   t1.f3
  14 ---------------------------------------------------------
  15         10      india   1234321
  16         20      INDIA   NULL
  17         NULL    orissa  123432
  18         30      NULL    123432
  19
  20 echo update t1 set f1=10;
  21 Statement Executed: Rows Affected = 4
  22 echo select * from t1;
  23 ---------------------------------------------------------
  24         t1.f1   t1.f2   t1.f3
  25 ---------------------------------------------------------
  26         10      india   1234321
  27         10      INDIA   NULL
  28         10      orissa  123432
  29         10      NULL    123432
  30
  31 echo update t1 set f2='hello';
  32 Statement Executed: Rows Affected = 4
  33 echo select * from t1;
  34 ---------------------------------------------------------
  35         t1.f1   t1.f2   t1.f3
  36 ---------------------------------------------------------
  37         10      hello   1234321
  38         10      hello   NULL
  39         10      hello   123432
  40         10      hello   123432
  41
  42 echo update t1 set f3=10000;
  43 Statement Executed: Rows Affected = 4
  44 echo select * from t1;
  45 ---------------------------------------------------------
  46         t1.f1   t1.f2   t1.f3
  47 ---------------------------------------------------------
  48         10      hello   10000
  49         10      hello   10000
  50         10      hello   10000
  51         10      hello   10000
  52
  53 echo create table t2 (f1 tinyint, f2 float);
  54 Statement Executed
  55 echo insert into t2 values (112, 235.50);
  56 Statement Executed: Rows Affected = 1
  57 echo insert into t2 (f1) values (220);
  58 Statement Executed: Rows Affected = 1
  59 echo insert into t2 (f2) values (100.50);
  60 Statement Executed: Rows Affected = 1
  61 echo select * from t2;
  62 ---------------------------------------------------------
  63         t2.f1   t2.f2
  64 ---------------------------------------------------------
  65         112     235.500000
  66         -36     NULL
  67         NULL    100.500000
  68
  69 echo update t2 set f2=250.50;
  70 Statement Executed: Rows Affected = 3
  71 echo update t2 set f1=125;
  72 Statement Executed: Rows Affected = 3
  73 echo select * from t2;
  74 ---------------------------------------------------------
  75         t2.f1   t2.f2
  76 ---------------------------------------------------------
  77         125     250.500000
  78         125     250.500000
  79         125     250.500000
  80
  81 echo drop table t1;
  82 Statement Executed
  83 echo drop table t2;
  84 Statement Executed