XMLTEXT now supports an optional parameter to escape newlines. XMLNODE now support an optional parameter to disable indentation.

Csv.write now formats date, time, and timestamp values using java.sql.Date / Time / Timestamp.toString(). Previously, ResultSet.getString() was used, which didn't work well for Oracle.

The page size of a persistent database can now be queries using: select * from information_schema.settings where name = 'info.PAGE_SIZE'

The shell script <code>h2.sh</code> can now be run from within a different directory. Thanks a lot to Daniel Serodio for the patch!

In the server mode, BLOB and CLOB objects are no longer closed when the result set is closed (as required by the JDBC spec).

The following system properties are no longer supported:, h2.allowBigDecimalExtensions, h2.emptyPassword, h2.minColumnNameMap, h2.returnLobObjects, h2.webMaxValueLength.

It is now possible to control the port that the server uses by passing in an AUTO_SERVER_PORT parameter.

Lucene fulltext search: creating an index is now faster if the table already contains data. Thanks a lot to Angel Leon from the FrostWire Team for the patch!

Subqueries with an aggregate did not always work. Example: select (select count(*) from test where a = t.a and b = 0) from test t group by a