Bug #64358 Insertion point keyboard shortcut breaks during selection (word-by-word select)

• Submitted: 16 Feb 2012 21:37
• Modified: 23 Oct 2015 13:51
• Reporter: Mike Reid
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.3.4
• OS: MacOS (10.11.0)
• CPU Architecture: Any
• Tags: editor, highlight word, keyboard, MySQL, regression, SELECT, workbench

[16 Feb 2012 21:37] Mike Reid

Description:
The following keyboard shortcuts work as expected in the SQL Editor:

OPTION + RIGHT ARROW (Move the insertion point to the beginning of the next word)

OPTION + LEFT ARROW (Move the insertion point to the beginning of the previous word) 

However, when holding SHIFT to make a selection of a range words (e.g. OPTION + SHIFT + LEFT ARROW or OPTION + SHIFT + RIGHT ARROW), the insertion point shortcut stops working, and only moves one character at a time.

How to repeat:
1. Open Workbench
2. Connect to database and open SQL Editor
3. Type some SQL:

SELECT NOW() as now, UNIX_TIMESTAMP() as unix_timestamp;

4. Test insertion point keyboard shortcut: OPTION + LEFT / RIGHT ARROW, watching it jump from word to word.

5. Now hold SHIFT while performing the same keyboard shortcut (SHIFT + OPTION + LEFT/RIGHT ARROW) and notice how you cannot quickly select a range of words, rather only one character at a time. 

Suggested fix:
Prevent the SHIFT modifier from breaking the insertion point keyboard shortcut  in the SQL Editor.

[17 Feb 2012 5:06] Valeriy Kravchuk

This is a duplicate of Bug #64217.

[17 May 2012 15:14] Mike Reid

Updated version to most recent 5.2.40 where this issue is still present.

[19 Nov 2013 17:31] Mike Reid

Re-opening this bug, as it seems to have re-appeared in v6.0.8. (Duplicate of original bug #64217)

When holding SHIFT to make a selection of a range of words (e.g. OPTION + SHIFT + LEFT ARROW or OPTION + SHIFT + RIGHT ARROW), the insertion point shortcut stops working, and only moves one character at a time.

[23 Jan 2014 19:21] Mike Reid

Updated version to just released 6.1.1.11562 build 1158 (6.1 Beta 1) where this issue is still present.

[13 Mar 2014 21:34] Philip Olson

Fixed as of the upcoming MySQL Workbench 6.1.3 release, and here's the changelog entry:

On Mac OS X, pressing "Shift" would interfere with the "Option" + "Arrow"
word-by-word selector operation, and would instead change it to a
character-by-character operation.

Thank you for the bug report.

[17 Dec 2014 17:37] Mike Reid

Re-opening. It appears this bug has re-surfaced in v6.2.4

[12 Jan 2015 18:54] Mike Reid

Stefan H., why was this issue closed, exactly? I did not see an accompanying message from you on 1/9/15, but this issue indeed exists.

Has it been verified and/or resolved? Please let us know.

[16 Jan 2015 18:17] Sveta Smirnova

Thank you for the feedback.

Verified as described. Bug was not repeatable in version 6.2.3, but exists in 6.2.4

[4 Mar 2015 16:59] Mike Reid

Updated impacted version #. Bug still present in recent v6.2.5 release.

[5 Mar 2015 15:53] Mike Reid

This bug is also present in the v6.3.1-beta

[16 Mar 2015 16:04] Mike Reid

This bug is also present in the v6.3.2-rc.

[27 Apr 2015 17:54] Mike Reid

Updated submission to indicate issue still present in 6.3.3 GA.

[18 Jun 2015 23:35] Mike Reid

This bug is also present in the v6.3.4 GA

[26 Jul 2015 6:18] Paul Weiss

Does not seem to be cross-platform. This problem does not occur in 6.3.4.0 on Microsoft Windows (7 Home Premium SP 1) 64-bit.

[22 Oct 2015 18:04] Mike Reid

Appears to related to #76526, which was fixed in today's 6.3.5 release.

[23 Oct 2015 7:28] Mike Lischke

Thanks for the note, but both reports are already closed. So, there's no need for further interaction here.

[23 Oct 2015 13:51] Mike Reid

Whoops, thanks for closing! I thought I had changed the status with that update. Confirmed working as expected.