H2 Database Engine 1.4.193 Beta

WARNING: THE MERGE BELOW WILL AFFECT ANY 'TIMESTAMP WITH TIMEZONE' INDEXES. You will need to drop and recreate any such indexes.
PR #364: fix compare TIMESTAMP WITH TIMEZONE
Fix bug in picking the right index for INSERT..ON DUPLICATE KEY UPDATE when there are both UNIQUE and PRIMARY KEY constraints.
Issue #380: Error Analyzer doesn't show source code
Remove the "TIMESTAMP UTC" datatype, an experiment that was never finished.
PR #363: Added support to define last IDENTIFIER on a Trigger.
PR #366: Tests for timestamps
PR #361: Improve TimestampWithTimeZone javadoc
PR #360: Change getters in TimestampWithTimeZone to int
PR #359: Added missing source encoding. Assuming UTF-8.
PR #353: Add support for converting JAVA_OBJECT to UUID
PR #358: Add support for getObject(int|String, Class)
PR #357: Server: use xdg-open to open the WebConsole in the user's preferred browser on Linux
PR #356: Support for BEFORE and AFTER clauses when using multiple columns in ALTER TABLE ADD
PR #351: Respect format codes from Bind message when sending results
ignore summary line when compiling stored procedure
PR #348: pg: send RowDescription in response to Describe (statement variant), patch by kostya-sh
PR #337: Update russian translation, patch by avp1983
PR #329: Update to servlet API version 3.1.0 from 3.0.1, patch by Mat Booth
PR #331: ChangeFileEncryption progress logging ignores -quiet flag, patch by Stefan Bodewig
PR #325: Make Row an interface
PR #323: Regular expression functions (REGEXP_REPLACE, REGEXP_LIKE) enhancement, patch by Akkuzin
Use System.nanoTime for measuring query statistics
Issue #324: Deadlock when sending BLOBs over TCP
Fix for creating and accessing views in MULTITHREADED mode, test-case courtesy of Daniel Rosenbaum
Issue #266: Spatial index not updating, fixed by merging PR #267
PR #302: add support for "with"-subqueries into "join" & "sub-query" statements
Issue #299: Nested derived tables did not always work as expected.
Use interfaces to replace the java version templating, idea from Lukas Eder.
Issue #295: JdbcResultSet.getObject(int, Class) returns null instead of throwing.
Mac OS X: Console tool process did not stop on exit.
MVStoreTool: add "repair" feature.
Garbage collection of unused chunks should be faster still.
MVStore / transaction store: opening a store in read-only mode does no longer loop.
MVStore: disabled the file system cache by default, because it limits concurrency when using larger databases and many threads. To re-enable, use the file name prefix "cache:".
MVStore: add feature to set the cache concurrency.
File system nioMemFS: support concurrent reads.
File systems: the compressed in-memory file systems now compress better.
LIRS cache: improved hit rate because now added entries get hot if they were in the non-resident part of the cache before.

Issue #229: DATEDIFF does not work for 'WEEK'.
Issue #156: Add support for getGeneratedKeys() when executing commands via PreparedStatement#executeBatch.
Issue #195: The new Maven uses a .cmd file instead of a .bat file.
Issue #212: EXPLAIN PLAN for UPDATE statement did not display LIMIT expression.
Support OFFSET without LIMIT in SELECT.
Improve error message for METHOD_NOT_FOUND_1/90087.
CLOB and BLOB objects of removed rows were sometimes kept in the database file.
Server mode: executing "shutdown" left a thread on the server.
The condition "in(select...)" did not work correctly in some cases if the subquery had an "order by".
Issue #184: The Platform-independent zip had Windows line endings in Linux scripts.
Issue #186: The "script" command did not include sequences of temporary tables.
Issue #115: to_char fails with pattern FM0D099