[JIRA] (HHH-15917) Migration to 6.X. Unrelated Entity Join Exception
by Anders Wallgren (JIRA)
Anders Wallgren ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cb770d... ) *commented* on HHH-15917 ( https://hibernate.atlassian.net/browse/HHH-15917?atlOrigin=eyJpIjoiNzJkNG... )
Re: Migration to 6.X. Unrelated Entity Join Exception ( https://hibernate.atlassian.net/browse/HHH-15917?atlOrigin=eyJpIjoiNzJkNG... )
I believe I have a reproducible test case for this. The test succeeds with Hibernate 5.6.x but fails on Hibernate 6.2.x.
package org.hibernate.orm.test.query.hhh15917;
import java.util.Set;
import org.hibernate.testing.junit4.BaseCoreFunctionalTestCase;
import org.hibernate.testing.orm.junit.JiraKey;
import org.junit.Test;
import jakarta.persistence.ElementCollection;
import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.Id;
import static org.hibernate.testing.transaction.TransactionUtil.doInHibernate;
@JiraKey( "HHH-15917" )
public class HHH15917Test
extends BaseCoreFunctionalTestCase {
@Override
protected Class <?>[] getAnnotatedClasses() {
return new Class <?>[] { ClassA.class, ClassB.class };
}
@Test
public void testNoExceptionThrown() {
doInHibernate( this ::sessionFactory, s -> {
s.createQuery( "SELECT 'foobar' FROM ClassA a JOIN a.names aName JOIN ClassB b ON b.name = aName" , Object [].class)
.getResultList();
});
}
@Entity(name = "ClassA" )
private static class ClassA {
@Id
@GeneratedValue
private Long id;
private String name;
@ElementCollection
private Set< String > names;
}
@Entity(name = "ClassB" )
private static class ClassB {
@Id
@GeneratedValue
private Long id;
private String name;
}
}
The exception throw by 6.2.x is:
java.lang.IllegalArgumentException: org.hibernate.query.sqm.InterpretationException: Error interpreting query [SELECT 'foobar' FROM ClassA a JOIN a.names aName JOIN ClassB b ON b.name = aName]; this may indicate a semantic (user query) problem or a bug in the parser [SELECT 'foobar' FROM ClassA a JOIN a.names aName JOIN ClassB b ON b.name = aName]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:168)
at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:795)
at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:120)
at org.hibernate.orm.test.query.hhh15917.HHH15917Test.lambda$testNoExceptionThrown$1(HHH15917Test.java:29)
at org.hibernate.testing.transaction.TransactionUtil.doInHibernate(TransactionUtil.java:371)
at org.hibernate.orm.test.query.hhh15917.HHH15917Test.testNoExceptionThrown(HHH15917Test.java:28)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
at org.hibernate.testing.junit4.ExtendedFrameworkMethod.invokeExplosively(ExtendedFrameworkMethod.java:45)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299)
at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: org.hibernate.query.sqm.InterpretationException: Error interpreting query [SELECT 'foobar' FROM ClassA a JOIN a.names aName JOIN ClassB b ON b.name = aName]; this may indicate a semantic (user query) problem or a bug in the parser [SELECT 'foobar' FROM ClassA a JOIN a.names aName JOIN ClassB b ON b.name = aName]
at org.hibernate.query.hql.internal.StandardHqlTranslator.translate(StandardHqlTranslator.java:97)
at org.hibernate.internal.AbstractSharedSessionContract.lambda$interpretHql$2(AbstractSharedSessionContract.java:744)
at org.hibernate.query.internal.QueryInterpretationCacheStandardImpl.createHqlInterpretation(QueryInterpretationCacheStandardImpl.java:141)
at org.hibernate.query.internal.QueryInterpretationCacheStandardImpl.resolveHqlInterpretation(QueryInterpretationCacheStandardImpl.java:128)
at org.hibernate.internal.AbstractSharedSessionContract.interpretHql(AbstractSharedSessionContract.java:741)
at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:786)
... 19 more
Caused by: java.lang.IllegalStateException: Basic paths cannot be dereferenced
at org.hibernate.metamodel.model.domain.internal.BasicSqmPathSource.findSubPathSource(BasicSqmPathSource.java:46)
at org.hibernate.metamodel.model.domain.internal.AbstractPluralAttribute.findSubPathSource(AbstractPluralAttribute.java:86)
at org.hibernate.query.hql.internal.SqmPathRegistryImpl.definesAttribute(SqmPathRegistryImpl.java:250)
at org.hibernate.query.hql.internal.SqmPathRegistryImpl.findFromExposing(SqmPathRegistryImpl.java:190)
at org.hibernate.query.hql.internal.QualifiedJoinPathConsumer.resolveBase(QualifiedJoinPathConsumer.java:134)
at org.hibernate.query.hql.internal.QualifiedJoinPathConsumer.consumeIdentifier(QualifiedJoinPathConsumer.java:99)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitSimplePath(SemanticQueryBuilder.java:5197)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitIndexedPathAccessFragment(SemanticQueryBuilder.java:5155)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitGeneralPathFragment(SemanticQueryBuilder.java:5124)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitGeneralPathFragment(SemanticQueryBuilder.java:253)
at org.hibernate.grammars.hql.HqlParser$GeneralPathFragmentContext.accept(HqlParser.java:4513)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitPath(SemanticQueryBuilder.java:5116)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitPath(SemanticQueryBuilder.java:253)
at org.hibernate.grammars.hql.HqlParser$PathContext.accept(HqlParser.java:4311)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.consumeJoin(SemanticQueryBuilder.java:2193)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitEntityWithJoins(SemanticQueryBuilder.java:1887)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitFromClause(SemanticQueryBuilder.java:1865)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitQuery(SemanticQueryBuilder.java:1141)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitQuerySpecExpression(SemanticQueryBuilder.java:937)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitQuerySpecExpression(SemanticQueryBuilder.java:253)
at org.hibernate.grammars.hql.HqlParser$QuerySpecExpressionContext.accept(HqlParser.java:1818)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitSimpleQueryGroup(SemanticQueryBuilder.java:931)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitSimpleQueryGroup(SemanticQueryBuilder.java:253)
at org.hibernate.grammars.hql.HqlParser$SimpleQueryGroupContext.accept(HqlParser.java:1711)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitSelectStatement(SemanticQueryBuilder.java:418)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.visitStatement(SemanticQueryBuilder.java:377)
at org.hibernate.query.hql.internal.SemanticQueryBuilder.buildSemanticModel(SemanticQueryBuilder.java:295)
at org.hibernate.query.hql.internal.StandardHqlTranslator.translate(StandardHqlTranslator.java:81)
... 24 more
( https://hibernate.atlassian.net/browse/HHH-15917#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15917#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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100225- sha1:62413c2 )