Bug #49300 No ability to delete row in SQL Editor

• Submitted: 1 Dec 2009 21:24
• Modified: 15 Dec 2009 11:08
• Reporter: Todd Farmer (OCA)
• Status: Closed
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 5.2.10 r4680
• OS: Windows (XP)
• Assigned to: Sergei Tkachenko
• CPU Architecture: Any

[1 Dec 2009 21:24] Todd Farmer

Description:
Maybe Windows-specific, since Kolbe says there is a "Delete row" option when he right-clicks on the row in the live editor, but when I do that, all I see is "Set selection to NULL".

How to repeat:
Try to delete a row using live editor on Windows.

Suggested fix:
Enable row deletion.

[7 Dec 2009 16:36] Sergei Tkachenko

In windows version rows deletion is done by selecting rows (click on row headers for this) and pressing `Del`. Also note: table must have PK and be opened using `EDIT` query.

[7 Dec 2009 17:41] Todd Farmer

I think consistent behavior across platforms would be good; I had no idea that using the delete key was the correct mechanism on Windows.

[14 Dec 2009 13:42] Johannes Taxacher

"delete selected rows" menuitem has been added to edit-grid-popup-menu on windows too.
will be included in 5.2.11

[15 Dec 2009 11:08] Tony Bedford

An entry has been added to the 5.2.11 changelog:

In the SQL Editor, when editing live table data, there was no right-click menu item to delete a row.