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

Changelog History
Page 1

  • v1.4.200 Changes

    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 Changes

    March 13, 2019

    ๐Ÿ›  Bugfixes

  • v1.4.198 Changes

    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 Changes

    March 18, 2018

    ๐Ÿš€ See release notes

  • v1.4.196 Changes

    June 10, 2017

    ๐Ÿ›  Bugfixes and some new features

  • v1.4.195 Changes

    April 23, 2017

    ๐Ÿ›  Bugfixes and some new features

  • v1.4.194 Changes

    March 10, 2017

    ๐Ÿ›  Various bugfixes and new features

  • v1.4.193 Changes

    October 31, 2016

    ๐Ÿ›  Many bugfixes, and slightly increased concurrency.

  • v1.4.192 Changes

    May 26, 2016

    ๐Ÿ‘Œ Improved performance, new experimental data type "timestamp with timezone", improved SQL syntax.

  • v1.4.191 Changes

    January 21, 2016

    ๐Ÿ›  Bugfixes and minor new features.