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:
None 
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
Description:
When creating a Statement Like SELECT a.id FROM a LEFT OUTER JOIN b ON (a.id=b.id) I cannot add more fields from Table b. Neiter to the Result, nor to WHERE Clauses or anything else. Adding fields from Table a works as expected.
When using a (INNER) JOIN, everything works as expected.

How to repeat:
- drop a table => SELECT * FROM a
- drop another table on the "LEFT OUTER JOIN"-Button => SELECT * FROM a LEFT OUTER JOIN b ON a.id=b.id;
- drop a field from table b on the "SELECT"-Button: nothing happens
- drop a field from table b on the "WHERE"-Button: nothing happens
(the same applies to "GROUP", "HAVING" and "ORDER").
- drop a field form table a on any of these Buttons => the query changes accordingly.
[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/