MySQL Bugs: #49354: Double clicking table name no longer pre-fills Query window with EDIT tablename

Bug #49354	Double clicking table name no longer pre-fills Query window with EDIT tablename
Submitted:	2 Dec 2009 15:34	Modified:	29 Jan 2010 10:30
Reporter:	Edward Rudd	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.10	OS:	Any
Assigned to:	Tony Bedford	CPU Architecture:	Any

Description:
From 5.2.8 to 5.2.10 the "double click" action on a table name changed from filling the query window with

EDIT `myTable`

to 

myTable

This is undesirable as in the query browser and every previous release of 5.2.x of workbench double clicking prefilled with query to view/edit the data in the table.  I've never found selecting fields from the table list very efficient to building ad-hoc queries so double clicking to add the table and column names to the query window is very un-useful and actually rather annoying.

How to repeat:
double click on a "table name" in the schemta view on 5.2.8 and d the same in 5.2.10  there is completely different behavior performed (and not documented in the change log)

Suggested fix:
Revert to the old behavior for double click (or at least provide an option)

A better solution for easily building ad-hoc queries would be to add "find-as-you-type"/"Auto-complete" interface to the query editor.  such that you can press CTRL-Space (like most programming IDEs) and it will populate a list of tables or columns based on the context of the query.

I second the request to return to the previous behavior of double clicking a table in the Schemata view.

Now what I did find is that if I double click on the table in the "Overview" tab where the results show it will go into "edit" mode. And it still does this in 5.2.14.

This was indeed changed on purpose. The logic behind this is the following.

* The "Overview" tab should be used for simple double-clicking a table to edit it's data. This is also suggested by the icon view of the schema objects.

* The "Schemata" tree should be used to build SQL Queries. Double-clicking on a Table Name or a Column Name will add this name to the SQL Statements are. This is meant to help when writing more complex SQL queries and not having to type all the table and columns names by hand. 

We are going to expand that in the future to allow for more complex operations. 

Tony, please make this clear in the documentation.

This is already mentioned in a couple of places in the documentation, for example (see note at bottom of page):

"http://dev.mysql.com/doc/workbench/en/wb-sql-editor-statements-panel.html"