h2database/h2database issues and pull requests

#4133 - DROP SYNONYM isn't dropping the synonym right away

Issue - State: open - Opened by lukaseder 2 days ago - 2 comments

#4132 - Cannot dereference columns from synonym expressions

Issue - State: open - Opened by lukaseder 2 days ago - 1 comment

#4131 - Add documentation for CREATE SYNONYM and DROP SYNONYM

Issue - State: open - Opened by lukaseder 2 days ago - 4 comments

#4130 - Questions regarding generatedColumnExpression

Issue - State: open - Opened by McBluna 3 days ago - 1 comment

#4129 - numericWithBooleanComparison is ignored in the ConditionIn Optimizer

Issue - State: open - Opened by iyzana 4 days ago - 3 comments
Labels: mysql, oracle

#4128 - Order by affects filtering (2.3.230 regression)

Issue - State: closed - Opened by beikov 10 days ago - 4 comments

#4127 - WITH clause requires column list (2.3.230 regression)

Issue - State: closed - Opened by beikov 10 days ago - 11 comments

#4126 - bloated databases from inserts

Issue - State: open - Opened by uvilop 14 days ago - 6 comments

#4125 - fix race in access to TO_UPPER_CACHE

Pull Request - State: closed - Opened by andreitokar 15 days ago

#4124 - java.lang.NullPointerException: Cannot invoke "String.equals(Object)" because "[0]" is null

Issue - State: closed - Opened by ericcaspole 15 days ago

#4123 - Table data corruption with frequent restarts

Issue - State: open - Opened by shawkins 16 days ago - 10 comments

#4122 - Test Failure

Issue - State: closed - Opened by Vipul-Ajmera 17 days ago - 4 comments

#4121 - h2 maven package has no compile dependencies !?

Issue - State: closed - Opened by zakkak about 1 month ago - 4 comments

#4120 - Is there any BLOB deduplication feature in H2 ? (if there isn't there is a bug and I have a reproducer)

Issue - State: closed - Opened by fmarot about 1 month ago - 8 comments

#4118 - H2 Numeric Scale Issue after migrating from H2 1.x to H2 2.x

Issue - State: closed - Opened by mayankchauhan971 about 1 month ago - 1 comment

#4117 - Fix Index.getCostRangeIndex()

Pull Request - State: closed - Opened by katzyn about 1 month ago

#4116 - Optimizer chooses wrong execution plan in some cases when index-sorted optimization is possible

Issue - State: closed - Opened by forchid about 1 month ago - 17 comments

#4115 - Fix IN predicate with row values and parameters

Pull Request - State: closed - Opened by katzyn about 2 months ago

#4114 - Regression when using CAST expressions in ROW IN predicates

Issue - State: closed - Opened by lukaseder about 2 months ago - 12 comments

#4113 - Add optional version parameter to RANDOM_UUID function

Pull Request - State: closed - Opened by katzyn about 2 months ago

#4112 - Add alter enum support.

Pull Request - State: closed - Opened by a-e-tsvetkov about 2 months ago - 3 comments

#4111 - `ALTER TYPE name ADD VALUE new_enum_value` is not supported

Issue - State: closed - Opened by a-e-tsvetkov about 2 months ago - 1 comment

#4110 - Type cannot be derived from Query on dual

Issue - State: closed - Opened by langersteff about 2 months ago - 1 comment

#4109 - I cannot use the up key to call up the last executed sql, and I get sql> ^[[A^[[A

Issue - State: open - Opened by yangbodong22011 about 2 months ago - 2 comments

#4108 - [2.3.230 Regression] Ordering indexed column returns empty result set

Issue - State: closed - Opened by sutr90 about 2 months ago - 1 comment

#4107 - org.h2.mvstore.MVStoreException: Invalid chunk id 0 [2.2.220/6]

Issue - State: closed - Opened by Asiastorm about 2 months ago - 3 comments

#4106 - HSTS not enabled

Issue - State: closed - Opened by SuleymanCommits about 2 months ago - 1 comment

#4105 - Execute statement SHUTDOWN generate silent error Database is already closed

Issue - State: closed - Opened by JayDi85 about 2 months ago - 2 comments

#4104 - DEFAULT or ON UPDATE expression with reference to some table or view can corrupt metadata

Issue - State: open - Opened by katzyn about 2 months ago - 1 comment

#4103 - Pass mapped columns to table filters of subqueries

Pull Request - State: closed - Opened by katzyn about 2 months ago

#4102 - How can I recovery the database when got MVStoreException, and why got this exception?

Issue - State: closed - Opened by ousui about 2 months ago - 4 comments

#4101 - Wrong case with linked table

Issue - State: closed - Opened by pierrehenrisudre about 2 months ago - 1 comment

#4100 - Oracle compatibility mode: treat WITH as WITH RECURSIVE (2.3.230 regression)

Issue - State: open - Opened by ArturKasumov about 2 months ago - 4 comments
Labels: oracle

#4099 - No result returned when filtering and ordering on composite primary key

Issue - State: closed - Opened by diegosalvi about 2 months ago - 2 comments

#4098 - Fix multiple queries in a statement and improve special cases in rounding functions

Pull Request - State: closed - Opened by katzyn about 2 months ago

#4097 - StackOverflowException when using multiple SELECT statements in one query (2.3.230)

Issue - State: closed - Opened by jacquipre about 2 months ago - 6 comments

#4096 - Trying to understand housekeeping mechanism - poc provided

Issue - State: open - Opened by fmarot about 2 months ago - 3 comments

#4095 - Fix query cache related races

Pull Request - State: closed - Opened by katzyn about 2 months ago

#4094 - Issue 4075

Pull Request - State: closed - Opened by andreitokar about 2 months ago

#4093 - DatabaseMetaData are volatile and become invalide when Connection is closed

Issue - State: closed - Opened by manticore-projects 2 months ago - 2 comments

#4092 - Don't convert column names to upper case in TableLink

Pull Request - State: closed - Opened by katzyn 2 months ago

#4091 - Wrong case with linked table to postgresql

Issue - State: closed - Opened by teid 2 months ago - 1 comment

#4090 - [QUESTION] Does `MVStore` supports mutable values in `MVMap`s

Issue - State: closed - Opened by InAnYan 2 months ago - 4 comments

#4089 - Allow duplicate query names in different WITH clauses

Pull Request - State: closed - Opened by katzyn 2 months ago

#4088 - BadGrammarException when the same alias is used within two different CTEs

Issue - State: closed - Opened by pstobiecki-ocado 2 months ago - 2 comments

#4087 - Regression from 2.2.224 to 2.3.230

Issue - State: closed - Opened by dkromm 2 months ago - 3 comments

#4086 - Assertion errror on compact (regression in 2.3.230)

Issue - State: open - Opened by develar 2 months ago - 1 comment
Labels: MVStore

#4085 - Attempting to connect to H2 server instance via PG connection but "PG_CATALOG" not found.

Issue - State: closed - Opened by Lorondos 2 months ago - 1 comment

#4084 - ORDER BY DESC matching index returns wrong results

Issue - State: closed - Opened by brettkail-wk 2 months ago - 2 comments

#4083 - H2 file gets corrupted upon application shutdwon

Issue - State: closed - Opened by jakub-moravec 2 months ago - 3 comments

#4082 - Critical Security Alert: Remote Code Execution Vulnerability Found in H2 Database

Issue - State: closed - Opened by ViperXSec 2 months ago - 1 comment

#4081 - Java version bump strictly necessary in minor version release?

Issue - State: closed - Opened by sjoerdtalsma 2 months ago - 2 comments

#4080 - Fix boundaries inclusion in reverse index scan

Pull Request - State: closed - Opened by andreitokar 2 months ago - 3 comments

#4079 - [2.3.230] Regression in ORDER BY ... DESC on dates

Issue - State: closed - Opened by ctabin 2 months ago - 3 comments

#4077 - H2 Whether the version 2.2.224 database supports non-zero listening

Issue - State: closed - Opened by jiananxu 3 months ago - 1 comment

#4076 - in preparation for release

Pull Request - State: closed - Opened by andreitokar 3 months ago

#4075 - infinite loop in compact

Issue - State: closed - Opened by uvilop 3 months ago - 15 comments

#4074 - Question about LOB and disk space

Issue - State: closed - Opened by fmarot 3 months ago - 2 comments

#4073 - Allow executeQuery to also run execute or executeUpdate in Oracle mode

Issue - State: open - Opened by s-lindenau 3 months ago - 2 comments
Labels: oracle

#4072 - See table structures in sql-workbench

Issue - State: closed - Opened by afattahi54 3 months ago - 1 comment

#4071 - Issue on how legacy H2 engine handles storing LOB files

Issue - State: closed - Opened by CasualDeveloper 3 months ago - 9 comments

#4070 - Add DB_OBJECT_APPROXIMATE_SIZE and DB_OBJECT_APPROXIMATE_TOTAL_SIZE

Pull Request - State: closed - Opened by katzyn 3 months ago - 9 comments

#4069 - online backup reliability improvement

Pull Request - State: open - Opened by andreitokar 3 months ago

#4068 - IllegalMonitorStateException

Issue - State: open - Opened by TimeWriterNL 3 months ago - 6 comments

#4067 - Different query results between versions 2.1.212 and 2.2.224

Issue - State: closed - Opened by manzyuk 3 months ago - 2 comments

#4066 - After running for one year, the following abnormalities suddenly appeared

Issue - State: open - Opened by laopo521anping 3 months ago - 2 comments
Labels: duplicate

#4065 - Fix for "double mark" error at database opening (#2752)

Pull Request - State: closed - Opened by vreuland 4 months ago - 1 comment

#4064 - Update with large WHERE IN predicate stalls

Issue - State: open - Opened by marcelstoer 4 months ago - 12 comments

#4063 - JdbcSQLNonTransientConnectionException during check constraint after updating to 2.2.224

Issue - State: open - Opened by RillingDev 4 months ago - 1 comment

#4062 - Random NullPointerExceptions in MySQL mode when doing INSERT ... ON DUPLICATE KEY UPDATE ...

Issue - State: open - Opened by kalgon 4 months ago - 1 comment

#4061 - The database continues to grow even when no new data is added.

Issue - State: open - Opened by TimeWriterNL 4 months ago - 3 comments

#4060 - Invalid value "CHARACTER VARYING" for parameter "JSON | ROW"; SQL statement:

Issue - State: closed - Opened by javaofferss 4 months ago - 1 comment

#4059 - Can not release memory when drop ,delete or truncate table

Issue - State: closed - Opened by peter-me-dev 4 months ago - 1 comment

#4058 - Current master's (14,371) web console fails to open existing database

Issue - State: closed - Opened by wburzyns 4 months ago - 9 comments

#4057 - Allow 0 as a valid chunk id

Pull Request - State: closed - Opened by andreitokar 5 months ago - 2 comments

#4056 - order by case ...

Issue - State: closed - Opened by sakolesnikov 5 months ago - 2 comments

#4055 - H2 Much Faster than DuckDB for small inserts / selected

Issue - State: open - Opened by ryanhamilton 5 months ago - 2 comments

#4054 - Takes Too much Time during get and put operation using version 2.1.214

Issue - State: open - Opened by chaitas90 5 months ago - 2 comments

#4053 - Issues with H2 Database and Spring Data JPA - Records not Updating and Autogenerated IDs are not sequentially stored

Issue - State: closed - Opened by siddareddy243523 5 months ago - 1 comment

#4052 - Question about Chunk.MAX_ID

Issue - State: open - Opened by koljakube 5 months ago - 3 comments
Labels: MVStore

#4051 - Grails 6.20, Springboot 2.7.18, using HikariCP and h2 2.2.224

Issue - State: closed - Opened by dgeiselmanMOO 5 months ago - 9 comments

#4050 - Linked Table issues

Issue - State: open - Opened by marat-ak 5 months ago

#4049 - WITH CLAUSE with named parameters not retrieving results.

Issue - State: closed - Opened by adee26 5 months ago - 5 comments

#4048 - Assertion error in shrinkStoreIfPossible

Issue - State: open - Opened by adelel1 5 months ago - 11 comments

#4047 - ensure proper prologue/epilogue for every statement in JDBC list

Pull Request - State: closed - Opened by andreitokar 5 months ago

#4046 - H2 `cast ('1' as unsigned integer)` will throw `Unknown data type: "UNSIGNED"`

Issue - State: open - Opened by tszxxx 5 months ago - 6 comments
Labels: mysql

#4045 - MySQL Compabilitiy Mode Escapes already escaped characters

Issue - State: closed - Opened by FreshDoktor 5 months ago - 3 comments

#4044 - Default administrator is not part of PUBLIC role

Issue - State: open - Opened by prrvchr 5 months ago - 3 comments

#4043 - BigDecimal conversion broken in division

Issue - State: closed - Opened by fjakop 6 months ago - 2 comments

#4042 - Question: Support for `INHERITS` in MODE=PostgreSQL ?

Issue - State: closed - Opened by SamuelGuillemet 6 months ago - 2 comments

#4041 - Reverse and incremental index sorting optimizations

Pull Request - State: closed - Opened by katzyn 6 months ago

#4040 - Information about the operation of the H2

Issue - State: closed - Opened by incapdns 6 months ago - 2 comments

#4039 - Compressed(gzip) csv files support.

Issue - State: open - Opened by smagellan 6 months ago - 2 comments

#4038 - Fix nulls not distinct constraint being lost on copy

Pull Request - State: closed - Opened by kacperkasztelanic 6 months ago - 1 comment

#4037 - Fix SQL export of constraints with custom UNIQUE null treatment

Pull Request - State: closed - Opened by katzyn 6 months ago

#4036 - NULLS NOT DISTINCT constraint changed after column dropped

Issue - State: closed - Opened by kacperkasztelanic 6 months ago

#4035 - Configurable Optimizer Query Plan Limits

Issue - State: open - Opened by oliver-hughes 6 months ago - 1 comment

#4034 - Fix determination of UNNEST data types for array constructors with casted parameters

Pull Request - State: closed - Opened by katzyn 6 months ago

#4033 - Wrong array produced when using ARRAY_AGG() on UNNEST(ARRAY[CAST(? AS INT)]) expression in a PreparedStatement

Issue - State: closed - Opened by lukaseder 6 months ago - 2 comments

#4032 - Not support using User-Defined Variables in select statement

Issue - State: closed - Opened by novNorthSea 6 months ago - 1 comment

GitHub / h2database/h2database issues and pull requests