Issues

• 2.5.252: joins over INFORMATION_SCHEMA constraint tables are ~70x slower since meta indexes are visible to the planner

  h2database/h2database#4523 · Filter by author alf opened on Oct 30, 2026

• MVStore file cannot be opened after a crash right after an asynchronous commit: Chunk N not found

  h2database/h2database#4518 · Filter by author aadrian opened on Oct 27, 2026

• SET WRITE_DELAY 0 is documented as persistent but is overwritten by the 500 ms default on every open, so commits are again lost on a crash

  h2database/h2database#4479 · Filter by author hanke580 opened on Oct 22, 2026
  1

• ALTER TABLE ADD/DROP COLUMN or ALTER COLUMN <type> releases its exclusive table lock early; INSERTs and UPDATEs committed by other connections during the ALTER return 1 and are lost

  h2database/h2database#4478 · Filter by author hanke580 opened on Oct 22, 2026

• A crash or I/O error during ALTER TABLE ADD COLUMN can leave the table gone, with its rows only in an internal <table>_COPY_<n>_<m> table (or leave that copy table behind)

  h2database/h2database#4477 · Filter by author hanke580 opened on Oct 22, 2026
  1

• Self-referencing foreign key: ON UPDATE CASCADE / SET NULL is skipped when one UPDATE changes the INTEGER primary key of both parent and child rows (orphans committed; regression since 2.0)

  h2database/h2database#4471 · Filter by author hanke580 opened on Oct 20, 2026

• Recursive CTE without termination condition causes OutOfMemoryError; add max recursion / row limit

  h2database/h2database#4460 · Filter by author Surneval opened on Oct 15, 2026
  1

• Index type different than query could lead to missing row

  h2database/h2database#4456 · Filter by author turbanoff opened on Oct 14, 2026

• It's not necessary to copy the memory block in the readWrite() of org.h2.store.fs.mem.FileMemData

  h2database/h2database#4435 · Filter by author forchid opened on Oct 6, 2026

• BUG: org.h2.jdbc.JdbcSQLNonTransientException: Unknown data type: "INET"

  h2database/h2database#4425 · Filter by author BowlBird opened on Sep 29, 2026
  3

• MSSQLServer mode handles target-table hints inconsistently in DELETE and MERGE

  h2database/h2database#4408 · Filter by author Wwwing301 opened on Sep 20, 2026

• org.h2.mvstore.MVStoreException: Chunk * not found

  h2database/h2database#4383 · Filter by author kennethjor opened on Sep 1, 2026
  8

• MODE=Oracle: LIKE ... ESCAPE '' never matches (empty-string escape disables LIKE entirely)

  h2database/h2database#4367 · Filter by author lennartvk opened on Jul 24, 2026
  1

• QUALIFY in CTE or VIEW ignored when queried with WHERE

  h2database/h2database#4366 · Filter by author thuri opened on Jul 23, 2026
  3

• Unnecessary WHERE condition evaluation leading to error

  h2database/h2database#4364 · Filter by author beikov opened on Jul 15, 2026
  1

• MySQL compatibility mode does not accept MySQL-style DATEDIFF(end, start) two-argument signature

  h2database/h2database#4351 · Filter by author donglianghan opened on Jun 9, 2026
  1

• CREATE TEMPORARY TABLE AS SELECT incorrectly drops the only NULL row

  h2database/h2database#4349 · Filter by author AnotherYx opened on Jun 6, 2026

• Scope propagation to sub-subqueries

  h2database/h2database#4339 · Filter by author mikclrk-21cs opened on Apr 7, 2026
  1

• Regression from 2.1.212 to 2.1.214.

  h2database/h2database#4337 · Filter by author sageserpent-open opened on Mar 31, 2026
  5

• [Bug]: Severe ClassLoader Pinning & Metaspace OOM via META_LOCK_DEBUGGING ThreadLocals

  h2database/h2database#4333 · Filter by author QiuYucheng2003 opened on Mar 2, 2026
  1

• org.h2.jdbc.JdbcSQLDataException: Data conversion error converting "CHARACTER VARYING to JAVA_OBJECT" [22018-224]

  h2database/h2database#4328 · Filter by author itumairsayed opened on Feb 12, 2026
  1

• JSON array constructor by query cannot handle set operations in argument queries

  h2database/h2database#4325 · Filter by author lukaseder opened on Feb 4, 2026

• ALTER TABLE ADD with long column name removes similar column after disconnect

  h2database/h2database#4324 · Filter by author cbbravo opened on Feb 3, 2026

• new row not visible with insertRow on updatable/scrollable resultset

  h2database/h2database#4319 · Filter by author optyfr opened on Jan 22, 2026

• deeply nested where-in query hangs (cycles) indefinitely after upgrading to 2.4.240

  h2database/h2database#4318 · Filter by author Incanus3 opened on Jan 22, 2026
  22