Bug #82610 MySQL WorkBench alter table window miss primary key
Submitted: 17 Aug 2016 10:38 Modified: 17 Sep 2016 15:08
Reporter: 杨焱 杨 Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.3.7 OS:MacOS
Assigned to: CPU Architecture:Any

[17 Aug 2016 10:38] 杨焱 杨
Description:
when use MySQL WorkBench alter a table , The alter table window miss primary key ,when i  checking primary key column to click apply button, the pop window show sql are 

ALTER TABLE `wsfwdt`.`member` 
DROP PRIMARY KEY,
ADD PRIMARY KEY (`id`, );

Operation failed: There was an error while applying the SQL script to the database.
Executing:
ALTER TABLE `wsfwdt`.`member` 
DROP PRIMARY KEY,
ADD PRIMARY KEY (`id`, );

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 3
SQL Statement:
ALTER TABLE `wsfwdt`.`member` 
DROP PRIMARY KEY,
ADD PRIMARY KEY (`id`, )

How to repeat:
1: 创建一个表,有一列,叫做id,设置一个主键
2:在表上右键,选择alert table...
3:你会发现主键没有被勾选,并且当你勾选后点击apply生成的sql语法是错误的,根本无法执行

1: to create a table, there is a column, called ID, set a primary key
2: right click on the table, select the table alert...
3: you will find the primary key is not checked, and when you check the SQL generated apply syntax is wrong, simply can not be executed!!!
[17 Aug 2016 10:41] 杨焱 杨
bug

Attachment: 11111.png (image/png, text), 213.42 KiB.

[17 Aug 2016 15:08] MySQL Verification Team
Thank you for the bug report. I couldn't repeat please provide screenshot of the several steps for. Thanks.
[18 Sep 2016 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".