List:General Discussion« Previous MessageNext Message »
From:wang shuming Date:March 4 2010 3:22am
Subject:5.1.44 community version select ordno>=' ' error (2)
View as plain text  
Hi,
select * from t1

ordno qty
             1
             3
             5
'aaa'     18
'bbbbb'  20

select * from t1 where ordno='  ' or ordno>'  '
ordno qty
             1
             3
             5
'aaa'     18
'bbbbb'  20

select * from t1 where ordno>='  '
ordno qty
'aaa'     18
'bbbbb'  20

mysql version 5.1.44 still with the bug

Best regards!
Shuming Wang

Thread
5.1.44 community version select ordno>=' ' error (2)wang shuming4 Mar
  • Re: 5.1.44 community version select ordno>=' ' error (2)Dan Nelson4 Mar
Re: 5.1.44 community version select ordno>=' ' error (2)wang shuming4 Mar
  • Re: 5.1.44 community version select ordno>=' ' error (2)Peter Brawley4 Mar