Bug #73762 MySQL Workbench result grid refresh odd/incorrect when rows added/deleted

• Submitted: 28 Aug 2014 20:43
• Modified: 31 Oct 2014 1:14
• Reporter: Chris M
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.1.7
• OS: Windows (Windows 7 64-bit)
• CPU Architecture: Any

[28 Aug 2014 20:43] Chris M

Description:
When a row is added or deleted by an external source (ie not by MySQL Workbench), and an existing query result grid display (which should be affected) is refreshed via the refresh icon, the display doesn't update properly.

If a row is added, the refresh is incorrect in one of two ways.  Sometimes you see only the new row, and not the previous results.  Sometimes you see only the old rows, and not the newly-added row.  (Not sure if there's a pattern to it or not.)

If a row is deleted, the refresh isn't wrong exactly, but is odd.  The data in the deleted row is no longer shown, but is instead replaced with a row of null values.  (That is, if your result used to have 2 rows, but should now have 1, on refresh you'll still see 2 rows in the grid, but only the remaining one will have data, the other will just be all nulls.)  Expected result: only 1 row is in the grid, which is what you get if you manually re-run the original query.  (Note that I'm not counting the "edit" row that always appears at the bottom.)

Note that manually re-running the query by going into the SQL editor and using the run query icon always gives the correct result.

Updating an existing row works properly - in this case refresh properly updates the display with the new values.

How to repeat:
Run a query to select a few rows from a table and leave the result grid open.  Add or delete a row via an external source such that the query results should change.  Press the refresh icon in the result grid.  It's given me odd or incorrect results every time I've tried it.

[29 Aug 2014 0:37] MySQL Verification Team

Thank you for the bug report. Repeatable on Windows but not on Mac OSX.

[4 Sep 2014 23:46] Alfredo Kojima

I can repeat that in Windows in WB 6.1, but no longer in 6.2. Please try the latest 6.2

[8 Sep 2014 14:28] Chris M

Appears to be fixed in 6.2.2 rc.  Thanks!

[31 Oct 2014 1:14] Philip Olson

Fixed as of the upcoming MySQL Workbench 6.2.2 release, and here's the changelog entry:

Refreshing the query results grid after an external source modified a
table would sometimes fail to yield the expected results, such as showing
a bogus row containing NULL values.

Thank you for the bug report.

[8 Sep 2015 19:39] Kevin Foley

Still seeing this bug in 6.3