| 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: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.
Description: ----[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 Schemas + myDatabase + Tables + Columns myColumnname_A myColumnname_B myColumnname_C 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