[hibernate-issues] [JIRA] (HHH-16856) Hibernate incorrectly does regular JOIN instead of LEFT JOIN when moving from Spring Boot 3.1.0 to 3.1.1

Sebastiaan van den Broek ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16856 ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiMmE2MD... ) Re: Hibernate incorrectly does regular JOIN instead of LEFT JOIN when moving from Spring Boot 3.1.0 to 3.1.1 ( https://hibernate.atlassian.net/browse/HHH-16856?atlOrigin=eyJpIjoiMmE2MD... ) The query inSpring Boot 3.1.0/Hibernate 6.2.2 is fine: Hibernate: select a1_0.id,a1_0.created_date,a1_0.db_version,a1_0.expiry_date,a1_0.last_used,a1_0.name,a1_0.project_id,a1_0.public_part,a1_0.role_id,a1_0.secret_key_hash,a1_0.updated_date from api_key a1_0 left join role r1_0 on r1_0.id=a1_0.role_id where a1_0.project_id=? order by r1_0.name offset ? rows fetch first ? rows only ( https://hibernate.atlassian.net/browse/HHH-16856#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16856#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#100227- sha1:3bc807d )