All Versions
Latest Version
Avg Release Cycle
146 days
Latest Release
228 days ago

Changelog History
Page 1

  • v1.4.200

    October 14, 2019

    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
    • 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)
    • 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.

  • v1.4.199

    March 13, 2019

    🛠 Bugfixes

  • v1.4.198

    February 22, 2019


    Experimental implementation of all standard window functions.

    Hypothetical set and inverse distribution functions.

    INTERVAL data type.

    👍 Geomety type and SRID constraints for GEOMETRY data type, M and ZM dimension systems support.

    👍 WITH TIES and PERCENT support in FETCH clause.

    SELECT DISTINCT ON(expression, …).

    👍 java.sql.SQLXML support.

    Standard systax for ARRAY values, some new functions.

    🐎 Performance

    0️⃣ MVStore engine is multi-threaded by default.

    🐎 Performance and atomicity improvements in MVStore engine.

    Large result sets are processed faster with MVStore engine.

    Large OFFSET values are faster in some queries.


    0️⃣ TCP Server and H2 Console do not allow creation of new databases by default.

    🚚 MVCC setting is removed, MVStore uses row-level locks and PageStore uses table-level locks unconditionally.

    MVStore jar incudes TransactionStore too.

    ⬆️ Lucene is upgraded to 5.5.5-7.6.0.

    JTS library is not required any more for GEOMETRY data type.

    💅 h2.oldStyleOuterJoin setting and limited support for archaic (+) outer joins are removed.

    👀 See change log for a complete list of changes.

  • v1.4.197

    March 18, 2018

    🚀 See release notes

  • v1.4.196

    June 10, 2017

    🛠 Bugfixes and some new features

  • v1.4.195

    April 23, 2017

    🛠 Bugfixes and some new features

  • v1.4.194

    March 10, 2017

    🛠 Various bugfixes and new features

  • v1.4.193

    October 31, 2016

    🛠 Many bugfixes, and slightly increased concurrency.

  • v1.4.192

    May 26, 2016

    👌 Improved performance, new experimental data type "timestamp with timezone", improved SQL syntax.

  • v1.4.191

    January 21, 2016

    🛠 Bugfixes and minor new features.