Releases · H2database/h2database - GitHub

Two security vulnerabilities in H2 Console (CVE-2022-23221 and possible DNS rebinding attack) are fixed.

Persistent databases created by H2 2.0.x don't need to be upgraded. Persistent databases created by H2 1.4.200 and older versions require export into SQL script with that old version and creation of a new database with the new version and execution of this script in it.

• PR #3381: Add IDENTITY() and SCOPE_IDENTITY() to LEGACY mode
• Issue #3376: Data cannot be read after insert of clob data > MAX_LENGTH_INPLACE_LOB with data change delta table
• PR #3377: Add -webExternalNames setting and fix WebServer.getConnection()
• PR #3367: Use faster checks of dimension systems of geometries
• PR #3369: Added v2 changes in migration docs
• Issue #3361: MemoryEstimator.estimateMemory() can return negative size
• PR #3362: Use BufferedReader instead of BufferedInputStream to avoid Illegal seek exception
• Issue #3353: Wrong rownum() scope for DML with change delta table
• PR #3352: make Javadoc happier
• Issue #3344: Changelog could link to github issue
• Issue #3340: JDBC index type seems wrong
• Issue #3336: FT_INIT error when mode=MySQL
• Issue #3334: Regression with CREATE ALIAS - Parameter "#2" is not set
• Issue #3321: Insert Primary Key after import CSV Data does not work
• PR #3323: Tokenize SQL before parsing and preserve tokens for recompilation
• PR #3320: Add Servlet 5-compatible servlet for H2 Console
• Issue #918: Parser fails recognising set operations in correlated subqueries
• Issue #2050: PostgreSQL with recursive fail with union in the final query
• PR #3316: Update copyright years
• PR #3315: Never put read locks into lockSharedSessions and other minor changes
• Issue #492: H2 does not correctly parse <parenthesized joined table>
• Issue #3311: Parser creates wrong join graph in some cases and uses wrong tables for column mapping
• FORCE_JOIN_ORDER setting is removed
• Issue #1983: Official build script is not compatible with Java 13
• PR #3305: Add UNIQUE(VALUE) and remove some non-standard keywords
• PR #3299: Remove useless StringBuilder.toString() call
• PR #3298: Delete unused sqlTypes array