1 echo binary data
type testing with primary key
;
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
10 ---------------------------------------------------------
12 ---------------------------------------------------------
19 echo select * from t1 where f2
= '12fe';
20 ---------------------------------------------------------
22 ---------------------------------------------------------
25 echo select * from t1 where f2
!= '323a34' AND f1
= 13;
26 ---------------------------------------------------------
28 ---------------------------------------------------------
30 echo select * from t1 where f1
= 12 AND f2
>= '245af';
31 ---------------------------------------------------------
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
40 echo select * from t1 where f1
= 12 OR f2
> 'dc23';
41 ---------------------------------------------------------
43 ---------------------------------------------------------
48 echo select * from t1 where f1
= 12 OR f2
< 'dc23';
49 ---------------------------------------------------------
51 ---------------------------------------------------------
55 echo select * from t1 where f1
= 12 OR f2
<> '245af';
56 ---------------------------------------------------------
58 ---------------------------------------------------------
64 echo select * from t1 where NOT f2
='12fe';
65 ---------------------------------------------------------
67 ---------------------------------------------------------
73 echo select * from t1 where f2
!= '12fe';
74 ---------------------------------------------------------
76 ---------------------------------------------------------
82 echo select * from t1 where NOT f2
!= '12fe';
83 ---------------------------------------------------------
85 ---------------------------------------------------------
88 echo select * from t1 where f1
= f2
;
89 ---------------------------------------------------------
91 ---------------------------------------------------------
93 echo select * from t1 where f2
in ('245af','12fe');
94 ---------------------------------------------------------
96 ---------------------------------------------------------
100 echo select * from t1 where f2 between
'00000000' and
'ffffffff';
101 ---------------------------------------------------------
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
110 echo select * from t1 where f2 between
'122' and
'12a2';
111 ---------------------------------------------------------
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
120 echo update t1
set f2
= '435f3' where f1
!= 13 and f2
='323a34' ;
121 Statement prepare failed with error
-21
122 ---------------------------------------------------------
124 ---------------------------------------------------------
131 echo delete from t1 where f2
= '23abc';
132 Statement Executed
: Rows Affected
= 0
133 ---------------------------------------------------------
135 ---------------------------------------------------------