Bug #70225 Mysql Workbench crash when alter table
Submitted: 3 Sep 2013 14:22 Modified: 15 Jan 2014 14:50
Reporter: Eric Cobos Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.0.6.11184 OS:Windows (x64 and x86)
Assigned to: CPU Architecture:Any

[3 Sep 2013 14:22] Eric Cobos 
Description:
The bug doesn't allow you to modify a table with the GUI.
When you right click on a table and select "Alter table..." it crash, it shows an error screen "Error parsing DDL for ..." and just let you two options, see the DDL or Cancel.
It happens with any table on engine InnoDB, the others I haven't tested.
I try it with remote and local conections and it crash both.

How to repeat:
Doing right click on any table and selecting "Alter table..."
[3 Sep 2013 14:37] MySQL Verification Team 
Please provide the create table statement of one table which presents that issue. I can not repeat with my own tables on Windows 7 and Windows 8 both 64-bits. Thanks.
[4 Sep 2013 7:13] Eric Cobos 
That is the DDL of one table that crash (but how I've said all my table crash)

delimiter $$

CREATE TABLE `acces_curs` (
  `ID` decimal(10,0) NOT NULL,
  `SID` text NOT NULL,
  `ID_USUARI` decimal(10,0) NOT NULL,
  `ID_CURS` decimal(10,0) NOT NULL,
  `DATA_HORA_INI` timestamp NOT NULL,
  `DATA_HORA_MOD` timestamp NULL DEFAULT NULL,
  `DATA_HORA_FIN` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ACCES_CURS_PK` (`ID`),
  KEY `ACCES_CURS_CURS_FK1` (`ID_CURS`),
  KEY `ACCES_CURS_USUARI_FK1` (`ID_USUARI`),
  CONSTRAINT `acces_curs_ibfk_1` FOREIGN KEY (`ID_CURS`) REFERENCES `curs` (`ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `acces_curs_ibfk_2` FOREIGN KEY (`ID_USUARI`) REFERENCES `usuari` (`ID`) ON DELETE NO ACTION ON UPDATE CASCADE
) TYPE=InnoDB$$
[4 Sep 2013 14:54] MySQL Verification Team 
Which MySQL Server version are you connecting?. Are you able to provide the my.ini file?. Thanks.
[26 Sep 2013 4:08] Jonathan Peffer 
This affects me on Mac OSX as well.
[11 Oct 2013 12:30] Mike Lischke 
Please provide your server version. Thanks.
[12 Nov 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".
[6 Jan 2014 19:57] Andre Barth 
I'm on Mac OS 10.9 - same problem.

Selecting 'Alter table' or even 'Create Table...' results in a crash.

My server version:
5.6.13 MySQL Community Server (GPL)

Thanks
[8 Jan 2014 1:33] Alfredo Kojima 
Eric, what server version are you using?
[8 Jan 2014 1:37] Alfredo Kojima 
People with similar problems in OSX, please attach the crashlog from ~/Library/Logs/DiagnosticReports
[15 Jan 2014 8:37] Daniele Di Bona 
Same issue on Mac OSX: I was trying to alter table by right-click on a table via GUI.
ita crashes also if I try to run an ALTER TABLE command via script.
[15 Jan 2014 8:37] Daniele Di Bona 
crash details

Attachment: details.txt (text/plain), 71.63 KiB.
[15 Jan 2014 14:50] Alfredo Kojima 
looks like a duplicate of Bug #64741

A workaround is described in that bug.