Wrong alias used in subquery generated from JPQL

Description

For this JPQL

Hibernate generates this SQL

The table alias for the subquery for all conditions joined by and is wrong, taken not from the subquery but from the main query.

Workaround is to use a different alias for the subquery in JPQL.

Test case:

Attachments

1

Activity

Show:
Fixed

Details

Assignee

Reporter

Worked in

Components

Fix versions

Affects versions

Priority

Created January 9, 2023 at 9:17 AM
Updated February 7, 2023 at 11:20 AM
Resolved February 3, 2023 at 11:03 AM