MySQL Bugs: #69504: SQL editor height changes after executing query

Bug #69504	SQL editor height changes after executing query
Submitted:	18 Jun 2013 18:48	Modified:	31 Jul 2013 15:41
Reporter:	Bob Dankert	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.0.2.10924	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	height, sql editor

Description:
The height of the SQL editor text pane changes after executing a query. If you make the pane bigger so you can see the whole query, the height resets after you execute it. This is really annoying if you make small tweaks to the query frequently and want to see the whole query.

How to repeat:
1. Change height of sql query pane
2. Execute query (Ctrl-Enter)
3. watch pane height reset

Suggested fix:
don't change the height on query

Thank you for the bug report.

Posted by developer:
 
The standard behavior of result grid is to display at least 5 rows. If panel is shrinked below that limit, it will be reset. Please confirm if it's the behavior you're mentioning.

I have added a screen shot to show what happens. Yes, the panel gets resized down to 5 rows tall. If you are working on a long query (say 10 or 20 rows), it's annoying that everytime it executes the query the panel resizes to 5 rows tall. It shouldn't resize the panels when a query executes

Visual of what happens to the SQL panel height

Attachment: sql_editor_height.png (image/png, text), 14.96 KiB.

Please send full size screen shots before and after query execution, and to be sure, please confirm if you're talking about result grid or query panel ?

Before query execution

Attachment: before_execution.JPG (image/jpeg, text), 177.01 KiB.

After query execution

Attachment: after_execution.JPG (image/jpeg, text), 173.98 KiB.

I attached before and after screen shots. I am talking about the size of the query panel, the part that contains my SQL query text (located above the results grid).

Also, notice in the two screenshots that there are three different tabs: "Query 1", "user_pwd", "SQL File 1". These tabs act differently, as described here:

"Query 1": This tab was created when I opened the connection - this was the default tab that comes up. This tab DOES keep the same height of the query panel after executing this query.

"user_pwd": This tab was created when I right clicked the table and clicked "Select Rows" from the context menu. This tab does NOT keep the height of the query panel after executing the query, it always resets to 5 rows height.

"SQL File 1": This tab was created by clicking the first button in the toolbar, "Create a new SQL tab for executing queries". This tab also does NOT keep the height of the query panel after executing the query, it always resets to 5 rows height.

Hopefully these additional screenshots and additional info about the different tabs will help resolve the bug.

I'm sorry - my last comment was slightly incorrect. The third tab, "SQL File 1", DOES keep the height of the query panel. The only panel that resizes to the incorrect height is the "user_pwd" tab, created when I right-clicked a table and said "select rows"

Fixed as of MySQL Workbench 6.0.4, and here's the changelog entry:

The height of the SQL editor text pane would revert to the default height
after executing a query. The customized height is now preserved.

Thank you for the bug report.