H2 v1.4.198 Release NotesRelease Date: 2019-02-22 // over 3 years ago
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.
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.oldStyleOuterJoinsetting and limited support for archaic (+) outer joins are removed.
👀 See change log for a complete list of changes.