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