1 echo binary data
type testing with primary key
;
2 echo create table t1
(f1 int
, f2 binary
(4) DEFAULT
'abcd12' ,primary key
(f2
));
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 execute failed with error
-21
9 Statement Executed
: Rows Affected
= 1
10 Statement Executed
: Rows Affected
= 1
11 echo select * from t1
;
12 ---------------------------------------------------------
14 ---------------------------------------------------------
22 echo select * from t1 where f2
= '12fe';
23 ---------------------------------------------------------
25 ---------------------------------------------------------
28 echo select * from t1 where f2
!= '323a34' AND f1
= 13;
29 ---------------------------------------------------------
31 ---------------------------------------------------------
33 echo select * from t1 where f1
= 12 AND f2
>= '245af';
34 ---------------------------------------------------------
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
44 echo select * from t1 where f1
= 12 OR f2
> 'dc23';
45 ---------------------------------------------------------
47 ---------------------------------------------------------
53 echo select * from t1 where f1
= 12 OR f2
< 'dc23';
54 ---------------------------------------------------------
56 ---------------------------------------------------------
60 echo select * from t1 where f1
= 12 OR f2
<> '245af';
61 ---------------------------------------------------------
63 ---------------------------------------------------------
70 echo select * from t1 where NOT f2
='12fe';
71 ---------------------------------------------------------
73 ---------------------------------------------------------
80 echo select * from t1 where f2
!= '12fe';
81 ---------------------------------------------------------
83 ---------------------------------------------------------
90 echo select * from t1 where NOT f2
!= '12fe';
91 ---------------------------------------------------------
93 ---------------------------------------------------------
96 echo select * from t1 where f1
= f2
;
97 ---------------------------------------------------------
99 ---------------------------------------------------------
101 echo select * from t1 where f2
in ('245af','12fe');
102 ---------------------------------------------------------
104 ---------------------------------------------------------
108 echo select * from t1 where f2 between
'00000000' and
'ffffffff';
109 ---------------------------------------------------------
111 ---------------------------------------------------------
112 Illegal Operator
:Not Supported
for Binary
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
119 echo select * from t1 where f2 between
'122' and
'12a2';
120 ---------------------------------------------------------
122 ---------------------------------------------------------
123 Illegal Operator
:Not Supported
for Binary
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
130 echo update t1
set f2
= '435f3' where f1
!= 13 and f2
='323a34' ;
131 Statement prepare failed with error
-21
132 ---------------------------------------------------------
134 ---------------------------------------------------------
142 echo delete from t1 where f2
= '12fe';
143 Statement Executed
: Rows Affected
= 1
144 ---------------------------------------------------------
146 ---------------------------------------------------------