Download Latest Version h2-mvstore-2.3.232.jar (359.2 kB)
Email in envelope

Get an email when there's a new version of H2 Database

Home / version-2.2.220
Name Modified Size InfoDownloads / Week
Parent folder
h2-mvstore-2.2.220.jar 2023-07-04 356.7 kB
0
h2-mvstore-2.2.220-sources.jar 2023-07-04 180.2 kB
0
h2-mvstore-2.2.220-javadoc.jar 2023-07-04 268.8 kB
0
bundle-mvstore.jar 2023-07-04 777.8 kB
0
bundle.jar 2023-07-04 7.7 MB
0
h2-2.2.220.jar 2023-07-04 2.6 MB
1 1 weekly downloads
h2-2.2.220-sources.jar 2023-07-04 1.7 MB
0
h2-2.2.220-javadoc.jar 2023-07-04 3.7 MB
0
h2-setup-2023-07-04.exe 2023-07-04 6.8 MB
0
h2-2023-07-04.zip 2023-07-04 9.9 MB
0
h2.pdf 2023-07-04 2.1 MB
0
README.md 2023-07-04 10.4 kB
0
Version 2.2.220.tar.gz 2023-07-04 3.8 MB
0
Version 2.2.220.zip 2023-07-04 5.0 MB
0
Totals: 14 Items   45.0 MB 1

Changes since 2.1.214 release:

  • PR [#3834]: Increase database format version
  • PR [#3833]: Disallow plain webAdminPassword values to force usage of hashes
  • PR [#3831]: Add Oracle-style NOWAIT, WAIT n, and SKIP LOCKED to FOR UPDATE clause
  • PR [#3830]: Fix time zone of time/timestamp with time zone AT LOCAL
  • PR [#3822] / Issue [#2671]: Add quantified comparison predicates with array
  • PR [#3820]: Add partial implementation of JSON simplified accessor
  • PR [#3818]: Add support of underscores in numeric literals
  • PR [#3817]: Add ANY_VALUE() aggregate function
  • PR [#3814]: Fix regression in comparisons with infinities and NaNs
  • Issue [#3040]: System objectIds are recycled twice when CTE queries are executed.
  • PR [#3812]: UNIQUE null treatment
  • PR [#3811]: BTRIM function, octal and binary literals and other changes
  • Issue [#352]: In comparison text values are converted to INT even when they should be converted to BIGINT
  • PR [#3797]: MSSQL mode: Discard table hints on plain UPDATE statements
  • PR [#3791]: Formatted cast of datetimes to/from character strings
  • Issue [#3785]: CSVRead: Fails to translate empty Numbers, when cells are quoted
  • Issue [#3762]: Comparison predicates with row values don't create index conditions
  • PR [#3761]: LAST_DAY function and other changes
  • Issue [#3705]: Oracle DATE type: milliseconds (second fractions) rounded in H2 but truncated in Oracle (fixed in SYSDATE only)
  • Issue [#3642]: AssertionError in mvstore.FileStore.serializeAndStore
  • Issue [#3675]: H2 2.x cannot read PostgreSQL-style sequence generator start with option without WITH keyword
  • Issue [#3757]: FORMATDATETIME function doesn't handle time with time zone properly
  • PR [#3756]: Limit the row list allocation based on the row count
  • PR [#3753]: Add missing NEWSEQUENTIALID function in MSSQLServer mode
  • Issue [#3730]: FILE_READ from JAR filesystem on classpath results in file of length 0
  • PR [#3749]: Fix min/max description for sequences
  • PR [#3739]: Fix count(*) for linked table to Oracle
  • Issue [#3731]: Division result exceeds numeric precision constraint
  • PR [#3718]: Add test coverage for JDK 17
  • Issue [#3580]: TestCrashAPI: NPE in ParserUtil.getTokenType() (called by Parser.readIfDataType1())
  • PR [#3709]: Update copyright years and fix building of documentation
  • Issue [#3701]: CLOBs can cause ClassCastExceptions
  • Issue [#3698]: MySQL mode show columns from table, if modificationMetaId changed between prepared and execute. Then error occurred.
  • PR [#3699]: Upgrade to the latest OSGi JDBC specification
  • Issue [#3659]: User-defined variable "sticky" if used in view with join
  • Issue [#3693]: Wrong result when intersecting unnested arrays
  • PR [#3691]: GitHub Workflows security hardening
  • PR [#3688]: Construct FormatTokenEnum.TOKENS during class initialization
  • Issue [#3682]: MVStoreException at accountForRemovedPage
  • Issue [#3664]: [2.1.214] NullPointerException in org.h2.command.query.Select.queryDistinct
  • PR [#3650]: fix version number in the archives html table
  • PR [#3649]: Basic implementation of materialized view
  • Issue [#3646]: org.h2.mvstore.MVStoreException: Chunk metadata too long
  • Issue [#3645]: The BITCOUNT function incorrectly counts BINARY/VARBINARY values of >=16 bytes.
  • Issue [#3637]: DB content massacred when opening a 2.1.214 DB with current master
  • Issue [#3636]: "This store is closed" after two-phase commit
  • PR [#3639]: Add random_uuid() alias to be compatible with postgres
  • Issue [#3640]: SOUNDEX function should not be case-sensitive
  • Issue [#3633]: Memory leak in case of in-memory database
  • PR [#3629] Better separation between MVStore and FileStore
  • PR [#3626]: Improve memory estimation of CacheLongKeyLIRS and correct some passed memory sizes
  • Issue [#3619]: PostgreSQL mode: STRING_AGG with prepared statement parameter not working
  • Issue [#3615]: H2 Console connecting to Oracle DB will not show the list of tables
  • PR [#3613]: Fix infinite loop in Tokenizer when special whitespace character is used
  • Issue [#3606]: Support for GraalVMs native-image
  • Issue [#3607]: [MySQL] UNIX_TIMESTAMP should return NULL
  • Issue [#3604]: Improper FROM_1X implementation corrupts some BLOBs during migration
  • Issue [#3597]: Support array element assignments in UPDATE statements
  • Issue [#3599]: [2.1.214][MariaDB] DELETE query failure
  • Issue [#3600]: NPE in MVTable.lock(), version 2.1.214
  • Issue [#3601]: InvalidPathException when saving lock file
  • Issue [#3583]: lob cleaner issue
  • Issue [#3585]: Misuse ValueReal.DECIMAL_PRECISION when optimize typeinfo from DOUBLE to DECFLOAT
  • Issue [#3575]: Possible syntax mismatch for json_object in MySQL compatibility mode
  • PR [#3577]: Add support of TINYINT and DECFLOAT to TO_CHAR
  • Issue [#3567]: No AUTO_INCREMENT in DatabaseMetaData.getTypeInfo()
  • PR [#3555]: Add missing check for -webExternalNames flag
  • Issue [#3543]: PostgreSQL mode, update with "from", why "NULL not allowed" error?
  • PR [#3542]: Fix failed to delete a readonly file on Windows file systems
Source: README.md, updated 2023-07-04