List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:December 27 1999 10:10pm
Subject:UPDATE fails to update when there are only changes in case
View as plain text  
>>>>> "louis" == louis  <louis@stripped> writes:

>> Description:
louis> Doing an UPDATE on a TEXT column when the only difference
louis> between the current and the new entry are in the case of
louis> some characters, UPDATE seems to think the entry hasn't
louis> changed and doesn't perform the update.  It only happens
louis> with TEXT columns, not with CHAR(x).

>> How-To-Repeat:
mysql> create table test (a text);
louis> Query OK, 0 rows affected (0.00 sec)

mysql> insert into test values ('where');
louis> Query OK, 1 row affected (0.01 sec)

mysql> update test set a='Where';
louis> Query OK, 0 rows affected (0.00 sec)
louis> Rows matched: 1  Changed: 0  Warnings: 0

mysql> select * from test;
louis> +-------+
louis> | a     |
louis> +-------+
louis> | where |
louis> +-------+
louis> 1 row in set (0.00 sec)

>> Fix:

Hi!

Sorry for the delayed response, I have been very busy developing MySQL 3.23
lately...

Anyway, the above problem will be fixed in MySQL 3.23.8 which will be
released within a couple of days..

Regards
Monty

PS: Starting next year we will create a new mailing list:
    bugs@stripped ;  To this list we will only accept bug reports,
    posted with mysqlbug and with a repeatable example. All MySQL
    developers will subscribe and read this list! This will ensure that
    all posted bugs will get solved quickly!
Thread
UPDATE fails to update when there are only changes in caselouis30 Nov
  • Re: UPDATE fails to update when there are only changes in casesinisa30 Nov
    • Re: UPDATE fails to update when there are only changes in caseChristopher E. Brown1 Dec
      • Re: UPDATE fails to update when there are only changes in casesinisa1 Dec
    • Re: UPDATE fails to update when there are only changes in caseChristopher E. Brown1 Dec
  • UPDATE fails to update when there are only changes in caseMichael Widenius28 Dec