Bug #69299 Set Default Collation crash the SQL Syntax
Submitted: 21 May 2013 21:26 Modified: 23 Jun 2013 1:37
Reporter: Noel Broda Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.32CE OS:Windows (Win7)
Assigned to: CPU Architecture:Any
Tags: alter, collation, DEFAULT, table

[21 May 2013 21:26] Noel Broda
Description:
ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

SQL Statement:

ALTER TABLE `luntor`.`usuarios_destacados` COLLATE =

ERROR: Error when running failback script. Details follow.

ERROR 1050: Table 'usuarios_destacados' already exists

SQL Statement:

CREATE TABLE `usuarios_destacados` (

  `id_usuario` mediumint(8) unsigned NOT NULL,

  `fecha` date DEFAULT NULL,

  PRIMARY KEY (`id_usuario`),

  KEY `porFecha` (`fecha`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

How to repeat:
1º: create a table with COLLATE=utf8_unicode_ci
2º: alter table, and only set the collation in: "utf8 default collation".
3º: click in "Apply".
4º: Syntax Error.

Suggested fix:
Set a default collation by defautl
[22 May 2013 1:57] MySQL Verification Team
Thank you for the bug report. Could you please try version 5.2.47. Thanks.
[23 Jun 2013 1: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".
[23 Jun 2013 1:36] Noel Broda
Yep!
In last version the error not exist.

Saludos!
[23 Jun 2013 1:37] Noel Broda
Closing the bug!.

Greats changes in las version. good work!.