Problem filtering with a "like" expression

[Johan De Taeye]

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,

Johan