After updating the SQL_MODE, it works as I expect.
Thanks for your prompt replies!
From: petya [mailto:petya@stripped]
Sent: Monday, March 21, 2011 12:10 PM
To: Johan De Taeye
Subject: Re: Problem filtering with a "like" expression
|| isn't the concatenation operator by default. If you want it to be set
sql_mode=PIPE_AS_CONCAT. Otherwise, use the CONCAT() function instead of
On 03/21/2011 11:51 AM, Johan De Taeye wrote:
> I ran into this case where a "like" expression is not evaluated
> correctly if the pattern is an expression.
> The example below shows a case where *AAA* is not considered *like 'A'
> Is this a known limitation? Or a bug?
> create table lookup (
> name varchar(60)
> insert into lookup (name) values ('AAA');
> select * from lookup where name like 'A%';
> => 1 record returned. OK
> select * from lookup where name like 'A' || '%';
> => returns nothing. INCORRECT!
> select * from lookup where name like ('A' || '%');
> => same as previous and returns nothing. INCORRECT!
> I reproduced this problem on win32 using versions 5.1 and 5.5.10
> Best regards,