Evgenij Ryazanov

ARRAY data type and non-Object[] arrays in JDBC

6

H2 historically had an array data type without base data type. With recent changes H2 has optional base data type. On the JDBC level ARRAY data type is mapped to...

``` 00:43:26 00:25.560 org.h2.test.synth.TestCrashAPI 00:43:26 seed: 697702230 ERROR: new TestCrashAPI().init(test).testCase(697702230); // Bug 399042866 id=771 callCount=757 openCount=7 General error: "java.lang.NullPointerException" [50000-219] org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.NullPointerException" [50000-219] ------------------------------ org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.NullPointerException"...

Rename package to com.h2database?

7

H2 already uses `com.h2database` as library name in various places, but all code is still located in `org.h2` package and subpackages. The next release is a major release with many...

Representation of rows

12

H2 uses the following ways to represent a row: 1. `Value[]` (almost everywhere). 2. `SearchRow` (indexes), has different implementations to save some memory. 3. `Row` (tables, triggers, DML), has only...

TestDiskFull: General error

2

An unusual failure on CI: ``` Test memory 14:24:44 00:01.041 org.h2.test.synth.TestDiskFull FAIL org.h2.jdbc.JdbcSQLNonTransientException: General error: "General error: ""org.h2.mvstore.MVStoreException: Writing to unstable:unstable:memFS:/diskFull30.mv.db failed; length 16384 at 16384 [2.2.219/2]"" [50000-219]" [50000-219] ERROR:...

CSVREAD can't be used with parameter

4

```Java conn.prepareStatement("SELECT * FROM CSVREAD(?)"); ``` ``` Exception in thread "main" org.h2.jdbc.JdbcSQLDataException: Parameter "fileName" is not set; SQL statement: SELECT * FROM CSVREAD(?) [90012-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:602) at org.h2.message.DbException.getJdbcSQLException(DbException.java:435) at org.h2.message.DbException.get(DbException.java:200)...

Planned date for migration to Java 11

8

Premier support of Java 8 ends in March 2022: https://www.oracle.com/java/technologies/java-se-support-roadmap.html Non-LTS Java 9 and Java 10 aren't supported since 2018 and the next LTS release is 11. State of our...

Code completion and some BNF tests don't accept correct BNF of table references

3

Some zero day bugs in the parser were fixed and grammar in our documentation also needs to be fixed, because it describes various clauses incorrectly. Unfortunately, corrected definitions immediately break...

TestCrashAPI: AssertionError: map with id 12 is missing during initialization

1

An unusual CI failure: ``` Test AES SOFT_LRU diskUndo diskResult traceLevelFile throttle:1 ERROR: new TestCrashAPI().init(test).testCase(218194067); // Bug 160803166 id=-480 callCount=465 openCount=8 GeneralError java.sql.SQLException: GeneralError ------------------------------ java.sql.SQLException: GeneralError at org.h2.message.DbException.convert(DbException.java:419) at...

Random failures in TestKillRestartMulti

6

TestKillRestartMulti sometimes (rarely) fails with the same error: org.h2.jdbc.JdbcSQLException: Sequence "SYSTEM_SEQUENCE_69FED0AD_BC1F_42BF_8D9C_D7EF3DD9CFF1" not found; SQL statement: ```SQL CREATE CACHED TABLE PUBLIC.TEST5( ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_69FED0AD_BC1F_42BF_8D9C_D7EF3DD9CFF1) NOT NULL NULL_TO_DEFAULT...