Matt Henry ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5bff329... ) *commented* on HHH-15955 ( https://hibernate.atlassian.net/browse/HHH-15955?atlOrigin=eyJpIjoiM2VkZW... ) Re: Hibernate 6.1.6 Never Uses LimitHandler w/ DB2 ( https://hibernate.atlassian.net/browse/HHH-15955?atlOrigin=eyJpIjoiM2VkZW... ) If: * Database actual version is 12 AND * Compatibility level is set to V11R1 Then this is equivalent to the lowest level outlined in the function level list which is V12R1M100 (which could also be the value returned from the query that checks the level) For the purpose of whether to use the offset keyword or not, that is enabled in V12R1M500 (mentioned here https://www.ibm.com/docs/en/db2-for-zos/12?topic=12-sql-changes-in-db2 ( https://www.ibm.com/docs/en/db2-for-zos/12?topic=12-sql-changes-in-db2 ) , which might also be helpful in determining when other features are turned on in which function level). ( https://hibernate.atlassian.net/browse/HHH-15955#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15955#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#100213- sha1:b01baad )