Nathan Xu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-14152 ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiYzJmYm... ) Re: Query fails after upgrading to 5.4.20.Final ( https://hibernate.atlassian.net/browse/HHH-14152?atlOrigin=eyJpIjoiYzJmYm... ) maybe you can compare the two versions of generated query (one for 5.4.19 and one for 5.4.20) to narrow down the root cause. Another way is to inspect the db content before issuing the query. There must be some difference for if both comparisons find no difference, then in theory we should get the same query results! ( https://hibernate.atlassian.net/browse/HHH-14152#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14152#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#100144- sha1:57e1ab7 )