test/tools/csql/exp.test041.ksh

   1 echo binary data type testing with primary key;
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement execute failed with error -21
   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      2423FE
  16         -2147483648     DC23
  17         2147483647      323A34
  18
  19 echo select * from t1 where f2 = '12fe';
  20 ---------------------------------------------------------
  21         t1.f1   t1.f2
  22 ---------------------------------------------------------
  23         10      12FE
  24
  25 echo select * from t1 where f2 != '323a34' AND f1 = 13;
  26 ---------------------------------------------------------
  27         t1.f1   t1.f2
  28 ---------------------------------------------------------
  29
  30 echo select * from t1 where f1 = 12 AND f2 >= '245af';
  31 ---------------------------------------------------------
  32         t1.f1   t1.f2
  33 ---------------------------------------------------------
  34         Illegal Operator:Not Supported for Binary
  35 Illegal Operator:Not Supported for Binary
  36 Illegal Operator:Not Supported for Binary
  37 Illegal Operator:Not Supported for Binary
  38 Illegal Operator:Not Supported for Binary
  39
  40 echo select * from t1 where f1 = 12 OR  f2 > 'dc23';
  41 ---------------------------------------------------------
  42         t1.f1   t1.f2
  43 ---------------------------------------------------------
  44         11      245AF
  45         12      2423FE
  46         2147483647      323A34
  47
  48 echo select * from t1 where f1 = 12 OR f2 < 'dc23';
  49 ---------------------------------------------------------
  50         t1.f1   t1.f2
  51 ---------------------------------------------------------
  52         10      12FE
  53         12      2423FE
  54
  55 echo select * from t1 where f1 = 12 OR f2 <> '245af';
  56 ---------------------------------------------------------
  57         t1.f1   t1.f2
  58 ---------------------------------------------------------
  59         10      12FE
  60         12      2423FE
  61         -2147483648     DC23
  62         2147483647      323A34
  63
  64 echo select * from t1 where NOT f2 ='12fe';
  65 ---------------------------------------------------------
  66         t1.f1   t1.f2
  67 ---------------------------------------------------------
  68         11      245AF
  69         12      2423FE
  70         -2147483648     DC23
  71         2147483647      323A34
  72
  73 echo select * from t1 where f2 != '12fe';
  74 ---------------------------------------------------------
  75         t1.f1   t1.f2
  76 ---------------------------------------------------------
  77         11      245AF
  78         12      2423FE
  79         -2147483648     DC23
  80         2147483647      323A34
  81
  82 echo select * from t1 where NOT  f2 != '12fe';
  83 ---------------------------------------------------------
  84         t1.f1   t1.f2
  85 ---------------------------------------------------------
  86         10      12FE
  87
  88 echo select * from t1 where f1 = f2;
  89 ---------------------------------------------------------
  90         t1.f1   t1.f2
  91 ---------------------------------------------------------
  92
  93 echo select * from t1 where f2 in ('245af','12fe');
  94 ---------------------------------------------------------
  95         t1.f1   t1.f2
  96 ---------------------------------------------------------
  97         10      12FE
  98         11      245AF
  99
 100 echo select * from t1 where f2 between '00000000' and 'ffffffff';
 101 ---------------------------------------------------------
 102         t1.f1   t1.f2
 103 ---------------------------------------------------------
 104         Illegal Operator:Not Supported for Binary
 105 Illegal Operator:Not Supported for Binary
 106 Illegal Operator:Not Supported for Binary
 107 Illegal Operator:Not Supported for Binary
 108 Illegal Operator:Not Supported for Binary
 109
 110 echo select * from t1 where f2 between '122' and '12a2';
 111 ---------------------------------------------------------
 112         t1.f1   t1.f2
 113 ---------------------------------------------------------
 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 update t1 set f2 = '435f3' where f1 != 13 and  f2='323a34' ;
 121 Statement prepare failed with error -21
 122 ---------------------------------------------------------
 123         t1.f1   t1.f2
 124 ---------------------------------------------------------
 125         10      12FE
 126         11      245AF
 127         12      2423FE
 128         -2147483648     DC23
 129         2147483647      323A34
 130
 131 echo delete from t1 where f2 = '23abc';
 132 Statement Executed: Rows Affected = 0
 133 ---------------------------------------------------------
 134         t1.f1   t1.f2
 135 ---------------------------------------------------------
 136         10      12FE
 137         11      245AF
 138         12      2423FE
 139         -2147483648     DC23
 140         2147483647      323A34
 141
 142 Statement Executed