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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4956?page=c... ] Maillefer Jean-David commented on HHH-4956: ------------------------------------------- The following example is maybe clearer (it uses postgresql's system table to avoid generating a db structure): A simple select using native query which should return the 10 first index names and the related table names: EntityManager em = ...; String query = "select c.relname, c2.relname" + " from pg_class c" + " join pg_index i on c.oid = i.indexrelid" + " join pg_class c2 on i.indrelid = c2.oid" + " where c.relkind = 'i'" + " order by c.relname" + " limit 10"; @SuppressWarnings("unchecked") List<Object[]> indexes = em.createNativeQuery(query).getResultList(); for (Object[] objects : indexes) { String indexName = (String) objects[0]; String relatedTableName = (String) objects[1]; System.out.println(indexName + "\t" + relatedTableName); } System.out.println(); The output is twice the index name on each row. The related table name is overridden by the index name. I think it's due to the use of the same column name. Is hibernate using internally the column names instead of their indexes to fill the resulting Object[] ? Adding an alias to the query is a workaround. -- 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