Hibernate 6 NonUnique Discovered SqlAliasException

Hibernate ORM
1

I am not able to figure out where to file a bug for this

Getting the following exception with the scalar fields are added for result mapping.

jakarta.persistence.PersistenceException: Converting org.hibernate.loader.NonUniqueDiscoveredSqlAliasException to JPA PersistenceException : Encountered a duplicated sql alias [LABEL] during auto-discovery of a native-sql query

  public void testCase(SessionFactory sessionFactory) {
    try {
      NativeQuery query = sessionFactory.openSession().createNativeQuery(
          "SELECT FIELD_ID,LABEL,LABEL FROM DUMMY_TABLE ORDER BY LABEL ");
      query.addScalar("FIELD_ID", StandardBasicTypes.INTEGER);
      query.addScalar("LABEL", StandardBasicTypes.STRING);
      query.list();
    } catch (HibernateException e) {
      throw new RuntimeException(e);
    }
  }```
2

Will someone who has access to Hibernate Jira file a bug report with the above please ?

3

This is not a bug, but was done on purpose to help you find possible bugs in your code. If the two selection items with the same alias were using a different expression, which one should Hibernate use for fetching the data from?

select 1 as label, 2 as label

What should Hibernate use in this case when you want to map the alias “label”? You should use unique aliases or remove duplicate select items.