Bug #61202 Bad SQL String if collation changed to default

• Submitted: 17 May 2011 14:05
• Modified: 8 Feb 2012 21:25
• Reporter: Benjamin Udiljak
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.33
• OS: Any
• CPU Architecture: Any

[17 May 2011 14:05] Benjamin Udiljak

Description:
Hi. 

I am in the dialog "Alter table...". 
If I change the collation of a table from any collation (e.g. latin1 - latin1_german1_ci) to the default collation (e.g. latin1 - default collation) then a bad SQL string is produced. It contains a COLLATE option without any value after it (e.g. "ALTER TABLE `table_name` COLLATE =  ;")

Greetings! 
Ben

How to repeat:
Change table collation to latin1 - latin1_german1_ci. 
Change table collation back to latin1 - default collation.

[17 May 2011 14:20] MySQL Verification Team

Thank you for the bug report.

[8 Feb 2012 21:25] Philip Olson

Fixed as of 5.2.38:

If the charset/collation is set to use the default value, then
"DEFAULT" will now be inserted as the
charset/collation name within generated queries.