Besides many dozens of fixed bugs, performance improvements,
more adherence to a standard SQL syntax and type system, there are
Some new features:
Complete re-work of INFORMATION_SCHEMA to be more in-line with the standard
Support for new types: ARRAY, ROW, JAVA_OBJECT
Numerous bit, string, array and system functions implemented
Standard-based access to generated keys
JDBC 4.2 compliance
Support for JDK 7 is dropped
PageStore is discontinued
MVStore changes:
Descending MVMap and TransactionMap cursor
Disk space reclamation algorithm improvements
Between version 1.4.200 and version 2.0.202 there have been considerable changes, such that a simple update is
not possible.
The official way to upgrade is to do a BACKUP of your existing database USING YOUR CURRENT VERSION OF H2.
Then create a fresh database USING THE NEW VERSION OF H2, then perform a SCRIPT to load your data.
Commits
bb50243 Merge pull request #3210 from andreitokar/master
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
You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/intuit/Tank/network/alerts).
Bumps h2 from 1.4.200 to 2.0.202.
Release notes
Sourced from h2's releases.
Commits
bb50243
Merge pull request #3210 from andreitokar/masterbab777a
Merge remote-tracking branch 'h2database/master'7381627
Merge pull request #3211 from grandinj/Large-JSON-and-GEOMETRY-objects-#30165199387
fix link to changelog3ada1aa
include trivial bits of #30904c56d7c
Merge pull request #3189 from imerik1/master401e84d
fix test0bed95c
Large JSON and GEOMETRY objects #30169ccde29
change link to h2.pdf7309020
change release dateDependabot 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 You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/intuit/Tank/network/alerts).