Release notes
*Sourced from [h2's releases](https://github.com/h2database/h2database/releases).*
> ## 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.
>
> * 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**
>
> * 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**
>
> * 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](http://h2database.com/html/changelog.html) for a complete list of changes.
>
> ## Version 1.4.197
> See release notes
>
> ## Version 1.4.196
> Bugfixes and some new features
> ... (truncated)
Commits
- See full diff in [compare view](https://github.com/h2database/h2database/commits/version-1.4.198)
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
- `@dependabot reopen` will reopen this PR if it is closed
- `@dependabot ignore this [patch|minor|major] version` will close this PR and stop Dependabot creating any more for this minor/major 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)
- Automerge options (never/patch/minor, and dev/runtime dependencies)
- 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)
Finally, you can contact us by mentioning @dependabot.
Bumps h2 from 1.2.138 to 1.4.198.
Release notes
*Sourced from [h2's releases](https://github.com/h2database/h2database/releases).* > ## 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. > > * 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** > > * 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** > > * 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](http://h2database.com/html/changelog.html) for a complete list of changes. > > ## Version 1.4.197 > See release notes > > ## Version 1.4.196 > Bugfixes and some new features > ... (truncated)Commits
- See full diff in [compare view](https://github.com/h2database/h2database/commits/version-1.4.198)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 - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot ignore this [patch|minor|major] version` will close this PR and stop Dependabot creating any more for this minor/major 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) - Automerge options (never/patch/minor, and dev/runtime dependencies) - 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) Finally, you can contact us by mentioning @dependabot.