[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-4999) createSQLQuery(query).list() result screw up when when columns in different tables have same name

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, 3.5.1 Environment: hibernate-core 3.5.0-CR-2 MySQL 5 Reporter: thogau Assignee: Steve Ebersole Fix For: 3.6.3, 4.0.0.Alpha2 Attachments: joinProblem.zip Time Spent: 1h 14m Remaining Estimate: 0h 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.