#2746 Query profiler broken

[Anonymous]

Originally created by: sorger.peter (code.google.com)

What exact steps will reproduce the problem?
1. set "Query profile" to checked
2. run any query

What was the expected output?
Detailed Query profile as before (few weeks ago, sorry, don't remember exact version which broke this feature)

What happened instead?
Nothing. Query profile shows 0,000000 s instead of real time. Even the expandable arrow dissapears.
The output log window at bottom shows correct time e.g. /* 0 rows affected, 7 rows found. Duration for 1 query: 0,780 sec. */

Version used?
HeidiSQL revision: 7.0.0.4064
MySQL Server version: 5.1.56
Operating system: Win7 x64

[Anonymous]

Originally posted by: a...@anse.de

Works here as expected. I had checke the "Query profile" checkbox and then ran SELECT * FROM sometable. Timings are perfectly displayed. I guess your server does not support query profiling. Query profiling requires MySQL 5.0.37 or later, and the server must not be configured with --disable-profiling. Please check that.

Status: NeedInfo

[Anonymous]

Originally posted by: sorger.peter (code.google.com)

Sorry, I dealed with it again. It works for simple selects at other database.
The defects shows up on some more complicated selects involving aggragate functions, joins. However I remember clearly to use it on complicated selects too.
I will try to drop and recreate the database and report.

[Anonymous]

Originally posted by: sorger.peter (code.google.com)

It looks as MySQL bug as you can read at http://bugs.mysql.com/bug.php?id=61328
Seems like there's not much we can do about it.