H2 Console: webAllowOthers and webSSL were swapped if they didn't exist in the properties file. Issue 244.

When the system property h2.lobInDatabase is set, CREATE TABLE ... AS SELECT with a LOB column did not always work.

When the system property h2.lobInDatabase is set, CREATE TABLE ... AS SELECT with a LOB column did not always work.

Improved test case. Now, a script generated with the Recover tool is tested against the original database, too

Improved test case. Now, a script generated with the Recover tool is tested against the original database, too

After a crash, the database file did not always shrink because old transaction log pages were not removed from the file.

CAST: when converting a string to binary, it is hex encoded (every byte two characters); a hex string can be converted to a number by first converting it to binary.

MS SQL Server compatibility: support string literals prefixed with N ("National Language" strings). Issue 240.

CAST('011' AS INT) will no longer use decode the value as an octal number (using Integer.decode) but now use Integer.parseInt. The same logic applied to byte, short, and long.