Bug #9362 Updating a column doesn't work if the UTF8 VARCHAR primary key is >4 chars long

• Submitted: 23 Mar 2005 15:13
• Modified: 23 Mar 2005 15:30
• Reporter: Vesa Halttunen
• Status: Duplicate
• Category: MySQL Server: MyISAM storage engine
• Severity: S1 (Critical)
• Version: 5.0.3-beta-nightly-20050323
• OS: Linux (Fedora Core 2 (Linux 2.6.10))
• CPU Architecture: Any

[23 Mar 2005 15:13] Vesa Halttunen

Description:
The bug #9339 is not fixed in 20050323. The test case in bug #9339 now works but just add one character and it won't. Otherwise the information in that bug is still valid.

How to repeat:
mysql> CREATE DATABASE utf8test CHARACTER SET UTF8;
Query OK, 1 row affected (0.02 sec)
 
mysql> USE utf8test;
Database changed
mysql> CREATE TABLE test (C1 VARCHAR(255) NOT NULL,
    ->                    C2 VARCHAR(512),
    ->                    PRIMARY KEY (C1));
Query OK, 0 rows affected (0.03 sec)
 
mysql> INSERT INTO test VALUES ('testi', 'old');
Query OK, 1 row affected (0.02 sec)
 
mysql> UPDATE test SET C2='new' WHERE C1='testi';
Query OK, 0 rows affected (0.01 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> SELECT * FROM test;
+-------+------+
| C1    | C2   |
+-------+------+
| testi | old  |
+-------+------+
1 row in set (0.01 sec)

[23 Mar 2005 15:19] Vesa Halttunen

Actually the #9339 test case still doesn't work but. Did the fix mentioned in #9339 make it to the http://downloads.mysql.com/snapshots/mysql-5.0/mysql-5.0.3-beta-nightly-20050323.tar.gz tarball? If not, this bug is probably not valid.

[23 Mar 2005 15:30] Heikki Tuuri

Vesa,

Sergei's patch has not yet been pushed to 5.0.

I have a mysqld-5.0 patched with Sergei's patch, and it processes also your new test case ok.

Regards,

Heikki