Not Yet Implemented Exception

Hibernate ORM
1

Morning.

Just getting a runtime NYI exception. Was wondering if this is just the case, if there is an alternative or I need to wait or drop down to Hibernate 5 for a while?

I am only assuming its the on u in (wg.assignedUsers) it isn’t liking.

Using Spring Boot Starter Data (Parent 3.0.5 - Hibernate 6.1.7)

The query is:

            select u 
            from User u
            join WorkGroup wg on u in (wg.assignedUsers)
            where u.status='AVAILABLE'


org.hibernate.NotYetImplementedFor6Exception: org.hibernate.query.sqm.sql.internal.PluralValuedSimplePathInterpretation
	at org.hibernate.query.sqm.sql.internal.PluralValuedSimplePathInterpretation.accept(PluralValuedSimplePathInterpretation.java:73) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.visitInListPredicate(AbstractSqlAstTranslator.java:5247) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.tree.predicate.InListPredicate.accept(InListPredicate.java:66) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.renderTableGroup(AbstractSqlAstTranslator.java:3829) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.renderTableGroupJoin(AbstractSqlAstTranslator.java:4144) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.processTableGroupJoin(AbstractSqlAstTranslator.java:4109) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.ast.spi.AbstractSqlAstTranslator.lambda$processTableGroupJoins$5(AbstractSqlAstTranslator.java:4089) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) ~[na:na]
2

This is an invalid query. Can you please create a JIRA for this? We should throw a better error in this case. The correct query is:

            select u 
            from User u
            join WorkGroup wg on u member of wg.assignedUsers
            where u.status='AVAILABLE'
3

Ah excellent thank you.

I have created the Jira ticket 167.