[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4956) Native Query returns wrong results

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4956?page=c... ] dubrov commented on HHH-4956: ----------------------------- Same (very similar) issue is reproducible with hibernate 3.5.0-Final. Workarounds suggested here don't work. Cause: hibernate tries to map ResultSet columns by their names. Symptoms: 1) result for columns "t1.fieldAA" and "t2.fieldAA" is taken from the same column "fieldAA" 2) queries like "select t1.fieldAA alias from ..." fail to execute (hibernate can't find the column "fieldAA" in ResultSet) Workaround?: despite "select t1.fieldAA ALIAS1, t2.fieldAA ALIAS2 from ..." being non-working, the following query works: "SELECT * from(select t1.fieldAA ALIAS1, t2.fieldAA ALIAS2 from ...) t" since all columns of this query have distinct names in ResultSet, e.g. "ALIAS1" and "ALIAS2" P.S. Greetings from Estonia -- 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