MySQL Bugs: #54753: End key in results grid goes off screen

Bug #54753	End key in results grid goes off screen
Submitted:	23 Jun 2010 21:05	Modified:	6 Jan 2011 11:43
Reporter:	Jesse Castleberry	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.24 RC	OS:	Windows (W7 (x64))
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
If you double-click on a table name in the SQL Editor to veiw it's data, if it has enough columns that some of them are "off screen" to the right, and you press the End-key on your keyboard to go to the last field, it goes to the last field, but it is off the screen so you can no longer see it.  It appears to disappear.  You can use your arrow keys to shift the grid so that the column is visible, but it's annoying to have to do so.

How to repeat:
Run Workbench, bring up SQL Editor, double-click on a table in a database that has a lot of columns.  Click in the data grid, and press the  End key on the keyboard.  The cursor will disappear, but it is on the last column.  If you press your arrow left key, it'll move one field to the left and then shift the grid to show you the column.

Suggested fix:
When the end key is pressed, also shift the entire grid so that the last column is visible.

Thank you for the bug report. Are you able to provide a screen-shot which illustrate that behavior?. Thanks in advance.

Screen Shot of End-Key issue.

Attachment: end-key-issue.jpg (image/jpeg, text), 201.20 KiB.

Not sure what good a screen shot will do, but I've just uploaded one.  I double-clicked on the conferenceschedules table, clicked in the grid and pressed the end-key on my keyboard.  at this point, the cursor is off to the far right, off the screen on the last column and cannot be seen.

For me (on XP SP3) grid also scrolls right to show cursor position.

It also works fine under Linux.

Which exact OS are you using?
Which screen size are you using?

I am using Windows 7 (64-bit), and my screen is currently in 1280x800, but it also happens if I bring up WB and squeeze up the window as tight as  I can.  I don't usually do that, but I did for the screen shot.

I have just confirmed that it works OK in another OS.  I have Windows Server 2008 (32-bit), and it works just fine there, when I press the End Key, it goes to the last column and shifts the grid as it should so I can see. But, when I do the same thing in Windows 7, it does not shift the grid to the last column.

Could you please provide the output of Help->System Info?. Thanks in advance.

MySQL Workbench CE for Windows version 5.2.24

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

Cairo Version: 1.8.8

Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.

OpenGL Driver Version: 2.1.8874

OS: Microsoft Windows 7  (build 7600), 64-bit

CPU: 2x Intel(R) Core(TM)2 Duo CPU     P8700  @ 2.53GHz, 3.9 GiB RAM

Video adapter info:

Adapter type: Mobile Intel(R) 4 Series Express Chipset Family

Chip Type: Mobile Intel(R) 4 Series Express Chipset Family

BIOS String: Intel Video BIOS

Video Memory: 1814544 KB

Could you please try version 5.2.25. Thanks in advance.

No change.  Same problem.

Thank you for the feedback.

Verified as described.

I use following statement to create problem view:

create view v1 as select 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 22, 33, 44, 55, 66, 77 , 88, 99,100, 111, 222, 333, 444, 555, 666, 777, 888, 999, 22, 33, 44;

Then selected with SELECT * FROM v1;

Fixed in repository.

fix confirmed in repository

An entry has been added to the 5.2.31 changelog:

In the SQL Editor, when viewing table data where the number of columns was such that some columns were off screen, if the End key was pressed to go to the last column in the row, the data grid did not scroll accordingly, so the column containing the cursor was not visible without manually scrolling.