Bug #24811 Renamming unicode table fails first attempt

• Submitted: 5 Dec 2006 3:25
• Modified: 5 Dec 2006 22:31
• Reporter: Jared S (Silver Quality Contributor)
• Status: Closed
• Category: MySQL Query Browser
• Severity: S2 (Serious)
• Version: 1.2.6 BETA
• OS: Windows (WinXP)
• Assigned to: Sveta Smirnova
• CPU Architecture: Any
• Tags: rename, table, Unicode

[5 Dec 2006 3:25] Jared S

Description:
Hi.  When I rename a unicoded table to similar name, the query first fails but then successfully executes second time and also creates half finished table.

How to repeat:
1. Create db1
2. Create my.table (id, description)
3. Rename my.table -> my.table2

If you attemp to run after error, it will work, leaving another half finished table.

Suggested fix:
Allow renamming of unicode tables

[5 Dec 2006 3:29] Jared S

Picture of the error

Attachment: error1.GIF (image/gif, text), 9.50 KiB.

[5 Dec 2006 3:34] Jared S

Sometimes wont even let you rename on second attempt.  Might make S2, very annoying little bug.

[5 Dec 2006 18:05] Sveta Smirnova

Thank you for the report.

I can not repeat the problem.

What means "unicoded table"?

[5 Dec 2006 19:57] Jared S

Unicode means table with non alphabetical character e.i.  `.`   `-` 

I can not repeat on my home computer...I will SHOW INNODB STATUS to see if I can't work out this issue.

[5 Dec 2006 20:27] Sveta Smirnova

Please also provide output of SHOW CREATE TABLE `my.table` and version of MySQL server you use on machine where error happens.

[5 Dec 2006 22:31] Jared S

Basically the table name is ilegal...bug closed.

http://dev.mysql.com/doc/refman/5.0/en/legal-names.html