2 messages in com.mysql.lists.bugsBUG: Probem with nested string functions
FromSent OnAttachments
eb...@pemic.de10 Apr 2000 04:55 
Michael Widenius10 Apr 2000 06:07 
Subject:BUG: Probem with nested string functions
From:Michael Widenius (mon@mysql.com)
Date:04/10/2000 06:07:40 AM
List:com.mysql.lists.bugs

Hi!

"eb" == eb <eb@pemic.de> 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