5.1.42 community version select ordno>=" " error

--00504502ce8aec766c0480c82cbb
Content-Type: text/plain; charset=ISO-8859-1

Hi,

Any table with a ordno char(n) not null field

for example

ordno qty
35
0
1
'abc' 3
'000' 100

select * from table1 where ordno>' ' or ordno=' '
> 3 rows

select * from table1 where ordno>=' '
> 0 rows

best regard!
Shuming Wang

--00504502ce8aec766c0480c82cbb--