Bug #26863 | Cannot add fields to SELECT and WHERE from LEFT OUTER JOIN'ed table | ||
---|---|---|---|
Submitted: | 6 Mar 2007 8:57 | Modified: | 26 Oct 2009 12:41 |
Reporter: | Bruno Baketaric | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench | Severity: | S2 (Serious) |
Version: | 1.2.17 | OS: | Windows (WinXP SP2) |
Assigned to: | CPU Architecture: | Any | |
Tags: | CHECKED |
[6 Mar 2007 8:57]
Bruno Baketaric
[6 Mar 2007 22:48]
MySQL Verification Team
Thank you for the bug report.
[19 Apr 2007 6:28]
Michael Bruce
Tried this on a multiple outer join query and it seems to only affect the last joined table. Also, having two fields from the last joined table in the select list worked around the problem for me.
[15 Oct 2009 8:20]
Susanne Ebrecht
I am sure this is already fixed in Workbench 5.2. Will test it.
[26 Oct 2009 12:41]
Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. The described problem here already works fine with MySQL Workbench 5.2. Please test it. More informations about Workbench you will find here: http://dev.mysql.com/workbench/