H2 v1.4.200 Release Notes

Release Date: 2019-10-14 // 1 day ago
  • Some new features:

    • JSON data type; JSON_OBJECT, JSON_ARRAY, JSON_OBJECTAGG, and JSON_ARRAYAGG functions; JSON predicate
    • TIME WITH TIME ZONE data type
    • BITNOT, LSHIFT, and RSHIFT functions
    • Named columns join (JOIN USING)
    • Type predicate (IS OF)
    • 🌲 General logarithm function LOG(base, argument)
    • ✅ UNKNOWN literal and truth value tests
    • UNIQUE predicate
    • CURRENT_SCHEMA and CURRENT_CATALOG functions
    • Data change delta tables (OLD | NEW | FINAL TABLE)
    • CURRENT VALUE FOR sequence
    • EXECUTE IMMEDIATE command and QUOTE_IDENT function
    • Time zone specification (AT TIME ZONE | LOCAL)
    • ALTER TABLE tableName ALTER COLUMN IF EXISTS columnName
    • READ UNCOMMITTED, REPEATABLE READ, and SNAPSHOT isolation levels with MVStore engine

    Incompatible changes:

    • MVCC setting (ignored since 1.4.198) now results in error
    • 🚚 MULTI_THREADED setting is removed, MVStore engine is always multi-threaded, PageStore engine is always single-threaded
    • Statement.getGeneratedKeys() uses a FINAL TABLE semantics
    • Proleptic Gregorian calendar is used as required by the Standard
    • Cast from TIME to TIMESTAMP uses CURRENT_DATE for a date part as required by the Standard

    Other changes:

    • Scalability and stability of MVStore engine are improved
    • 🛠 Assorted bugfixes

    Known issues:

    • ↪ Asterisked projection of NATURAL join and named columns join between three or more tables can still be incorrect, use qualified column names as a workaround
    • SERIALIZABLE isolaton level can be set, but it doesn't ensure equivalence of serial and concurrent execution of transactions

    👀 See change log for the complete list of changes.


Previous changes from v1.4.199

  • 🛠 Bugfixes