Bug #52001 Editing with F2 doesn't highlight current cell contents
Submitted: 12 Mar 2010 14:40 Modified: 31 May 2013 7:11
Reporter: Alex Whitman Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.16 OS:Windows (Windows 7, XP)
Assigned to: CPU Architecture:Any

[12 Mar 2010 14:40] Alex Whitman
When editing a table using EDIT <tablename>, pressing F2 in a cell allows editing of the cell but doesn't highlight the current contents of the cell.  This differs to other applications, such as Windows Explorer for example.  In Windows Explorer, pressing F2 while focused on a file allows you to rename the file and the filename is highlighted.

How to repeat:
- Edit a table: EDIT <table>
- Click on a cell to edit.
- Press F2 to allow editing of the cell
- Notice that the cursor is placed at the end of the cell contents, rather than the cell contents being highlighted.

Suggested fix:
When pressing F2 to edit the cell, highlight the cell contents in a similar manner to other applications use of F2.
[13 Mar 2010 1:19] MySQL Verification Team
Thank you for the bug report. I couldn't repeat on Windows Vista Ultimate, could you please provide a screen-shot showing the behavior reported?. Thanks in advance.
[13 Mar 2010 8:16] Alex Whitman
Explorer/Workbench F2 comparison

Attachment: workbench.png (image/png, text), 20.14 KiB.

[13 Mar 2010 8:19] Alex Whitman
Sorry, my description probably wasn't the best.  In the image I have just attached there is a snapshot of Windows Explorer on Windows 7 and Mysql Workbench 5.2.16.

In Explorer I had pressed F2 on the file - notice how the file name is selected so that if I started typing it would overwrite the contents of the filename.

In MySQL Workbench I was editing a table and had pressed F2 on the first row in the 'postcode' column.  Notice how the cursor is at the end of the text so that if I started typing the contents of the cell would be added to rather than overwritten.

I hope this makes a bit more sense.
[25 Mar 2010 8:21] Valeriy Kravchuk
Verified just as described in the last comment.
[31 May 2013 7:11] Philip Olson
This bug will be fixed in the upcoming Workbench 6 release, and here's the changelog entry:

  Clicking on a table cell and pressing "F2" will
  now select (highlight) the cell contents for editing. Before, the
  cursor would be placed at the end of the cell.

Thank you for the bug report.