ALTER TABLE ALTER COLUMN no longer copies the data for widening conversions (for example if only the precision was increased) unless necessary.

Multi-threaded kernel: concurrently running an online backup and updating the database resulted in a broken (transactionally incorrect) backup file in some cases.

Multi-threaded kernel: concurrently running an online backup and updating the database resulted in a broken (transactionally incorrect) backup file in some cases.

add column type STRING_IGNORECASE to the kinds of columns we can change the length of without needing to copy the table

The database file locking mechanism "FS" (;FILE_LOCK=FS) did not work on Linux since version 1.3.161.

The script created by SCRIPT DROP did not always work if multiple views existed that depend on each other.

Sequences: the functions NEXTVAL and CURRVAL did not work as expected when using quoted, mixed case sequence names.

MathUtils.getSecureRandom could log a warning to System.err in case the /dev/random is very slow, and the System.getProperties().toString() returned a string larger than 64 KB. 

On out of disk space, the database could get corrupt sometimes, if later write operations succeeded. Now the file is closed on the first unsuccessful write operation, so that later requests fail consistently. DatabaseEventListener.diskSpaceIsLow() is no longer supported because it can't be guaranteed that it always works correctly.

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

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

On out of disk space, the database could get corrupt sometimes, if later write operations succeeded. Now the file is closed on the first unsuccessful write operation, so that later requests fail consistently. DatabaseEventListener.diskSpaceIsLow() is no longer supported because it can't be guaranteed that it always works correctly.

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!