The new statement EXPLAIN ANALYZE executes the statement, and displays the query plan with the actual row scan count for each table.

If baseDir is set, and a database name is given which points to a directory above (eg. "../dbname"), an exception is thrown.

If baseDir is set, and a database name is given which points to a directory above (eg. "../dbname"), an exception is thrown.

The functions isBeforeFirst() and isAfterLast() were not compliant to the JDBC spec. If the ResultSet contains no rows, they must return false. Fixed.

Prepared statements with nested subqueries did not always return the correct result. Example: select ?, ?, (select count(*) from test t, (select id from test where 0=?) t2 where t2.id=t.id) from test

Improved MS SQL Server compatibility: support string concatenation using "+". Thanks to Stepan for the patch!

When using the multi-threaded mode, running ANALYZE concurrently in multiple connections could throw an exception.

Multi-column indexes where the second or later column was descending did not always produce correct results.

--no commit message

When using the small version of H2 ('jarClient'), the first call to Connection.createBlob (or similar) could throw a ClassNotFoundException.