Bug #76321 Doubleclick to add column name should automatically add commas between columns
Submitted: 14 Mar 2015 11:23 Modified: 2 Feb 2018 11:22
Reporter: Damiön la Bagh Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:6.2.5 OS:Linux (Ubuntu 14.04.2 LTS)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[14 Mar 2015 11:23] Damiön la Bagh
----[For better reports, please attach the log file after submitting. You can find it in /home/kat/.mysql/workbench/log/wb.log]

When quickly adding columns to the editor by double-clicking the column name under Schemas myDatabase Tables Columns myColumnname the columnname is added to the editor with no spaces or commas causing run-on column names that have to be individually corrected. See: how to repeat for the example.

How to repeat:
From the MySQL Workbench SQL editor
+ myDatabase
+  Tables
+   Columns

type SELECT in the editor

Doubleclick on myColumnname_A B and C

after the SELECT statement the result is:

SELECT myColumnname_AmyColumnname_BmyColumnname_C

All jumbled together.

Suggested fix:
The fix is from a user perspective simple. Most likely solved with a few regular expressions.

On the first column entry after the SELECT always add a white-space character " " to the end of double-clicked entered column name.

On the second (and following) column entry(s), prepend a comma white-space ", " before the column-name.

The results will then parse properly and look like

SELECT myColumnname_A , myColumnname_B , myColumnname_C 
                     ^^^              ^^^              ^
                 space,space      space,space          space which allows FROM
[14 Mar 2015 11:26] Damiön la Bagh
mySQL workbench log file as requetsed

Attachment: wb.log (text/x-log), 15.50 KiB.

[14 Mar 2015 11:28] Damiön la Bagh
screenshot example of what happens and what should happen

Attachment: double-click_column_names_jumble.png (image/png, text), 14.11 KiB.

[2 Feb 2018 11:22] MySQL Verification Team
Thank you for the feature request.