List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:March 4 2010 6:55am
Subject:Re: 5.1.44 community version select ordno>=' ' error (2)
View as plain text  
In the last episode (Mar 04), wang shuming said:
> select * from t1
> 
> ordno qty
>              1
>              3
>              5
> 'aaa'     18
> 'bbbbb'  20

Are your first three rows really blank, or are there nonprintable characters
in 'ordno' that aren't showing up here?

You need to provide us with the table definition and the insert statements
needed to create the t1 table and its data.  Can you attach the output of
"mysqldump --skip-opt mydb t1" ?

> 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

-- 
	Dan Nelson
	dnelson@stripped
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