Changelog History
Page 1
-
v1.4.200 Changes
October 14, 2019Some 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
- CURRENT_SCHEMA and CURRENT_CATALOG functions
- 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)
- ALTER TABLE tableName ALTER COLUMN IF EXISTS columnName
- 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, 2019Features
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.
-
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.