When using the MULTI_THREADED option, concurrently reading from a database could throw an exception.

    that a full table scan is faster.

    that a full table scan is faster.

    that a full table scan is faster.

New system property h2.lobClientMaxSizeMemory to set the maximum size of a LOB object to keep in memory on the client side when using the server mode.

The jar files are now about 50 KB smaller. In the last few versions they contained superfluous classes.

An ArrayIndexOutOfBoundsException was thrown when querying the table information_schema.function_aliases while there are any user defined aggregate functions.

In theory, when using indexes with large index rows (or when using a very small page size), removing rows could throw an internal exception in some cases.

The default time to compact a database when closing (system property h2.maxCompactTime) is now 0.2 seconds instead of 1 second.

Inserting rows in reverse order could throw an ArrayIndexOutOfBoundsException in some cases (specially rows larger than the page size, which is 2 KB by default). Issue 226.

Password hash: in addition to connecting with the plain text password, H2 now supports connecting with the password hash.