Jonathan Eden ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmM4Y2QxYjI3... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16474?atlOrigin=eyJpIjoiNmM4Y2... ) HHH-16474 ( https://hibernate.atlassian.net/browse/HHH-16474?atlOrigin=eyJpIjoiNmM4Y2... ) Throw a clearer error for invalid query. ( https://hibernate.atlassian.net/browse/HHH-16474?atlOrigin=eyJpIjoiNmM4Y2... ) Issue Type: Bug Affects Versions: 6.1.7 Assignee: Unassigned Components: hibernate-core Created: 14/Apr/2023 08:12 AM Environment: Spring Boot 3.0.5 (Hibernate 3.1.7) Priority: Minor Reporter: Jonathan Eden ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%... ) The invalid query below throws a NotYetImplementedFor6Exception at runtime where an invalid query like exception may be clearer. 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] (See forum post https://discourse.hibernate.org/t/not-yet-implemented-exception/7508 ) ( https://hibernate.atlassian.net/browse/HHH-16474#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16474#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100221- sha1:8830b7c )