Bug #83230 Wronge rows after delete in result grid
Submitted: 30 Sep 2016 20:42 Modified: 1 Oct 2016 2:09
Reporter: Ahmad Alkhateeb Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S5 (Performance)
Version:6.3.7 OS:Windows (Microsoft Windows 8.1 Enterprise)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[30 Sep 2016 20:42] Ahmad Alkhateeb
Description:
Suppose we have 5 rows then try to delete 2 rows from result grid then click apply and you will see that the refresh result gives you 2 rows which it has to give you a 3 rows, therefore I need to execute a query again to get a correct result;

How to repeat:
Suppose we have 5 rows then try to delete 2 rows from result grid then click apply and you will see that the refresh result gives you 2 rows which it has to give you a 3 rows, therefore I need to execute a query again to get a correct result;
[1 Oct 2016 2:03] MySQL Verification Team
The first select with 5 rows

Attachment: all_rows.png (image/png, text), 125.39 KiB.

[1 Oct 2016 2:04] MySQL Verification Team
2 rows selected for delete

Attachment: selecting_2_rows.png (image/png, text), 122.69 KiB.

[1 Oct 2016 2:05] MySQL Verification Team
option menu to delete selected rows

Attachment: deleting_2_rows.png (image/png, text), 121.16 KiB.

[1 Oct 2016 2:05] MySQL Verification Team
sql script for delete 2 rows before selected

Attachment: delete_sql_script.png (image/png, text), 109.11 KiB.

[1 Oct 2016 2:06] MySQL Verification Team
delete sql script success

Attachment: script_success..png (image/png, text), 99.94 KiB.

[1 Oct 2016 2:07] MySQL Verification Team
3 rows remains so correct result

Attachment: correct_#_of_rows_after_delete.png (image/png, text), 145.12 KiB.

[1 Oct 2016 2:09] MySQL Verification Team
Thank for the bug report. Please see prior attached screenshots.