Bug #60535 Update and Delete Commands Show No Results

• Submitted: 18 Mar 2011 17:59
• Modified: 18 Nov 2011 0:03
• Reporter: Kyle Stevens
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.33
• OS: Windows (Windows 7)
• CPU Architecture: Any

[18 Mar 2011 17:59] Kyle Stevens

Description:
When running an UPDATE or DELETE command from the SQL Editor, there is no indication of how many records were affected.  You have to manually go to the output tab and then back to whatever tab you were working in.  

How to repeat:
Run any update or delete command in the SQL editor.  There is no indication how many rows were affected or if the command even ran.

Suggested fix:
Either bring the user to the output window or, since some users might find that undesirable perhaps just give a short message in the status bar such as, "X row(s) affected".

[19 Mar 2011 4:26] Valeriy Kravchuk

On Mac OS X Output tab is opened automatically in this case.

[28 Mar 2011 7:36] Valeriy Kravchuk

Verified on Windows XP. Indeed, output tab is NOT opened and there is no other indication of number of rows processed.

[18 May 2011 20:16] David Marwick

Same here on Win 7 Pro. In prior versions of Workbench it would switch to the Output tab automatically. After the last update, it appears to have stopped doing that if the command does not return a result set. Confusing behavior especially since the app already failed to "catch" a Ctrl+Enter action sometimes, so it's often unclear if a command ran or simply was not received. Thanks

[18 Nov 2011 0:03] Philip Olson

Fixed as of 5.2.36:

+        The SQL editor output tab did not report the number of affected
+        rows.