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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira