« Changelog History


H2 v1.4.198 Release Notes

Release Date: 2019-02-22 // about 5 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.

    Other

    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.