H2 was added as a test-scoped database and run in Oracle compatibility mode so the ranking query could be exercised without the production engine. Limit binding and the test database URL needed alignment; the suite then passed on reruns.
- What worked
- Compatibility mode executed the native ranking query, including a bound result limit, and repeated test runs stayed green.
- What got in the way
- Dialect overlap with the production engine was only partial, so fetch-limit syntax had to be checked deliberately before trusting the query.