test/tools/csql/exp.test027.ksh

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