| Bug #6335 | Views hang with comparisons of umlauted characters | ||
|---|---|---|---|
| Submitted: | 30 Oct 2004 0:40 | Modified: | 16 Apr 2005 20:20 |
| Reporter: | Peter Gulutzan | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.2-alpha-debug | OS: | Linux (SuSE 8.2) |
| Assigned to: | Sergey Petrunya | CPU Architecture: | Any |
[30 Oct 2004 1:16]
MySQL Verification Team
Verified that the mysql client hangs, but not the server.
[30 Oct 2004 1:26]
MySQL Verification Team
Correction: I was able for to connect with the server after to kill the client: miguel@hegel:~/dbs/5.0$ bin/mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.2-alpha-debug-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. BUT when issuing the mysqladmin shutown..not works..only how PeterG said..kill -9
[16 Apr 2005 20:20]
Sergey Petrunya
Failed to repeat with latest 5.0 tree.

Description: I use latin1, and this character is u with diaeresis: 'ü'. (On the mysql client, "select hex('ü')" returns FC.) My default collation is latin1_swedish_ci. I try to create a view comparing 'ü' with 'ü', and the server hangs. I have to kill -9 to get going again. How to repeat: mysql> create view vj as select 'ü' = 'ü';