List:Bugs« Previous MessageNext Message »
From:Michael Widenius Date:April 10 2000 1:08pm
Subject:BUG: Probem with nested string functions
View as plain text  
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


Thread
BUG: Probem with nested string functionseb10 Apr
  • BUG: Probem with nested string functionsMichael Widenius10 Apr