Bumps h2 from 1.4.197 to 1.4.200.
Release notes
Sourced from h2's releases.
Version 1.4.200
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.
Version 1.4.199
Bugfixes
Version 1.4.198
Features
... (truncated)
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.
Commits
e1bcf3b
Prepare release98bd1c8
Prepare release755c818
Merge pull request #2168 from katzyn/isolationc7fd87c
Fix titlec08ff8c
Add non-standard SNAPSHOT isolation level to MVStore databases207b62e
Merge pull request #2166 from katzyn/isolationcdbdbd5
Add a warning about incomplete implementation of SERIALIZABLE979b3ef
Don't touch last data modification id in MVTable.lockRow() if rows wasn't mod...73bab76
Improve SELECT FOR UPDATE documentation05992d8
MVTable.lockRow() should update last modification id- Additional commits viewable in compare view
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase
.
Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) - `@dependabot use these labels` will set the current labels as the default for future PRs for this repo and language - `@dependabot use these reviewers` will set the current reviewers as the default for future PRs for this repo and language - `@dependabot use these assignees` will set the current assignees as the default for future PRs for this repo and language - `@dependabot use this milestone` will set the current milestone as the default for future PRs for this repo and language - `@dependabot badge me` will comment on this PR with code to add a "Dependabot enabled" badge to your readme Additionally, you can set the following in your Dependabot [dashboard](https://app.dependabot.com): - Update frequency (including time of day and day of week) - Pull request limits (per update run and/or open at any time) - Out-of-range updates (receive only lockfile updates, if desired) - Security updates (receive only security updates, if desired)