H2 v1.4.198 Release Notes

Release Date: 2019-02-22 // over 3 years ago
  • Features

    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.