Owner

h2database

1 indexed repository · View on GitHub

h2database
H2 is an embeddable RDBMS written in Java.

Java · 4631 stars

Beginner friendly Everything

Open All

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

enhancement Priority-Low

h2database/h2database#4194 · 7 comments · 1 assignee · Opened Jan 22, 2025
LINK_SCHEMA: Add filtering of tables and views, read-only mode, skip non-selectable objects Open

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

h2database/h2database#4193 · Opened Jan 22, 2025
`CREATE SCHEMA IF NOT EXISTS` should not causes `RuntimeException: object already exists when` Open

Priority-Low

h2database/h2database#4188 · 11 comments · 1 assignee · Opened Jan 10, 2025
Duplicate table aliases should throw own exception Open

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

h2database/h2database#4187 · Opened Jan 8, 2025
File Handle Leak in H2 Database Driver Open

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

h2database/h2database#4186 · Opened Jan 8, 2025
Composite index not effective Open

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

h2database/h2database#4175 · 2 comments · Opened Dec 26, 2024
CTE never ends Open

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

h2database/h2database#4173 · Opened Dec 23, 2024
REFRESH MATERIALIZED VIEW CONCURRENTLY don't work Open

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

h2database/h2database#4172 · 2 comments · Opened Dec 22, 2024
`MERGE INTO` will throw `JdbcSQLIntegrityConstraintViolationException` on two concurrent connections Open

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

h2database/h2database#4171 · 2 comments · Opened Dec 15, 2024
Default / sensible value for RETENTION_TIME Open

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

h2database/h2database#4170 · 3 comments · Opened Dec 7, 2024
one table more than 10_0000 rows，delete very slow Open

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

h2database/h2database#4158 · 4 comments · Opened Nov 12, 2024
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "xxx" not found; Open

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

h2database/h2database#4157 · Opened Nov 12, 2024
Change method/class visibility for a better integration into existing Framework Open

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

h2database/h2database#4147 · 2 comments · Opened Oct 26, 2024
org.h2.mvstore.MVStoreException: Chunk *** not found [2.3.232/9] Open

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

h2database/h2database#4142 · 12 comments · 1 reaction · Opened Oct 21, 2024
Sub select returns insufficient data after change H2 Version. Open

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

h2database/h2database#4138 · 4 comments · Opened Oct 10, 2024
Math functions must return `DECLFOAT` value for `DECFLOAT` arguments Open

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

h2database/h2database#4135 · Opened Oct 3, 2024
Cannot dereference columns from synonym expressions Open

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

h2database/h2database#4132 · 1 comment · Opened Sep 26, 2024
Add documentation for CREATE SYNONYM and DROP SYNONYM Open

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

h2database/h2database#4131 · 4 comments · Opened Sep 26, 2024
Questions regarding generatedColumnExpression Open

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

h2database/h2database#4130 · 1 comment · Opened Sep 25, 2024
numericWithBooleanComparison is ignored in the ConditionIn Optimizer Open

mysql oracle

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

h2database/h2database#4129 · 3 comments · Opened Sep 24, 2024
I cannot use the up key to call up the last executed sql, and I get sql> ^[[A^[[A Open

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

h2database/h2database#4109 · 2 comments · Opened Aug 8, 2024
DEFAULT or ON UPDATE expression with reference to some table or view can corrupt metadata Open

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

h2database/h2database#4104 · 1 comment · Opened Aug 3, 2024
Oracle compatibility mode: treat WITH as WITH RECURSIVE (2.3.230 regression) Open

oracle

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

h2database/h2database#4100 · 4 comments · 3 reactions · Opened Aug 2, 2024
Trying to understand housekeeping mechanism - poc provided Open

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

h2database/h2database#4096 · 3 comments · 1 reaction · Opened Jul 31, 2024
Allow executeQuery to also run execute or executeUpdate in Oracle mode Open

oracle

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

h2database/h2database#4073 · 2 comments · Opened Jul 10, 2024
IllegalMonitorStateException Open

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

h2database/h2database#4068 · 6 comments · Opened Jul 4, 2024
After running for one year, the following abnormalities suddenly appeared Open

duplicate

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

h2database/h2database#4066 · 2 comments · Opened Jun 20, 2024
Update with large WHERE IN predicate stalls Open

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

h2database/h2database#4064 · 12 comments · Opened Jun 13, 2024
JdbcSQLNonTransientConnectionException during check constraint after updating to 2.2.224 Open

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

h2database/h2database#4063 · 2 comments · Opened Jun 10, 2024
Random NullPointerExceptions in MySQL mode when doing INSERT ... ON DUPLICATE KEY UPDATE ... Open

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

h2database/h2database#4062 · 1 comment · Opened Jun 10, 2024
The database continues to grow even when no new data is added. Open

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

h2database/h2database#4061 · 3 comments · Opened Jun 8, 2024
H2 Much Faster than DuckDB for small inserts / selected Open

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

h2database/h2database#4055 · 2 comments · 1 reaction · Opened May 14, 2024
Takes Too much Time during get and put operation using version 2.1.214 Open

MVStore

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

h2database/h2database#4054 · 2 comments · Opened May 14, 2024
Question about Chunk.MAX_ID Open

MVStore

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

h2database/h2database#4052 · 3 comments · Opened May 7, 2024
Linked Table issues Open

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

h2database/h2database#4050 · Opened May 2, 2024
H2 `cast ('1' as unsigned integer)` will throw `Unknown data type: "UNSIGNED"` Open

mysql

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

h2database/h2database#4046 · 6 comments · Opened Apr 17, 2024
Default administrator is not part of PUBLIC role Open

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

h2database/h2database#4044 · 3 comments · Opened Apr 17, 2024
Compressed(gzip) csv files support. Open

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

h2database/h2database#4039 · 2 comments · Opened Apr 6, 2024
Configurable Optimizer Query Plan Limits Open

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

h2database/h2database#4035 · 1 comment · Opened Mar 26, 2024
H2 database randomly throwing StackOverflowError Open

MVStore

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

h2database/h2database#4026 · 4 comments · 1 reaction · Opened Mar 14, 2024
Can't delete records Open

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

h2database/h2database#4023 · 6 comments · Opened Mar 11, 2024
Recovery fails Open

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

h2database/h2database#4020 · 1 comment · Opened Mar 4, 2024
org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.IllegalStateException: Chunk 42008 not found [1.4.200/9]" [50000-200] Open

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

h2database/h2database#4019 · 1 comment · Opened Mar 4, 2024
`WITH ` clauses don't work with DMLs anymore Open

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

h2database/h2database#4002 · 16 comments · 1 reaction · Opened Feb 15, 2024
Add support `JSON_SET` and `JSON_CONTAINS_PATH` functions Open

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

h2database/h2database#4001 · 6 comments · Opened Feb 13, 2024
Semantically wrong query is executed by H2 when LIMIT 0 is used Open

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

h2database/h2database#3999 · 2 comments · Opened Feb 7, 2024
Prefil h2-console login data by request parameter Open

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

h2database/h2database#3979 · 1 comment · 2 reactions · Opened Jan 24, 2024
Missing support for 'NO KEY UPDATE' locking with PostgrSQL mode Open

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

h2database/h2database#3976 · 1 comment · Opened Jan 22, 2024
DROP ALL OBJECTS doesn't drop local temporary tables Open

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

h2database/h2database#3971 · 1 comment · Opened Jan 20, 2024
Add explicit table locking Open

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

h2database/h2database#3964 · 11 comments · Opened Jan 13, 2024

Showing the newest 100

This page lists what was indexed most recently. Advanced filter has the whole inventory, narrowed by language, difficulty and how long a task takes.

Open advanced filter

h2database

Showing the newest 100

Get new issues in your inbox