Bug #27953 Bad column name after query with "as ,IN()"
Submitted: 19 Apr 2007 13:21 Modified: 19 May 2007 13:54
Reporter: Alain Siani Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version: OS:Linux ( 2.6.9-11.106)
Assigned to: CPU Architecture:Any

[19 Apr 2007 13:21] Alain Siani 
Description:
mysql  Ver 14.12 Distrib 5.0.24a, for pc-linux-gnu (i686) using readline 5.0
Linux 2.6.9-11.106.unsupported / CentOS release 4.3 (Final)

Problem with "IN ()"

Result column name are bad if i do this query :

SELECT DISTINCT COMPANYADDRESS_VW.Company_id, COMPANYADDRESS_VW.CompanyName, COMPANYADDRESS_VW.Company_id as CompanyId 
FROM COMPANYADDRESS_VW 
LEFT JOIN GROUPS_COMPANY ON ( GROUPS_COMPANY.FK_Company_id=COMPANYADDRESS_VW.Company_id) 
LEFT JOIN IRIGHT_COMPANY ON ( IRIGHT_COMPANY.FK_Company_id=COMPANYADDRESS_VW.Company_id) 
WHERE COMPANYADDRESS_VW.Company_id IN (2) AND (GROUPS_COMPANY.FK_Group_id IN (12,17,16,13,22,14,15) OR IRIGHT_COMPANY.FK_User_id = 2 ) 
 ORDER BY COMPANYADDRESS_VW.Company_id ASC  

CompanyId  CompanyName  CompanyId  
2           Test        2 

And if i do : 

SELECT DISTINCT COMPANYADDRESS_VW.Company_id, COMPANYADDRESS_VW.CompanyName, COMPANYADDRESS_VW.Company_id as CompanyId 
FROM COMPANYADDRESS_VW 
LEFT JOIN GROUPS_COMPANY ON ( GROUPS_COMPANY.FK_Company_id=COMPANYADDRESS_VW.Company_id) 
LEFT JOIN IRIGHT_COMPANY ON ( IRIGHT_COMPANY.FK_Company_id=COMPANYADDRESS_VW.Company_id) 
WHERE COMPANYADDRESS_VW.Company_id IN (2,2) AND (GROUPS_COMPANY.FK_Group_id IN (12,17,16,13,22,14,15) OR IRIGHT_COMPANY.FK_User_id = 2 ) 
 ORDER BY COMPANYADDRESS_VW.Company_id ASC  

Company_id  CompanyName  CompanyId  
2           Test         2  

It is ok ..

How to repeat:
SELECT DISTINCT COMPANYADDRESS_VW.Company_id, COMPANYADDRESS_VW.CompanyName, COMPANYADDRESS_VW.Company_id as CompanyId 
FROM COMPANYADDRESS_VW 
LEFT JOIN GROUPS_COMPANY ON ( GROUPS_COMPANY.FK_Company_id=COMPANYADDRESS_VW.Company_id) 
LEFT JOIN IRIGHT_COMPANY ON ( IRIGHT_COMPANY.FK_Company_id=COMPANYADDRESS_VW.Company_id) 
WHERE COMPANYADDRESS_VW.Company_id IN (2,2) AND (GROUPS_COMPANY.FK_Group_id IN (12,17,16,13,22,14,15) OR IRIGHT_COMPANY.FK_User_id = 2 ) 
 ORDER BY COMPANYADDRESS_VW.Company_id ASC  

Suggested fix:
I don't know, there is a problem with :

COMPANYADDRESS_VW.Company_id IN (2)
[19 Apr 2007 13:54] MySQL Verification Team 
Thank you for the bug report. If you are using a version prior to
5.0r11 please test the latest release otherwise provide the create
table statement and some insert commands if needed. Thanks in advance.
[19 May 2007 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".