[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4174) native SQL queries in hibernate don't work when using aliases to differentiate columns that have the same name

native SQL queries in hibernate don't work when using aliases to differentiate columns that have the same name -------------------------------------------------------------------------------------------------------------- Key: HHH-4174 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4174 Project: Hibernate Core Issue Type: Bug Components: entity-manager Environment: jboss 4.2.2, mysql 5 Reporter: Alex McCarrier Basically same as HHH-2094, if you do something like this: select oldForm.data as oldData newForm.data as newData from form oldForm, join form newForm on oldForm.replaced_by_id = newForm.id then use entityManager.createNativeQuery(sql).getResultList() it will end up with an error that says column named oldData does not exist. If you take out the aliases, then it will just return the first value for "data" for every column. If you run this through straight JDBC with the alias, it works as expected.