MySQL Bugs: #17745: query disappears

Bug #17745	query disappears
Submitted:	27 Feb 2006 17:20	Modified:	6 Dec 2006 8:25
Reporter:	[ name withheld ] (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S1 (Critical)
Version:	1.1.20	OS:	Windows (WinXP)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Result Set

Description:
Description and steps to repeat:

1. enter a query in MySQL query browser 1.1.20 like "select now()"
2. execute it
3. explain it by choosing the appropriate option from menu
4. click on the first row of the explain which has appeared in the lower part
of the windows
5. your query disappears

How to repeat:
See above

Thanks for your bug report.  I reproduced this under XP/SP2 1.1.20

Just click back in the upper resultset window. Query reappears. This is because you are actually looking at a different query resultset, and the query textbox matches which query result you have clicked.

Same thing can be recreated by:
1 Run any query
2 Right click Resultset results area
3 Select Split Tab Horizontally
4 Query disappears
5 Left click upper results window
6 Query reappears

This appears to be as designed. If at step 4 you then enter a query the results appear in lower area of result page, clicking lower window shows 2nd query, click on upper window it shows 1st query.

Mr. Chernega, you'll have to admit that if this is by design it's a very bad design.

Confirmed on win2k, version 1.20 and 1.2.3 beta

Contrary to Mr. Chernega, clicking back in the upper window is not possible.

Entering a new query in the SQL Query Area, results in output being sent to the Explain window...
Definitely a bug (and has been around some time now....)

Need some help Mike ?

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/