Hi!
>>>>> "eb" == eb <eb@stripped> writes:
>> Description:
eb> When I nest string expressions in the WHERE part of my query, it
eb> has some strange behaviour. For example for expressions like:
eb> concat('@', trim(leading '.' from concat('.', domain)))
eb> where "domain" is a field of a table.
>> How-To-Repeat:
mysql> create table test ( domain char(50) );
mysql> insert into test VALUES ("hello.de" );
mysql> insert into test VALUES ("test.de" );
eb> The first query, works as intended:
<cut>
Didn't you get my answer for this?
Anyway, this is fixed in MySQL 3.23.14; As I will be away for one week in
the USA starting next Thursday, I will not have time to make a new
3.22 release that fixes this before I leave. Any change you can test
if 3.23.14 works better for you?
Regards,
Monty