Evgenij Ryazanov

`ROUND()` in modern versions of H2 (2.0.202 and newer) actually returns value of exactly the same data type as data type of its first argument, if it is a `TINYINT`,...

`REAL`, `DOUBLE PRECISION`, `FLOAT` and `DECFLOAT` may have these special values in H2. `FLOAT` doesn't have an own implementation, it is mapped to `REAL` or `DOUBLE PRECISION` depending on declared...

I think `H2StatementTest` should use standard `GENERATED BY DEFAULT AS IDENTITY` instead of MySQL compatibility `AUTO_INCREMENT`.

H2 is simply released from time to time, there is no schedule. Thomas pushed some release preparation changes about a month ago, but didn't make a release, most likely due...

H2 doesn't need a lot of memory for large persistent databases. But, unfortunately, in recent versions of H2 the `CSVREAD` function needs a lot of memory.

If you use an in-memory database, all data is stored in the memory. 2 GiB is a more or less expected amount of memory for a table from 0.7 GiB...

Why it should be released immediately and how can it be done without `System.gc()`? Java uses a garbage collector. It will collect the garbage at some time in the future...

What do you mean by `memFS:` mode? If you use an in-memory database (your JDBC URL starts with `jdbc:h2:mem:`), all data is stored in the heap of JVM, as any...

`jdbc:h2:memFS:` (I forgot about it) uses the heap too, but the storage format is entirely different.

I guess there is no reliable way. Java compiles methods on the fly when they are used too often, that improves performance of the following executions. Query cache may return...