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
- 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.