FirebirdDialect LimitHandler produces wrong query on Firebird 2.5 and older
Description
Since Hibernate 6.0, the LimitHandler returned by FirebirdDialect generates the wrong statement for Firebird 2.5 and older. The problem is it modifies the query to generate skip ? first ? instead of first ? skip ?.
I’m preparing a PR for Hibernate 6.5, and can also create one for main (7.0) if needed.
Since Hibernate 6.0, the LimitHandler returned by FirebirdDialect generates the wrong statement for Firebird 2.5 and older. The problem is it modifies the query to generate
skip ? first ?instead offirst ? skip ?.I’m preparing a PR for Hibernate 6.5, and can also create one for main (7.0) if needed.