Issues

• 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

• MVStore file keeps growing after reopening a store following a crash (regression in 2.5.252)

  h2database/h2database#4457 · Filter by author engineerdev opened on Oct 14, 2026

• Index type different than query could lead to missing row

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

• Distinct query ignores DESC when there is an index

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

• "Unexpected code path" on duplicated indexed column

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

• Wrong syntax generated by optimizer on WHERE EXISTS

  h2database/h2database#4445 · Filter by author vpinna80 opened on Oct 7, 2026

• Recover script fails or restores wrong values for ENUM columns

  h2database/h2database#4444 · Filter by author aadrian opened on Oct 7, 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

• BUG: Parenthesized UNION term returns stale result when only its FETCH / OFFSET / ORDER BY parameter changes

  h2database/h2database#4421 · Filter by author NikitaIT opened on Sep 28, 2026

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

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

• Table name missing in JdbcSQLTimeoutException

  h2database/h2database#4388 · Filter by author wielantu opened on Sep 7, 2026
  7

  

• 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