Message Title

org.hibernate.query.sqm.InterpretationException occurs when the query uses embeddedId in the subquery section with a relation between the outer and the inner query

public interface SampleRepo extends BaseJpaRepo<AppUser, UUID> {

public static final String COUNT_QUERY = "SELECT COUNT(*) FROM";

//No EmbeddedId - works fine
@Query(value = COUNT_QUERY + " QueryEntity u1, Visualization u2"//
        + " WHERE u1.id IN (SELECT id from ModelEntity WHERE id=u2.queryId)"//
) //
public Long deleteCount1();

//EmbeddedId Simple Query - works fine
@Query(value = "SELECT COUNT(*) from QueryUser WHERE id.queryId=?1 AND id.userId=?2") //
public Long deleteCount2(Integer id, UUID loggedInUserId);

//EmbeddedId Simple Query in the SubQuery section - works fine
@Query(value = COUNT_QUERY + " QueryEntity u1, Visualization u2"//
        + " WHERE u1.id IN (SELECT id.queryId from QueryUser WHERE id.userId=?1)"//
) //
public Long deleteCount3(UUID loggedInUserId);

//EmbeddedId Query in the SubQuery section with relation between the outer and the inner query - Breaks
@Query(value = COUNT_QUERY + " QueryEntity u1, Visualization u2"//
        + " WHERE u1.id IN (SELECT id.queryId from QueryUser WHERE id.queryId = u2.queryId AND id.userId=?1)"//
) //
public Long deleteCount4(UUID loggedInUserId);}

org.hibernate.query.sqm.InterpretationException: Error interpreting query [SELECT COUNT(*) FROM QueryEntity u1, Visualization u2 WHERE u1.id IN (SELECT id.queryId from QueryUser WHERE id.queryId = u2.queryId AND id.userId=?1)]; this may indicate a semantic (user query) problem or a bug in the parser [SELECT COUNT(*) FROM QueryEntity u1, Visualization u2 WHERE u1.id IN (SELECT id.queryId from QueryUser WHERE id.queryId = u2.queryId AND id.userId=?1)]\n\tat org.hibernate.query.hql.internal.StandardHqlTranslator.translate(StandardHqlTranslator.java:97)\n\tat org.hibernate.internal.AbstractSharedSessionContract.lambda$createQuery$2(AbstractSharedSessionContract.java:747)\n\tat org.hibernate.query.internal.QueryInterpretationCacheStandardImpl.createHqlInterpretation(QueryInterpretationCacheStandardImpl.java:141)\n\tat org.hibernate.query.internal.QueryInterpretationCacheStandardImpl.resolveHqlInterpretation(QueryInterpretationCacheStandardImpl.java:128)\n\tat org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:744)\n\t... 47 common frames omitted\nCaused by: java.lang.IllegalStateException: Multiple from-elements expose unqualified attribute : id\n\tat org.hibernate.query.hql.internal.SqmPathRegistryImpl.findFromExposing(SqmPathRegistryImpl.java:192)\n\tat org.hibernate.query.hql.internal.BasicDotIdentifierConsumer$BaseLocalSequencePart.resolvePathPart(BasicDotIdentifierConsumer.java:146)\n\tat org.hibernate.query.hql.internal.BasicDotIdentifierConsumer.consumeIdentifier

Error when using @Query with EmbeddedId after upgrading to Spring Boot 3.0.4