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:
None 
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 0:40] Peter Gulutzan
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 'ü' = 'ü';
[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.