[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2952) Support for referencing non-root entities in Criteria SQL expressions

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2952?page=c... ] Ricardo Rufino commented on HHH-2952: ------------------------------------- I have same problem, i need use a sqlProjection for a joined table called Parcela, where the alias is "parcela". I tried to use projList.add(Projections.sqlProjection("sum(parcela.valor) as valor", new String[]{"valor"}, TYPES_DOUBLE), "valor"); and projList.add(Projections.sqlProjection("sum({parcela}.valor) as valor", new String[]{"valor"}, TYPES_DOUBLE), "valor"); but not work, hibernate generate SQL fragment as: ... inner join Parcela parcela4_ <---- ! Adding the 4_ sufix --> on matricula3_.id=parcela4_.Matriculaid ... this patch should be done in hibernate im using: Hibernate 3.6.0 and MySQL -- 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