test/tools/csql/exp.testnw015.ksh

   1 Network CSql
   2 echo bigint data type testing;
   3 Statement Executed
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed: Rows Affected = 1
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 echo select * from t1;
  11 ---------------------------------------------------------
  12         t1.f1   t1.f2
  13 ---------------------------------------------------------
  14         10      1
  15         11      1
  16         12      1
  17         13      1
  18         -9223372036854775808    1
  19         9223372036854775807     1
  20
  21 echo select * from t1 where f1 = 10;
  22 ---------------------------------------------------------
  23         t1.f1   t1.f2
  24 ---------------------------------------------------------
  25         10      1
  26
  27 echo select * from t1 where f1 != 12 AND f2 <= 13;
  28 ---------------------------------------------------------
  29         t1.f1   t1.f2
  30 ---------------------------------------------------------
  31         10      1
  32         11      1
  33         13      1
  34         -9223372036854775808    1
  35         9223372036854775807     1
  36
  37 echo select * from t1 where f1 = 12 AND f2 >= 22;
  38 ---------------------------------------------------------
  39         t1.f1   t1.f2
  40 ---------------------------------------------------------
  41
  42 echo select * from t1 where f1 = 12 OR  f1 > 13;
  43 ---------------------------------------------------------
  44         t1.f1   t1.f2
  45 ---------------------------------------------------------
  46         12      1
  47         9223372036854775807     1
  48
  49 echo select * from t1 where f1 = 12 OR f2 < 13;
  50 ---------------------------------------------------------
  51         t1.f1   t1.f2
  52 ---------------------------------------------------------
  53         10      1
  54         11      1
  55         12      1
  56         13      1
  57         -9223372036854775808    1
  58         9223372036854775807     1
  59
  60 echo select * from t1 where f1 = 12 OR f2 <> 22;
  61 ---------------------------------------------------------
  62         t1.f1   t1.f2
  63 ---------------------------------------------------------
  64         10      1
  65         11      1
  66         12      1
  67         13      1
  68         -9223372036854775808    1
  69         9223372036854775807     1
  70
  71 echo select * from t1 where NOT f1 = 12;
  72 ---------------------------------------------------------
  73         t1.f1   t1.f2
  74 ---------------------------------------------------------
  75         10      1
  76         11      1
  77         13      1
  78         -9223372036854775808    1
  79         9223372036854775807     1
  80
  81 echo select * from t1 where f1 != 12;
  82 ---------------------------------------------------------
  83         t1.f1   t1.f2
  84 ---------------------------------------------------------
  85         10      1
  86         11      1
  87         13      1
  88         -9223372036854775808    1
  89         9223372036854775807     1
  90
  91 echo select * from t1 where NOT f1 != 12;
  92 ---------------------------------------------------------
  93         t1.f1   t1.f2
  94 ---------------------------------------------------------
  95         12      1
  96
  97 echo select * from t1 where f1 = f2;
  98 ---------------------------------------------------------
  99         t1.f1   t1.f2
 100 ---------------------------------------------------------
 101
 102 echo select * from t1 where f1 between 999999999997 and 999999999999;
 103 ---------------------------------------------------------
 104         t1.f1   t1.f2
 105 ---------------------------------------------------------
 106
 107 echo select * from t1 where f1 between -999999999999 and -999999999997;
 108 ---------------------------------------------------------
 109         t1.f1   t1.f2
 110 ---------------------------------------------------------
 111
 112 echo update t1 set f2 = 2 where f1 != f2;
 113 Statement Executed: Rows Affected = 6
 114 ---------------------------------------------------------
 115         t1.f1   t1.f2
 116 ---------------------------------------------------------
 117         10      2
 118         11      2
 119         12      2
 120         13      2
 121         -9223372036854775808    2
 122         9223372036854775807     2
 123
 124 echo update t1 set f2 = 3 where f1 = 50;
 125 Statement Executed: Rows Affected = 0
 126 ---------------------------------------------------------
 127         t1.f1   t1.f2
 128 ---------------------------------------------------------
 129         10      2
 130         11      2
 131         12      2
 132         13      2
 133         -9223372036854775808    2
 134         9223372036854775807     2
 135
 136 Statement Executed: Rows Affected = 0
 137 ---------------------------------------------------------
 138         t1.f1   t1.f2
 139 ---------------------------------------------------------
 140         10      2
 141         11      2
 142         12      2
 143         13      2
 144         -9223372036854775808    2
 145         9223372036854775807     2
 146
 147 Statement Executed