Andrea Boriero created an issue

Hibernate ORM / HHH-16396 HQL with SubQuery having same alias of root query generates wrong SQL Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Andrea Boriero Created: 29/Mar/2023 07:27 AM Environment: the following HQL query ``` select e.otherEntity.id, (select e.aString from MyEntity e where e.otherEntity.id = :anotherEntityId) from MyEntity e ``` uses the wrong alias for `e.manyToOne`, `m1_0.otherEntity_id` instead of `m1_0.otherEntity_id` ``` select m1_0.otherEntity_id, (select m2_0.aString         from             MyEntity m2_0         where             m1_0.otherEntity_id=?) from         MyEntity m1_0 where         m1_0.id=? ``` Fix Versions: 6.2.0 Priority: Major Reporter: Andrea Boriero Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100219-sha1:6a6077b)