Release notes
*Sourced from [h2's releases](https://github.com/h2database/h2database/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](https://h2database.com/html/changelog.html) for the complete list of changes.
>
> ## Version 1.4.199
> Bugfixes
>
> ## Version 1.4.198
> **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.
>
> ... (truncated)
Commits
- [`e1bcf3b`](https://github.com/h2database/h2database/commit/e1bcf3b6ba8927ff640299c879011f2df0750ef9) Prepare release
- [`98bd1c8`](https://github.com/h2database/h2database/commit/98bd1c87796fd379ec2f3738fd66a7ad5771d429) Prepare release
- [`755c818`](https://github.com/h2database/h2database/commit/755c81891230bfd336ebd295e9eb51d4c30b8dbd) Merge pull request [#2168](https://github-redirect.dependabot.com/h2database/h2database/issues/2168) from katzyn/isolation
- [`c7fd87c`](https://github.com/h2database/h2database/commit/c7fd87cd46bb0c71737deee5b1aba3dbb09761a6) Fix title
- [`c08ff8c`](https://github.com/h2database/h2database/commit/c08ff8ccc99b01bbccd69b09ea73e3587f9075fc) Add non-standard SNAPSHOT isolation level to MVStore databases
- [`207b62e`](https://github.com/h2database/h2database/commit/207b62ef19677f22371c09b871148c81a3129644) Merge pull request [#2166](https://github-redirect.dependabot.com/h2database/h2database/issues/2166) from katzyn/isolation
- [`cdbdbd5`](https://github.com/h2database/h2database/commit/cdbdbd587044bf92eaad75eda2150e4a8ca0054d) Add a warning about incomplete implementation of SERIALIZABLE
- [`979b3ef`](https://github.com/h2database/h2database/commit/979b3ef93a5908a1df6c61aecc845904e0bf6ca9) Don't touch last data modification id in MVTable.lockRow() if rows wasn't mod...
- [`73bab76`](https://github.com/h2database/h2database/commit/73bab76561a41dc8b479e2410204b97f2cea5568) Improve SELECT FOR UPDATE documentation
- [`05992d8`](https://github.com/h2database/h2database/commit/05992d811c99c8d31637d400a2d8c21fe6624359) MVTable.lockRow() should update last modification id
- Additional commits viewable in [compare view](https://github.com/h2database/h2database/compare/version-1.4.177...version-1.4.200)
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)
⚠️ Dependabot is rebasing this PR ⚠️
If you make any changes to it yourself then they will take precedence over the rebase.
Bumps h2 from 1.4.177 to 1.4.200.
Release notes
*Sourced from [h2's releases](https://github.com/h2database/h2database/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](https://h2database.com/html/changelog.html) for the complete list of changes. > > ## Version 1.4.199 > Bugfixes > > ## Version 1.4.198 > **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. > > ... (truncated)Commits
- [`e1bcf3b`](https://github.com/h2database/h2database/commit/e1bcf3b6ba8927ff640299c879011f2df0750ef9) Prepare release - [`98bd1c8`](https://github.com/h2database/h2database/commit/98bd1c87796fd379ec2f3738fd66a7ad5771d429) Prepare release - [`755c818`](https://github.com/h2database/h2database/commit/755c81891230bfd336ebd295e9eb51d4c30b8dbd) Merge pull request [#2168](https://github-redirect.dependabot.com/h2database/h2database/issues/2168) from katzyn/isolation - [`c7fd87c`](https://github.com/h2database/h2database/commit/c7fd87cd46bb0c71737deee5b1aba3dbb09761a6) Fix title - [`c08ff8c`](https://github.com/h2database/h2database/commit/c08ff8ccc99b01bbccd69b09ea73e3587f9075fc) Add non-standard SNAPSHOT isolation level to MVStore databases - [`207b62e`](https://github.com/h2database/h2database/commit/207b62ef19677f22371c09b871148c81a3129644) Merge pull request [#2166](https://github-redirect.dependabot.com/h2database/h2database/issues/2166) from katzyn/isolation - [`cdbdbd5`](https://github.com/h2database/h2database/commit/cdbdbd587044bf92eaad75eda2150e4a8ca0054d) Add a warning about incomplete implementation of SERIALIZABLE - [`979b3ef`](https://github.com/h2database/h2database/commit/979b3ef93a5908a1df6c61aecc845904e0bf6ca9) Don't touch last data modification id in MVTable.lockRow() if rows wasn't mod... - [`73bab76`](https://github.com/h2database/h2database/commit/73bab76561a41dc8b479e2410204b97f2cea5568) Improve SELECT FOR UPDATE documentation - [`05992d8`](https://github.com/h2database/h2database/commit/05992d811c99c8d31637d400a2d8c21fe6624359) MVTable.lockRow() should update last modification id - Additional commits viewable in [compare view](https://github.com/h2database/h2database/compare/version-1.4.177...version-1.4.200)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)