Bug #54823 can not Alter Table:Self-Contained File attached
Submitted: 26 Jun 2010 9:47 Modified: 14 Aug 2010 13:15
Reporter: 文静 刘 Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.24 CE OS:Windows (xp sp3)
Assigned to: Assigned Account CPU Architecture:Any
Tags: can not Alter Table

[26 Jun 2010 9:47] 文静 刘
Description:
the table Self-Contained dump file is attached.
if i erase all the data in this table, i can do the Alter Tabel operation.
but i can not alter the table in UI tools with data in it, the below bar displays :Finished parsing MySQL SQL script. and no dialog displays.

How to repeat:
Import the attached table file to database
refresh all
right click y_dingcang and select Alter Table...

Suggested fix:
do the alter table
[28 Jun 2010 8:41] Mike Lischke
Verified as described. Restore schema from sql script and try to alter the produced table => no effect.
[14 Jul 2010 13:15] Sergei Tkachenko
It looks like comments and/or default values specified in the script do not correspond to the client character set. If you load this script via Workbench you'll need to convert that part of the script into UTF8. If you load it in other tool ensure that encoding of the comments and default values equals to your client character set. The effective client character set can be determined by running the following query: show variables like 'character_set_client'.
Please recheck & update.
[14 Aug 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".