We recently upgraded to version 1.4.183 of H2.
We were noticing some performance problems in our tests, and discovered that 1.4.183 is a beta release, with the following issue:
- indexes were not used if the table contains columns with a default value generated by a sequence. This includes tables with identity and auto-increment columns. This bug was introduced by supporting "rownum" in views and derived tables.
We should switch and use the most stable release of H2