H2 2.2.222 has a known regression: it doesn't perform automatic calculation of statistics.
You need to run the ANALYZE command by yourself. In real-words applications it can be enough to call its once after insertion of enough amount of data, in unit tests you may need to call it in every test that inserts many rows. -- 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/f341fb73-30e5-48ff-9acb-73596f333d07n%40googlegroups.com.