h2database/h2database issues and pull requests

#4004 - added hex function

Pull Request - State: open - Opened by quantrpeter about 1 year ago - 3 comments

#4003 - add hex function:

Pull Request - State: closed - Opened by quantrpeter about 1 year ago

#4002 - `WITH ` clauses don't work with DMLs anymore

Issue - State: open - Opened by manticore-projects about 1 year ago - 16 comments

#4001 - Add support `JSON_SET` and `JSON_CONTAINS_PATH` functions

Issue - State: open - Opened by pavnesh-c about 1 year ago - 6 comments

#4000 - Fix endless chunk rewriting when db is idle - improvement

Pull Request - State: closed - Opened by vreuland about 1 year ago - 1 comment

#3999 - Semantically wrong query is executed by H2 when LIMIT 0 is used

Issue - State: open - Opened by lukaseder about 1 year ago - 2 comments

#3998 - Fix Issue #3907 - MvStoreTool unable to Repair() or Rollback()

Pull Request - State: closed - Opened by cgeesink about 1 year ago - 1 comment

#3997 - Server-side batch execution for prepared statements

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

#3996 - Avoid expensive Throwable.fillInStackTrace call on each batch execution

Pull Request - State: closed - Opened by turbanoff about 1 year ago - 6 comments

#3995 - Disallow trailing comma in select list

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

#3994 - OutOfMemoryError while Statement.RETURN_GENERATED_KEYS

Issue - State: closed - Opened by dahamsha about 1 year ago - 1 comment

#3993 - org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement when upgrading the version of H2

Issue - State: closed - Opened by fergalgavin about 1 year ago - 12 comments

#3992 - The IPv6 web console bug has been resolved, and it is now working.

Pull Request - State: closed - Opened by pavangabani about 1 year ago

#3991 - Fix SQL nulls in JSON

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

#3990 - Fix parameters in CTEs

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

#3989 - Refactor CTE-related code and reduce recompilations

Pull Request - State: closed - Opened by katzyn about 1 year ago - 3 comments

#3988 - Fix references to CTEs from derived tables and allow empty column lists in WITH clause

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

#3987 - Allow empty <with column list>

Issue - State: closed - Opened by katzyn about 1 year ago
Labels: WITH clause

#3986 - Move CTEs to their own scope of identifiers

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

#3982 - Potential issue when using `ROUND`

Issue - State: closed - Opened by suyZhong about 1 year ago - 11 comments
Labels: bug, enhancement

#3980 - #428 auto complete list

Pull Request - State: closed - Opened by manticore-projects about 1 year ago - 8 comments

#3966 - Unable to insert null into a JSON column

Issue - State: closed - Opened by mdrodg about 1 year ago - 2 comments

#3965 - mvn clean package

Issue - State: closed - Opened by quantrpeter about 1 year ago - 9 comments

#3963 - double CTE query not returning rows

Issue - State: closed - Opened by oxlade39 about 1 year ago - 6 comments
Labels: WITH clause

#3962 - Add support for PostgreSQL returning

Issue - State: open - Opened by PavelTurk about 1 year ago - 13 comments

#3945 - Column not found in correlated subquery, when referencing outer column from LEFT JOIN .. ON clause

Issue - State: closed - Opened by lukaseder about 1 year ago - 4 comments

#3909 - Maintenance taking too much resources since 2.2.222

Issue - State: closed - Opened by V0174 over 1 year ago - 39 comments

#3907 - MvStoreTool unable to Repair() or Rollback() [2.1.214]

Issue - State: closed - Opened by cgeesink over 1 year ago - 1 comment

#3894 - Race condition causing stale data in query last result cache

Issue - State: closed - Opened by pvlugter over 1 year ago - 1 comment

#3845 - ON CONFLICT DO NOTHING is expensive operation

Issue - State: open - Opened by pragmaxim over 1 year ago - 2 comments

#3843 - Run H2 Queries in browser

Issue - State: open - Opened by ryanhamilton over 1 year ago - 5 comments

#3815 - org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "DATA_SOURCE_PARAMETER.VALUE" not found

Issue - State: closed - Opened by droginin-re over 1 year ago - 1 comment

#3803 - Web console defaults empty after providing own .h2.server.properties

Issue - State: closed - Opened by thweiss over 1 year ago - 1 comment

#3802 - Cannot use value as column name in h2 2.x

Issue - State: closed - Opened by springland over 1 year ago - 5 comments

#3801 - Column "SYSTIMESTAMP" not found in Legacy / Oracle mode

Issue - State: closed - Opened by how4now over 1 year ago - 2 comments

#3799 - Function "UNNEST" not found; SQL statement: SELECT name, UNNEST(ARRAY[1, 2, 3]) FROM DEMO

Issue - State: closed - Opened by KramerIT over 1 year ago - 2 comments

#3798 - Registering an output parameter for a custom stored procedure call leads to an exception

Issue - State: closed - Opened by iwanzarembo almost 2 years ago - 9 comments

#3797 - MSSQL mode: Discard table hints on plain UPDATE statements

Pull Request - State: closed - Opened by sirlatrom almost 2 years ago - 1 comment

#3796 - Add Snowflake mode

Issue - State: open - Opened by OMMHOA almost 2 years ago

#3795 - How to Avoid the Impact of Changes in Numeric Keyword Between Versions on Decimal Precision？

Issue - State: closed - Opened by flippedZH almost 2 years ago - 1 comment

#3794 - Unexpected Timestamp offset when value is inserted by trigger

Issue - State: closed - Opened by cbvms123 almost 2 years ago - 1 comment

#3793 - Support for GROUP BY ROLLUP?

Issue - State: closed - Opened by rdehuyss almost 2 years ago - 2 comments

#3792 - Incompatibility in Oracle mode when comparing CHARs

Issue - State: open - Opened by hpoettker almost 2 years ago - 6 comments

#3791 - Formatted cast of datetimes to/from character strings

Pull Request - State: closed - Opened by katzyn almost 2 years ago - 1 comment

#3790 - Table not found when using with Mysql mode and liquibase

Issue - State: closed - Opened by sagarkbhatt almost 2 years ago - 1 comment

#3789 - Error using liquibase and ms sql server mode, found [uuid (Types#BINARY)], but expecting [uniqueidentifier default newid() (Types#VARCHAR)]

Issue - State: closed - Opened by hajjoujti almost 2 years ago - 1 comment

#3788 - TxDecisionMaker has been modified for READ_UNCOMMITTED Isolation Level

Pull Request - State: closed - Opened by fusunc almost 2 years ago - 3 comments

#3787 - Mysql alter table with after columnName syntax not supported

Issue - State: open - Opened by sagarkbhatt almost 2 years ago - 3 comments

#3786 - fix: CSV empty String to Number conversion

Pull Request - State: closed - Opened by manticore-projects almost 2 years ago - 1 comment

#3785 - CSVRead: Fails to translate empty Numbers, when cells are quoted

Issue - State: closed - Opened by manticore-projects almost 2 years ago - 7 comments

#3784 - Comparison between float and double columns

Issue - State: closed - Opened by abhioncbr almost 2 years ago - 2 comments

#3783 - USING throws error when joining more than two tables

Issue - State: open - Opened by nstanger almost 2 years ago - 7 comments

#3782 - JSON deserialization fails when using Hibernate

Issue - State: closed - Opened by thedatasnok almost 2 years ago - 2 comments

#3781 - Error Occurs When Inserting Data into Database Table with char(2) Field and check-constraints with Single Character

Issue - State: closed - Opened by TrueFanatiq almost 2 years ago - 1 comment

#3780 - java.lang.RuntimeException: Incompatible key type, expected org.h2.mvstore.db.RowDataType@8bb246fb but got org.h2.mvstore.db.RowDataType@8ba8df3d for index xxx

Issue - State: open - Opened by TsangChiCong almost 2 years ago - 2 comments

#3779 - H2 cannot resolve exist column when execute recursive CTE in sql server

Issue - State: closed - Opened by HaowanGeigei almost 2 years ago - 2 comments
Labels: WITH clause

#3778 - Script backup and restore with view

Issue - State: closed - Opened by OpenMessageCoder almost 2 years ago - 1 comment

#3777 - -webExternalNames in version 2.1.210 and upwards returns feature not supported

Issue - State: closed - Opened by RiceDefender almost 2 years ago - 1 comment

#3776 - org.h2.jdbc.JdbcSQLNonTransientConnectionException: File corrupted while reading record: "xxx/xxxx/gy_istsp_detect.mv.db". Possible solution: use the recovery tool [90030-214]

Issue - State: open - Opened by YearsAreEfas almost 2 years ago

#3775 - Does the file mode of the H2 database use the memory as the cache?

Issue - State: closed - Opened by ShiroNYami almost 2 years ago - 2 comments

#3774 - resolve vulnerability CVE-2022-45868

Issue - State: closed - Opened by zkhzkhz almost 2 years ago - 1 comment

#3773 - Please allow `AUTO_SERVER=TRUE` and `EXIT_ON_CLOSE=false` combination

Issue - State: closed - Opened by ilx almost 2 years ago - 3 comments

#3772 - StreamStore - DB File Growth

Issue - State: closed - Opened by nsnyder1992 almost 2 years ago - 1 comment

#3771 - NullPointerException when executing SHUTDOWN query

Issue - State: open - Opened by rpygithub almost 2 years ago - 2 comments

#3770 - Support `ALTER TYPE` in PostgreSQL mode

Issue - State: closed - Opened by dzikoysk almost 2 years ago - 5 comments

#3769 - Add support for returning statement in delete query

Issue - State: closed - Opened by nunocruz almost 2 years ago - 1 comment

#3768 - datatypes(varchar, numeric...) is supported in 1.4.200, but not supported in 2.1.214

Issue - State: closed - Opened by HaowanGeigei almost 2 years ago - 2 comments

#3767 - NullPointerException in MVStore background writer and blocked connections on INFORMATION_SCHEMA.SETTINGS

Issue - State: open - Opened by gabrieltifui almost 2 years ago - 2 comments

#3766 - Exception in thread "H2-lob-cleaner"

Issue - State: open - Opened by wburzyns almost 2 years ago - 2 comments

#3765 - MVStore.compactFile(int) changes table content

Issue - State: open - Opened by doggy-dev almost 2 years ago - 5 comments

#3764 - AssertionError in MVStore.closeStore(): oldestVersionToKeep.get() != currentVersion

Issue - State: open - Opened by katzyn almost 2 years ago - 2 comments

#3763 - Create some index conditions for comparisons with row values

Pull Request - State: closed - Opened by katzyn almost 2 years ago - 2 comments

#3762 - Comparison predicates with row values don't create index conditions

Issue - State: closed - Opened by nchrkgsd78324hkjds almost 2 years ago - 1 comment

#3761 - LAST_DAY function and other changes

Pull Request - State: closed - Opened by katzyn almost 2 years ago

#3760 - Restore START sequence option in PostgreSQL mode and improve documentation of MSSQLServer mode

Pull Request - State: closed - Opened by katzyn almost 2 years ago

#3759 - Improve support of time values in FORMATDATETIME function

Pull Request - State: closed - Opened by katzyn almost 2 years ago

#3758 - Random failure reading table metadata

Issue - State: closed - Opened by mwisnicki almost 2 years ago - 2 comments

#3757 - formatdatetime function doesn't handle time with time zone properly

Issue - State: closed - Opened by beikov almost 2 years ago

#3756 - Limit the row list allocation based on the row count

Pull Request - State: closed - Opened by franz1981 almost 2 years ago - 9 comments

#3755 - For persistent databases run INIT script only when DB is created

Issue - State: open - Opened by mwisnicki almost 2 years ago - 4 comments

#3754 - Compatibility mode should switch case preservation and insensitivity

Issue - State: open - Opened by mwisnicki almost 2 years ago - 3 comments

#3753 - Add missing NEWSEQUENTIALID function in MSSQLServer mode.

Pull Request - State: closed - Opened by mwisnicki almost 2 years ago - 2 comments

#3752 - UUID/uniqueidentifier column type behavior not compatible with MS SQL Server

Issue - State: open - Opened by mwisnicki almost 2 years ago - 5 comments

#3751 - Multiple Problems with DB Upgrade and BLOB issue in SQL

Issue - State: open - Opened by rzorzorzo almost 2 years ago - 2 comments

#3750 - Fixed #3730 Loading resource from jar should init the jar filesystem

Pull Request - State: closed - Opened by prodj17 almost 2 years ago - 2 comments

#3749 - Fix min/max description for sequences

Pull Request - State: closed - Opened by marcelstoer almost 2 years ago - 1 comment

#3748 - H2 version 1.4.199 and 1.4.200 giving error with date between operator.

Issue - State: closed - Opened by prabhatshankars almost 2 years ago - 3 comments

#3747 - Slow query execution when using IN (value1, value2...) even though UNION with individual = conditions works fine

Issue - State: open - Opened by ameyer3000 almost 2 years ago - 8 comments

#3746 - Data Type generated by Hibernate cannot be parsed by H2 driver

Issue - State: closed - Opened by H0W2 almost 2 years ago - 3 comments

#3745 - Disabling default escape character (`ESCAPE ''`) causes no results in Oracle compatibility mode

Issue - State: closed - Opened by Felk almost 2 years ago - 4 comments

#3744 - Slow WHERE clause on reasonable small FROM data frame

Issue - State: closed - Opened by manticore-projects almost 2 years ago - 20 comments

#3743 - H2 Recover not working - 1.4.200 - File corrupted while reading record: null. Possible solution: use the recovery tool [90030-200]

Issue - State: open - Opened by richardtan almost 2 years ago - 9 comments

#3742 - DB and BACKUP files size both increase when the DB contains CLOB and is read at the same time backups are being performed

Issue - State: open - Opened by pstdc almost 2 years ago - 2 comments

#3741 - With 2.X.X version "IN" is not working with charater(50) type of column.

Issue - State: closed - Opened by prabhatshankars almost 2 years ago - 4 comments

#3740 - The Db file size increasing comes from the query for ' CHARACTER LARGE OBJECT ' type data.

Issue - State: open - Opened by tdwu almost 2 years ago - 11 comments

#3739 - Fix count(*) for linked table to Oracle

Pull Request - State: closed - Opened by moonfruit almost 2 years ago - 1 comment

#3738 - The size of the db persistent file keeps increasing when querying

Issue - State: closed - Opened by tdwu almost 2 years ago - 4 comments

#3737 - Determine precision and scale of quotient in smarter way

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

#3736 - The PartitionBy clause fails if it contains a function call that yields a result different than the column value.

Issue - State: open - Opened by aprokopczyk about 2 years ago - 3 comments

#3735 - why is smallint mapped to integer and not to short as in the JDBC specification?

Issue - State: closed - Opened by edu-de about 2 years ago - 1 comment

GitHub / h2database/h2database issues and pull requests