h2database

Issues somebody may already be working on are listed last. List everything by date

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

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 78/100

  h2database/h2database#4435 · Opened Oct 6, 2026

  Maintainers usually reply within 1 day

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

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 55/100

  h2database/h2database#4425 · 3 comments · Opened Sep 29, 2026

  Maintainers usually reply within 1 day

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

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 3/5 1-2 days Newbie friendliness 68/100

  h2database/h2database#4408 · Opened Sep 20, 2026

  Maintainers usually reply within 1 day

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

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 45/100

  h2database/h2database#4383 · 8 comments · Opened Sep 1, 2026

  Maintainers usually reply within 1 day

• H2 database Upgrade utility fails for recent 2.* versions

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 76/100

  h2database/h2database#4354 · 1 comment · Opened Jun 26, 2026

  Maintainers usually reply within 1 day

• Scope propagation to sub-subqueries

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 48/100

  h2database/h2database#4339 · 1 comment · Opened Apr 7, 2026

  Maintainers usually reply within 1 day

• Regression from 2.1.212 to 2.1.214.

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 42/100

  h2database/h2database#4337 · 5 comments · Opened Mar 31, 2026

  Maintainers usually reply within 1 day

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

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 35/100

  h2database/h2database#4333 · 1 comment · Opened Mar 2, 2026

  Maintainers usually reply within 1 day

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

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 30/100

  h2database/h2database#4328 · 1 comment · Opened Feb 12, 2026

  Maintainers usually reply within 1 day

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

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 45/100

  h2database/h2database#4325 · Opened Feb 4, 2026

  Maintainers usually reply within 1 day

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

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 25/100

  h2database/h2database#4324 · Opened Feb 3, 2026

  Maintainers usually reply within 1 day

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

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 42/100

  h2database/h2database#4319 · Opened Jan 22, 2026

  Maintainers usually reply within 1 day

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

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 45/100

  h2database/h2database#4318 · 22 comments · Opened Jan 22, 2026

  Maintainers usually reply within 1 day

• [H2 database] The database has been closed [90098-232]

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 5/5 Over a week Newbie friendliness 25/100

  h2database/h2database#4316 · 7 comments · Opened Jan 7, 2026

  Maintainers usually reply within 1 day

• How can I recovery the H2 database and why got this exception?

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 5/5 Over a week Newbie friendliness 18/100

  h2database/h2database#4315 · Opened Jan 5, 2026

  Maintainers usually reply within 1 day

• Upper case at login form for choose language

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 35/100

  h2database/h2database#4295 · Opened Oct 14, 2025

  Maintainers usually reply within 1 day

• Data Races org.h2.jdbc.JdbcConnection

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 48/100

  h2database/h2database#4289 · 7 comments · Opened Sep 29, 2025

  Maintainers usually reply within 1 day

• H2 selects less selective index in query plan

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 35/100

  h2database/h2database#4281 · 4 comments · Opened Sep 15, 2025

  Maintainers usually reply within 1 day

• Illegal char <:>when using RunScript on Windows with classpath: in filename

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 3/5 1-2 days Newbie friendliness 50/100

  h2database/h2database#4272 · Opened Aug 30, 2025

  Maintainers usually reply within 1 day

• Use of hardcoded Old algorithm to provide SecureRandom

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 48/100

  h2database/h2database#4259 · 3 comments · Opened Aug 21, 2025

  Maintainers usually reply within 1 day

• Clarify security of encryption

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 3/5 1-2 days Newbie friendliness 35/100

  h2database/h2database#4252 · Opened Aug 4, 2025

  Maintainers usually reply within 1 day

• Next sequence value incorrect when grouping in select

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 35/100

  h2database/h2database#4251 · 3 comments · Opened Aug 1, 2025

  Maintainers usually reply within 1 day

• Feature: Materialized CTE

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement WITH clause

  Difficulty 5/5 Over a week Newbie friendliness 30/100

  h2database/h2database#4246 · 3 comments · Opened Jul 7, 2025

  Maintainers usually reply within 1 day

• Merge and update on a table with a composite primary key extremely slow.

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 30/100

  h2database/h2database#4244 · 1 comment · Opened Jul 1, 2025

  Maintainers usually reply within 1 day

• MySQL mode does not respect IGNORECASE/CASE_INSENSITIVE_IDENTIFIERS in 'on duplicate key update' part (H2 2.3.232)

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  mysql

  Difficulty 4/5 3-5 days Newbie friendliness 45/100

  h2database/h2database#4238 · 1 comment · Opened Jun 17, 2025

  Maintainers usually reply within 1 day

• `WHERE` does not reject Window functions, but returns zero records instead

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 30/100

  h2database/h2database#4237 · 4 comments · Opened Jun 11, 2025

  Maintainers usually reply within 1 day

• ClassCastException with extracted temporal fields and multiple rows

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  invalid

  Difficulty 3/5 1-2 days Newbie friendliness 38/100

  h2database/h2database#4236 · 3 comments · Opened May 30, 2025

  Maintainers usually reply within 1 day

• H2 runs out of memory

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 5/5 Over a week Newbie friendliness 25/100

  h2database/h2database#4233 · 3 comments · Opened May 21, 2025

  Maintainers usually reply within 1 day

• BuildBase.java calls javadoc without respecting JAVA_HOME

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 55/100

  h2database/h2database#4230 · Opened May 10, 2025

  Maintainers usually reply within 1 day

• Parameter in WITH clause of prepared statement is not updated

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 48/100

  h2database/h2database#4228 · 4 comments · 3 reactions · Opened Apr 23, 2025

  Maintainers usually reply within 1 day

• H2 Compaction became significantly worse in terms of size in 2.2.220

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 35/100

  h2database/h2database#4223 · 1 comment · Opened Apr 10, 2025

  Maintainers usually reply within 1 day

• "Generated column cannot be assigned" when database is recovered from sql script

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 35/100

  h2database/h2database#4222 · Opened Apr 4, 2025

  Maintainers usually reply within 1 day

• JAVA_OBJECT_SERIALIZER Not Reapplying Correctly

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 3/5 1-2 days Newbie friendliness 42/100

  h2database/h2database#4207 · 1 comment · Opened Mar 4, 2025

  Maintainers usually reply within 1 day

• H2 console not working with Spring Boot 3

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 35/100

  h2database/h2database#4205 · 3 comments · Opened Mar 1, 2025

  Maintainers usually reply within 1 day

• Read H2 Version from xxx.mv.db file

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 5/5 Over a week Newbie friendliness 25/100

  h2database/h2database#4202 · 2 comments · Opened Feb 19, 2025

  Maintainers usually reply within 1 day

• SYSDATE doesn't work in subquery

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 35/100

  h2database/h2database#4200 · 6 comments · Opened Feb 14, 2025

  Maintainers usually reply within 1 day

• CTE with delete started throwing exceptions

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 35/100

  h2database/h2database#4196 · 2 comments · Opened Jan 28, 2025

  Maintainers usually reply within 1 day

• LINK_SCHEMA fails on unknown DATA_TYPE = 2001, SQL_DATA_TYPE = 17

  May be free again @manticore-projects claimed this 620 days ago, and no pull request is open. Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  enhancement Priority-Low

  h2database/h2database#4194 · 7 comments · 1 assignee · Opened Jan 22, 2025

  Maintainers usually reply within 1 day

• LINK_SCHEMA: Add filtering of tables and views, read-only mode, skip non-selectable objects

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 5/5 Over a week Newbie friendliness 25/100

  h2database/h2database#4193 · Opened Jan 22, 2025

  Maintainers usually reply within 1 day

• `CREATE SCHEMA IF NOT EXISTS` should not causes `RuntimeException: object already exists when`

  May be free again @manticore-projects claimed this 615 days ago, and no pull request is open. Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel
  Priority-Low

  h2database/h2database#4188 · 11 comments · 1 assignee · Opened Jan 10, 2025

  Maintainers usually reply within 1 day

• File Handle Leak in H2 Database Driver

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 2/5 1-3 hours Newbie friendliness 50/100

  h2database/h2database#4186 · Opened Jan 8, 2025

  Maintainers usually reply within 1 day

• Composite index not effective

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 25/100

  h2database/h2database#4175 · 2 comments · Opened Dec 26, 2024

  Maintainers usually reply within 1 day

• CTE never ends

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 45/100

  h2database/h2database#4173 · Opened Dec 23, 2024

  Maintainers usually reply within 1 day

• REFRESH MATERIALIZED VIEW CONCURRENTLY don't work

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 5/5 Over a week Newbie friendliness 30/100

  h2database/h2database#4172 · 2 comments · Opened Dec 22, 2024

  Maintainers usually reply within 1 day

• `MERGE INTO` will throw `JdbcSQLIntegrityConstraintViolationException` on two concurrent connections

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 45/100

  h2database/h2database#4171 · 2 comments · Opened Dec 15, 2024

  Maintainers usually reply within 1 day

• Default / sensible value for RETENTION_TIME

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 3/5 1-2 days Newbie friendliness 35/100

  h2database/h2database#4170 · 3 comments · Opened Dec 7, 2024

  Maintainers usually reply within 1 day

• one table more than 10_0000 rows，delete very slow

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 25/100

  h2database/h2database#4158 · 4 comments · Opened Nov 12, 2024

  Maintainers usually reply within 1 day

• org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "xxx" not found;

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 4/5 3-5 days Newbie friendliness 25/100

  h2database/h2database#4157 · Opened Nov 12, 2024

  Maintainers usually reply within 1 day

• Change method/class visibility for a better integration into existing Framework

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 3/5 1-2 days Newbie friendliness 38/100

  h2database/h2database#4147 · 2 comments · Opened Oct 26, 2024

  Maintainers usually reply within 1 day

• org.h2.mvstore.MVStoreException: Chunk *** not found [2.3.232/9]

  Open

  ⋯Report a problem with this issue

  • Is something wrong?

  • Already taken
  • Not beginner-friendly
  • Stale or invalid
  • Something else…
  • Send Cancel

  Difficulty 5/5 Over a week Newbie friendliness 20/100

  h2database/h2database#4142 · 12 comments · 1 reaction · Opened Oct 21, 2024

  Maintainers usually reply within 1 day