test/tools/csql/exp.test040.ksh

   1 echo binary 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      12FE
  14         11      245AF
  15         12      245AF
  16         13      12FE
  17         -2147483648     DC23
  18         2147483647      323A34
  19
  20 echo select * from t1 where f2 = '12fe';
  21 ---------------------------------------------------------
  22         t1.f1   t1.f2
  23 ---------------------------------------------------------
  24         10      12FE
  25         13      12FE
  26
  27 echo select * from t1 where f2 != '323a34' AND f1 = 13;
  28 ---------------------------------------------------------
  29         t1.f1   t1.f2
  30 ---------------------------------------------------------
  31         13      12FE
  32
  33 echo select * from t1 where f1 = 12 AND f2 >= '245af';
  34 ---------------------------------------------------------
  35         t1.f1   t1.f2
  36 ---------------------------------------------------------
  37         Illegal Operator:Not Supported for Binary
  38 Illegal Operator:Not Supported for Binary
  39 Illegal Operator:Not Supported for Binary
  40 Illegal Operator:Not Supported for Binary
  41 Illegal Operator:Not Supported for Binary
  42 Illegal Operator:Not Supported for Binary
  43
  44 echo select * from t1 where f1 = 12 OR  f2 > 'dc23';
  45 ---------------------------------------------------------
  46         t1.f1   t1.f2
  47 ---------------------------------------------------------
  48         11      245AF
  49         12      245AF
  50         2147483647      323A34
  51
  52 echo select * from t1 where f1 = 12 OR f2 < 'dc23';
  53 ---------------------------------------------------------
  54         t1.f1   t1.f2
  55 ---------------------------------------------------------
  56         10      12FE
  57         12      245AF
  58         13      12FE
  59
  60 echo select * from t1 where f1 = 12 OR f2 <> '245af';
  61 ---------------------------------------------------------
  62         t1.f1   t1.f2
  63 ---------------------------------------------------------
  64         10      12FE
  65         12      245AF
  66         13      12FE
  67         -2147483648     DC23
  68         2147483647      323A34
  69
  70 echo select * from t1 where NOT f2 ='12fe';
  71 ---------------------------------------------------------
  72         t1.f1   t1.f2
  73 ---------------------------------------------------------
  74         11      245AF
  75         12      245AF
  76         -2147483648     DC23
  77         2147483647      323A34
  78
  79 echo select * from t1 where f2 != '12fe';
  80 ---------------------------------------------------------
  81         t1.f1   t1.f2
  82 ---------------------------------------------------------
  83         11      245AF
  84         12      245AF
  85         -2147483648     DC23
  86         2147483647      323A34
  87
  88 echo select * from t1 where NOT  f2 != '12fe';
  89 ---------------------------------------------------------
  90         t1.f1   t1.f2
  91 ---------------------------------------------------------
  92         10      12FE
  93         13      12FE
  94
  95 echo select * from t1 where f1 = f2;
  96 ---------------------------------------------------------
  97         t1.f1   t1.f2
  98 ---------------------------------------------------------
  99
 100 echo select * from t1 where f2 in ('245af','12fe');
 101 ---------------------------------------------------------
 102         t1.f1   t1.f2
 103 ---------------------------------------------------------
 104         10      12FE
 105         11      245AF
 106         12      245AF
 107         13      12FE
 108
 109 echo select * from t1 where f2 between '00000000' and 'ffffffff';
 110 ---------------------------------------------------------
 111         t1.f1   t1.f2
 112 ---------------------------------------------------------
 113         Illegal Operator:Not Supported for Binary
 114 Illegal Operator:Not Supported for Binary
 115 Illegal Operator:Not Supported for Binary
 116 Illegal Operator:Not Supported for Binary
 117 Illegal Operator:Not Supported for Binary
 118 Illegal Operator:Not Supported for Binary
 119
 120 echo select * from t1 where f2 between '122' and '12a2';
 121 ---------------------------------------------------------
 122         t1.f1   t1.f2
 123 ---------------------------------------------------------
 124         Illegal Operator:Not Supported for Binary
 125 Illegal Operator:Not Supported for Binary
 126 Illegal Operator:Not Supported for Binary
 127 Illegal Operator:Not Supported for Binary
 128 Illegal Operator:Not Supported for Binary
 129 Illegal Operator:Not Supported for Binary
 130
 131 echo update t1 set f2 = '435f3' where f1 != 13 and  f2='323a34' ;
 132 Statement Executed: Rows Affected = 1
 133 ---------------------------------------------------------
 134         t1.f1   t1.f2
 135 ---------------------------------------------------------
 136         10      12FE
 137         11      245AF
 138         12      245AF
 139         13      12FE
 140         -2147483648     DC23
 141         2147483647      435F3
 142
 143 echo update t1 set f2 = '23abc' where f2 = '245af';
 144 Statement Executed: Rows Affected = 2
 145 ---------------------------------------------------------
 146         t1.f1   t1.f2
 147 ---------------------------------------------------------
 148         10      12FE
 149         11      23ABC
 150         12      23ABC
 151         13      12FE
 152         -2147483648     DC23
 153         2147483647      435F3
 154
 155 echo delete from t1 where f2 = '12fe';
 156 Statement Executed: Rows Affected = 2
 157 ---------------------------------------------------------
 158         t1.f1   t1.f2
 159 ---------------------------------------------------------
 160         11      23ABC
 161         12      23ABC
 162         -2147483648     DC23
 163         2147483647      435F3
 164
 165 Statement Executed