Bug #80330 Deleting more than 6 rows manually
Submitted: 10 Feb 2016 15:02 Modified: 10 Feb 2016 22:51
Reporter: Todd Ferguson Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.6 Build 511 CE OS:MacOS
Assigned to: CPU Architecture:Any
Tags: Delete Rows, manually delete

[10 Feb 2016 15:02] Todd Ferguson
Description:
When i open a table to view the data, and select any more than consecutive rows, then choose to delete them, the statements generated will leave out one of the rows that has been selected, and then include the first row that was not selected to be deleted.

For example if i selected rows with id's 4 through 10, the delete statement will leave out one of those id's selected, but generate a statement to also delete ID = 3 (which was not selected).

How to repeat:
View a table's data in workbench under the SCHEMAS tab by clicking on the table icon with the lightening bolt.  Select more than 6 rows, right click your selection and click delete from the popup menu.  Click the apply button - look at the statements generated, they will leave out one of the selections, but include the first row above your selection (which was not selected).
[10 Feb 2016 15:13] Todd Ferguson
In my description i said:
"When i open a table to view the data, and select any more than consecutive rows..."

It should say:
"When i open a table to view the data, and select any more than SIX consecutive rows..."
[10 Feb 2016 22:51] MySQL Verification Team
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=78560.