>>>>> "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!
