Bug #105625 Double clicking a table or column should create a fullname not abbriviation

• Submitted: 18 Nov 2021 10:51
• Modified: 10 Dec 2021 9:41
• Reporter: John King
• Status: Not a Bug
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 8.0.27
• OS: Any
• CPU Architecture: Any

[18 Nov 2021 10:51] John King

Description:
Double clicking a table or a column in the objects pane copies the column or table name (double clicking the schema name does something different). Instead opening the table *does* include the schema name as well.

Consistency could help here

How to repeat:
1) Open MWB
2) Open a query pane
3) Double click a table name in the objects pane.

The table name is pasted in the editor, regardless what the default schema is.

1) click the list table icon in the objects pane next to a table
a query is pasted in the editor pane with complete schema.table name convention.

Suggested fix:
Always include the complete name when double clicking a table or column name from the objects pane

Alternatively only include the full table name if a table is double clicked from a none default schema.

[10 Dec 2021 9:41] MySQL Verification Team

Hello John King,

Thank you for the bug report.
Imho, this is by design and the feature reporter expecting already exists in the *Table, view, and column* context menus. This can't be expected for a *Double-clicking* feature for a table, view, or column name in the schema explorer inserts the name into the SQL Query area. You can use *Table, view, and column* context menus *Send to SQL Editor* option and then choose *Name (long)* which inserts qualified table name in the form `schema`.`table`.  

Please see for more details 
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html#wb-schema-table-view-c...

Regards,
Ashwini Patil