Hello! This issue was fixed in sources of Hibernate ORM two years ago, but version 6.0 is still under development.
You can execute the following code during initialization of your application: org.h2.engine.Mode mode = org.h2.engine.Mode.getInstance("ORACLE"); mode.limit = true; Please note that this workaround uses internals of H2, they may be modified in every version of H2 without a notice. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/686479f6-b153-4f96-b3d4-6e24d676cc2fn%40googlegroups.com.