test/tools/csql/exp.test039.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 select f1,f2,f3 from t1;
  21 ---------------------------------------------------------
  22         f1      f2      f3
  23 ---------------------------------------------------------
  24         10      india   1234321
  25         20      INDIA   NULL
  26         NULL    orissa  123432
  27         30      NULL    123432
  28
  29 echo select f2,f1,f3 from t1;
  30 ---------------------------------------------------------
  31         f2      f1      f3
  32 ---------------------------------------------------------
  33         india   10      1234321
  34         INDIA   20      NULL
  35         orissa  NULL    123432
  36         NULL    30      123432
  37
  38 echo select f1,f1,f1,f1,f1 from t1;
  39 ---------------------------------------------------------
  40         f1      f1      f1      f1      f1
  41 ---------------------------------------------------------
  42         10      10      10      10      10
  43         20      20      20      20      20
  44         NULL    NULL    NULL    NULL    NULL
  45         30      30      30      30      30
  46
  47 echo select f2,f2,f2,f2,f2 from t1;
  48 ---------------------------------------------------------
  49         f2      f2      f2      f2      f2
  50 ---------------------------------------------------------
  51         india   india   india   india   india
  52         INDIA   INDIA   INDIA   INDIA   INDIA
  53         orissa  orissa  orissa  orissa  orissa
  54         NULL    NULL    NULL    NULL    NULL
  55
  56 echo select f3,f3,f3,f3,f3 from t1;
  57 ---------------------------------------------------------
  58         f3      f3      f3      f3      f3
  59 ---------------------------------------------------------
  60         1234321 1234321 1234321 1234321 1234321
  61         NULL    NULL    NULL    NULL    NULL
  62         123432  123432  123432  123432  123432
  63         123432  123432  123432  123432  123432
  64
  65 echo select f1,f1,f2,f2,f3,f3 from t1;
  66 ---------------------------------------------------------
  67         f1      f1      f2      f2      f3      f3
  68 ---------------------------------------------------------
  69         10      10      india   india   1234321 1234321
  70         20      20      INDIA   INDIA   NULL    NULL
  71         NULL    NULL    orissa  orissa  123432  123432
  72         30      30      NULL    NULL    123432  123432
  73
  74 echo select f1,f2,f1,f3,f3,f2,f1,f3 from t1;
  75 ---------------------------------------------------------
  76         f1      f2      f1      f3      f3      f2      f1      f3
  77 ---------------------------------------------------------
  78         10      india   10      1234321 1234321 india   10      1234321
  79         20      INDIA   20      NULL    NULL    INDIA   20      NULL
  80         NULL    orissa  NULL    123432  123432  orissa  NULL    123432
  81         30      NULL    30      123432  123432  NULL    30      123432
  82
  83 echo drop table t1;
  84 Statement Executed