MySQL Bugs: #70221: Scrolling up after execute

Bug #70221	Scrolling up after execute
Submitted:	3 Sep 2013 8:26	Modified:	8 Nov 2013 9:33
Reporter:	Espen Tønnessen	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.0.6 revision 11184	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
I very often have several queries in one file. I then scroll down and execute a statement pressing Ctrl + Enter. After execution the query window scrolls up to top. I then have to scroll down to where I was.

---------------
MySQL Workbench Community (GPL) for Windows version 6.0.6  revision 11184

Configuration Directory: C:\Users\xx\AppData\Roaming\MySQL\Workbench

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 6.0 CE

Cairo Version: 1.8.8

OS: Microsoft Windows 7  Service Pack 1 (build 7601), 64-bit

CPU: 4x Intel(R) Core(TM) i7 CPU       M 640  @ 2.80GHz, 7.9 GiB RAM

Active video adapter NVIDIA NVS 5100M

Installed video RAM: 1024 MB

Current video mode: 1920 x 1200 x 4294967296 colors

Used bit depth: 32

Driver version: 9.18.13.783

Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um

Current user language: Norsk, bokmål (Norge)

MySQL Workbench Community (GPL) for Windows version 6.0.6  revision 11184

Configuration Directory: C:\Users\espton\AppData\Roaming\MySQL\Workbench

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 6.0 CE

Cairo Version: 1.8.8

OS: Microsoft Windows 7  Service Pack 1 (build 7601), 64-bit

CPU: 4x Intel(R) Core(TM) i7 CPU       M 640  @ 2.80GHz, 7.9 GiB RAM

Active video adapter NVIDIA NVS 5100M

Installed video RAM: 1024 MB

Current video mode: 1920 x 1200 x 4294967296 colors

Used bit depth: 32

Driver version: 9.18.13.783

Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um

Current user language: Norsk, bokmål (Norge)

How to repeat:
Scroll down, execute.

Hello Espen,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

Voting for this. 

Happens because the Result pane disappears while the query is being run, this may cause the bottom of the Edit pane to be pulled down because there are no trailing lines to be shown (scrolled to). When the Result pane is shown, the Editor pane is covered instead of being pushed up.

Here is a more detailed use example:
- Open a new editor.
- Add 40+ empty lines.
- Enter a brief query, execute it. Note the the query is covered by the Result pane.
- In the editor, add more empty lines after the query, so that the query now sits at the top showing line of the Editor.
- Cursor back up, execute the query. Note that the disappearance of the Results pane has pulled the query down. The top line number of the Editor window has been changed.
- Depending on the height of the Results pane, the query line may or may not have been hidden, but the top editor line is not adjusted when the Editor pane is resized by the Results pane.

Either the Editor control must be prevented from changing the top line when expanded (this means showing space with no lines), or the top line must be saved before the first resize and restored after the second one. I believe the first course is the more aesthetic, but it may be difficult to wrangle the fulltext controls of different platforms.

Posted by developer:
 
FIXED.
Verified in:
Windows 7x64
MySQl Server 5.6
WB 6.0.8.11345
Even when the window is re-sized the cursor remains on the line of the executed sentence.

Duplicate of bug #70221

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

Scrolling down an SQL file and executing a statement ("Control" +
"Enter") would scroll the window back to the top. The cursor now remains,
even when the window is resized.

Thank you for the bug report.

Duplicate of #67465