Bug #53666 MySQL Workbench - SQL Editor showing Duration 0.000 sec

• Submitted: 15 May 2010 2:36
• Modified: 16 Jun 2010 14:52
• Reporter: Rafael Polit
• Status: No Feedback
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2.21 OSS RC Revision 5918
• OS: Windows (Vista Ultimate x64)
• CPU Architecture: Any
• Tags: 0.000 sec, duration, editor, workbench

[15 May 2010 2:36] Rafael Polit

Description:
Within the Workbench - SQL Editor: Every single query made returns a Duration / Fetch result of 0.000 sec / 0.000 sec within the Output Tab.  Regardless of the Action, the result never shows a single millisecond of duration.

I frequently use this info to optimize my queries, specially when using views (incidentally, I am not happy with the fact that the Duration / Fetch are not shown within the results pane, but that I have to go to the Output window to fetch them).  I have reproduced the queries within the MySQL Query Browser and times are correctly shown.

How to repeat:
Within the editor, enter a query like: SHOW VARIABLES LIKE '%%';
The output tab always shows 0.000 sec for both duration and fetch.

Suggested fix:
The resulting values should show times other than 0.000 secs for every operation.

[16 May 2010 14:52] Valeriy Kravchuk

In my case

show variables like '%%'

results in 0.047 sec / 0.000 sec

So, looks like it works. Please, check with other queries, like:

select sleep(1) from mysql.user;

[16 Jun 2010 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".