MySQL Bugs: #78560: Workbench doesn't delete all selected rows when deleting from result grid

Bug #78560	Workbench doesn't delete all selected rows when deleting from result grid
Submitted:	25 Sep 2015 14:21	Modified:	17 May 2016 23:18
Reporter:	Andrew Jurgenson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.3.4	OS:	MacOS (10.10.5)
Assigned to:		CPU Architecture:	Any

Description:
Query a table and then try and delete some of the rows from the result grid. If you choose 7 or more rows to delete one of the rows in the middle will not be included in the generated script and will not get deleted. 

How to repeat:

CREATE TABLE `new_table` (
  `idnew_table` int(11) NOT NULL AUTO_INCREMENT,
  `data` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idnew_table`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

insert into new_table(data) values ('a'),('b'),('c'),('d'),('e'),('f'),('g'),('h'),('i'),('j'),('k'),('l'),('m'),('n'),('o'),('p'),('q'),('r'),('s'),('t');

SELECT * FROM new_table;

Now select a group of 7 or more rows. Right click, and choose Delete Row(s). One row in the middle will not be deleted. (In my case if I select 7 rows, row 4 will be the one to stay).

Press Apply and you will see that the row is also missing from the sql script.

Selected 8 rows deleted 7

Attachment: bug#78560.png (image/png, text), 234.82 KiB.

Thank you for the bug report. On my side idnew_table = 31 not deleted.

Forgot to mention not repeatable on Windows.

This bug is more serious than indicated here.  When I try to delete many rows, the row just above the first selected row is modified (it takes the values of the row that is not deleted).  However the row that was just above the selection is included in the list of rows deleted.  The result is that unintended rows are removed from the database.  THis is occurring for me on OSX.

http://bugs.mysql.com/bug.php?id=79900 marked as duplicate of this one.

http://bugs.mysql.com/bug.php?id=80330 marked as duplicate of this one.

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.7 release, and here's the changelog entry:

Executing Delete Row(s) after selecting more than six rows from the
results grid would not delete all of the selected rows.

Thank you for the bug report.