1.4.197 and 1.4.198(199) are huge releases with a lot of changes. BTW, don't use 1.4.198, this release has many regressions, it was replaced with 1.4.199.
Some queries may return result in different orders on Java 7 and on later versions. Some queries may change the order of results depending on different unpredictable factors, such as amount of available memory. You need to change your tests to accept results in any order or change your queries by including the ORDER BY clause with all necessary columns. -- 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/1cd98e8a-bc82-4ffe-b66a-2b880fa4b382%40googlegroups.com.