[hibernate-issues] [Hibernate-JIRA] Created: (EJB-367) Duplicated result in query with Inner join

Duplicated result in query with Inner join ------------------------------------------ Key: EJB-367 URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-367 Project: Hibernate Entity Manager Issue Type: Bug Environment: Hibernate 3.2, PostgreSql Reporter: rodrigo rosa The following query returns m.titulo equals to comunidade.titulo when they are diferent in database. It seems that Hibernate repeat the the value for column with same name. results = newSession.createSQLQuery("select m.id, m.titulo, m.resumo,m.corpo, m.autor_id, comunidade.titulo, count(v.id) as votos from noticia m left join voto v on v.noticia_id=m.id inner join usuario w on w.id=m.autor_id left outer join comunidade on w.comunidade_id=comunidade.id "+filtro+" group by m.id, m.corpo, m.titulo, m.resumo, m.autor_id, comunidade.titulo order by votos desc").list(); -- 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