H2 Console: when the settings were not stored yet (for example when running for the first time), the last recently used settings were not stored.

The BOM (the byte-order-mark) character 0xfeff at the beginning of the file is ignored. This is for compatibility with Microsoft Excel.

When opening an existing database, the cache size is set to at most half the amount of memory available for the virtual machine.

The BOM (the byte-order-mark) character 0xfeff at the beginning of the file is ignored. This is for compatibility with Microsoft Excel.

Queries with multiple IN(...) conditions sometimes return the wrong results when there was a multi-column index for the column.

Queries with multiple IN(...) conditions sometimes return the wrong results when there was a multi-column index for the column.

Queries with multiple IN(...) conditions sometimes return the wrong results when there was a multi-column index for the column.

A new class org.h2.tools.TriggerAdapter allows to use the ResultSet interface within trigger implementations.