MySQL Bugs: #35341: Syntax error when trying to remove primary key

Bug #35341	Syntax error when trying to remove primary key
Submitted:	17 Mar 2008 14:53	Modified:	26 May 2009 11:57
Reporter:	Sveta Smirnova	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	MacOS
Assigned to:		CPU Architecture:	Any

Description:
When removing PRIMARY KEY invalid SQL is generated.

Found during verifcation of bug #35303

How to repeat:
1. CREATE TABLE `table_001` (
  `first_column` int(10) unsigned default NULL,
  `second_column` varchar(255) default NULL,
  `third_column` int(10) default NULL,
  `fourth_column` varchar(20) NOT NULL,
  PRIMARY KEY  USING BTREE (`fourth_column`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

2. Open MySQL Adminisrator
3. Select "Catalogs" from the top menu icons.
4. Click on a Schemata on the left-hand side.
5. Double-Click on the table table_001.
6. Click `fourth_column`
7. Try to remove primary key
8. A dialog box will appear with invalid SQL like in bug #35303: "... , ADD PRIMARY KEY ();"

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/