MySQL Bugs: #23105: Edit button unavailable when issuing an INNER JOIN command

Bug #23105	Edit button unavailable when issuing an INNER JOIN command
Submitted:	9 Oct 2006 13:14	Modified:	26 May 2009 13:14
Reporter:	Cedric Wider	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S4 (Feature request)
Version:	1.1.18	OS:	Linux (Gentoo)
Assigned to:		CPU Architecture:	Any
Tags:	workbench

Description:
When entering a query with a JOIN keyword, the edit button gets disabled and the data cannot be edited anymore.

It would be nice when it would be possible to change some fields, even there is a JOIN command.

How to repeat:
Enter a query containing a INNER JOIN command in the entry field and then click on execute. When the result set is displayed, the edit-button is disabled and rowdata cannot be edited anymore.

Suggested fix:
Since MySQL Query Browser might know which displayed field comes from which table, it could detect changes and map them onto the correct table for the update statement.

see also Bug #9959

Many thanks for writing a feature request. You are right, edit button is disabled for Joins.

Anyway, we are on the way to implement full functionality of Query Browser into Workbench and your feature request could be interesting for Workbench too. So I will set it to verify that we will have it in mind for Workbench.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/