Bug #14382 LEFT JOIN + CONCAT
Submitted: 27 Oct 2005 9:45 Modified: 27 Oct 2005 9:53
Reporter: regairaz Guillaume Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:mysql-4.1.11-2 OS:Linuc FC3
Assigned to: CPU Architecture:Any

[27 Oct 2005 9:45] regairaz Guillaume 
Description:
I try this :
SELECT p.col1, a.col3,a.col4
        FROM   tabl1 p1 LEFT JOIN tabl2 p2 ON p1.colx=p2.colx, tabl3 a 
        WHERE a.coly=p2.coly;
ok, good result. a.col1=something
Then I try this one :
SELECT p.col1, CONCAT(a.col3,' ',a.col4)
        FROM   tabl1 p1 LEFT JOIN tabl2 p2 ON p1.colx=p2.colx, tabl3 a 
        WHERE a.coly=p2.coly;
Result nothing in CONCAT(a.col1,' ',a.col2).

How to repeat:
3 tables to create with 1 join and 1 left join. then try a concat on the 3th table
[27 Oct 2005 9:53] Hartmut Holzgraefe 
> Then I try this one :
> SELECT p.col1, CONCAT(a.col3,' ',a.col4)
...
> Result nothing in CONCAT(a.col1,' ',a.col2).

Looks like just a typo in your query?
[27 Oct 2005 10:14] regairaz Guillaume 
error on type query in bug report ...
Then I try this one :
SELECT p.col1, CONCAT(a.col3,' ',a.col4)
        FROM   tabl1 p1 LEFT JOIN tabl2 p2 ON p1.colx=p2.colx, tabl3 a 
        WHERE a.coly=p2.coly;
Result nothing in CONCAT(a.col4,' ',a.col4)....
[27 Oct 2005 10:14] regairaz Guillaume 
arg, sorry ...
Then I try this one :
SELECT p.col1, CONCAT(a.col3,' ',a.col4)
        FROM   tabl1 p1 LEFT JOIN tabl2 p2 ON p1.colx=p2.colx, tabl3 a 
        WHERE a.coly=p2.coly;
Result nothing in CONCAT(a.col3,' ',a.col4).
I think it's a real bug