The query plan of queries with subqueries that contain nested joins was wrong. This could result in syntax exceptions for correct queries.

A read only database with writeable linked tables could lead to a DATABASE_IS_READ_ONLY (90097) error. This is fixed now.

The condition "in(select ...)" did not work correctly if the subquery could not be converted to a "distinct" query, as in: "select * from dual where x in (select x from dual group by x order by max(x))".

There was a classloader memory leak problem because a class contained a static references to an exception (including stack trace).

Split file system: truncating a file now deletes the parts in reverse order, so that the file list is consistent if the process is interrupted while truncating.

The condition "in(select ...)" did not work correctly if the subquery could not be converted to a "distinct" query, as in: "select * from dual where x in (select x from dual group by x order by max(x))".

The H2 JDBC client can now be used in an unsigned Applet. The problem was that System.getProperty throws a SecurityException, which is now ignored.

The H2 JDBC client can now be used in an unsigned Applet. The problem was that System.getProperty throws a SecurityException, which is now ignored.

The H2 JDBC client can now be used in an unsigned Applet. The problem was that System.getProperty throws a SecurityException, which is now ignored.

In the last release, the error code for "Wrong user name or password" was still 08004 instead of 28000, which resulted in the wrong error message.

In the last release, the error code for "Wrong user name or password" was still 08004 instead of 28000, which resulted in the wrong error message.

In some cases, creating a new table or altering an existing table threw the exception: Unique index or primary key violation: "PRIMARY KEY ON """".PAGE_INDEX".

The Shell tool no longer supports the built-in command "show", because it is a legal SQL statement for H2 and MySQL.

The sorted insert mode did not work for not-persisted tables in a persisted database. It threw a ClassCastException.

The Shell tool no longer supports the built-in command "show", because it is a legal SQL statement for H2 and MySQL.