Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOGFhMDllOWNj... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16691?atlOrigin=eyJpIjoiOGFhMD... ) HHH-16691 ( https://hibernate.atlassian.net/browse/HHH-16691?atlOrigin=eyJpIjoiOGFhMD... ) Avoid join table joins for SqmPath in some more scenarios ( https://hibernate.atlassian.net/browse/HHH-16691?atlOrigin=eyJpIjoiOGFhMD... ) Issue Type: Bug Affects Versions: 6.2.3 Assignee: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Created: 25/May/2023 01:28 AM Fix Versions: 6.2.4 Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) https://hibernate.atlassian.net/browse/HHH-16189 introduced some very conservative conditions that lead to joining join tables more often then necessary. Essentially, we only need an SqmPath to render the target table column if it also appears in the group by clause. We have code in EntityValuedPathInterpretation that already optimizes like that, so it’s a matter of code de-duplication. ( https://hibernate.atlassian.net/browse/HHH-16691#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16691#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#100225- sha1:0428b75 )