Hi all,

The LIKE predicate doesn't seem to work if you use a constant value
as the comparison value, and a column value as the value to test -
"'[value]' LIKE [column containing expression]".

For example, if I do:
CREATE TABLE foo (addr CHAR(64));
INSERT INTO foo (addr) VALUES('test@...');
SELECT * FROM foo WHERE addr LIKE 'test%';
the select returns the row correctly.

but if I do:
CREATE TABLE foo (addr CHAR(64));
INSERT INTO foo (addr) VALUES('test%');
SELECT * FROM foo WHERE addr LIKE 'test@...';
the select returns no results (the query doesn't fail, it just
doesn't match any rows).

I'm pretty sure it's a bug, and I tried it on mysql and it works fine
there. Any suggestions, before I file a bug report?

Cheers,
Will