createSQLQuery(query).list() result screw up when when columns in different tables have same name
-------------------------------------------------------------------------------------------------

          Key: HHH-4999
          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4999
        Project: Hibernate Core
      Issue Type: Bug
      Components: query-sql
  Affects Versions: 3.5.0-CR-2
     Environment: hibernate-core 3.5.0-CR-2
MySQL 5
       Reporter: thogau
     Attachments: joinProblem.zip

The same SQL query doesn't retrieve the same results with hibernate and SQL client :

{{SELECT groupe.name, center.name, roles.displayname, users.username, CASE WHEN center.id = 2 THEN 1 ELSE 0 END AS showlast
FROM groupe, center, users, roles WHERE users.role_id = roles.id AND users.center_id = center.id
AND center.group_id = groupe.id ORDER BY showlast, groupe.sitecoordinateur DESC, groupe.name, center.headcenter DESC, center.name, roles.id}}

When performed with hibernate, *group.name* is retrieved twice (*center.name* is always the same as *group.name*).

Still, it is possible to retrieve the correct value for *center.name* using *CONCAT('', center.name)*

A small eclipse + maven projet with unit test is attached.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

   
_______________________________________________
hibernate-issues mailing list
hibernate-issues@(protected)
https://lists.jboss.org/mailman/listinfo/hibernate-issues