Evgenij Ryazanov

TestBtreeIndex: OOME in WriteBuffer.grow()

4

``` Test mvStore traceLevelFile defrag 14:14:52 00:00.413 org.h2.test.synth.TestBtreeIndex 14:14:52 testIndex -743195742 14:15:39 00:47.576 org.h2.test.synth.TestBtreeIndex FAIL org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.IllegalStateException: java.lang.OutOfMemoryError: Capacity: 4718592 [1.4.197/3]"; SQL statement: SELECT text FROM a ORDER...

AssertionError in TestTransactionStore.testConcurrentAdd()

2

``` Test utilities (22273 KB used) 02:55:05 00:00.535 org.h2.test.store.TestStreamStore 02:55:07 00:02.207 org.h2.test.store.TestTransactionStore 0 02:55:07 00:02.207 org.h2.test.store.TestTransactionStore FAIL java.lang.AssertionError: 0 ERROR: FAIL (memory ) java.lang.AssertionError: 0 java.lang.AssertionError: 0 ------------------------------ java.lang.AssertionError: 0...

Deadlock in TestCrashAPI.getConnection()

1

``` Test memory (1745 KB used) … app//org.h2.test.TestAll.testAll(TestAll.java:550) app//org.h2.test.TestAll.run(TestAll.java:491) app//org.h2.test.TestAll.main(TestAll.java:435) test watchdog timed out "main" Id=1 in RUNNABLE at app//org.h2.mvstore.tx.TransactionMap.set(TransactionMap.java:381) at app//org.h2.mvstore.tx.TransactionMap.putIfAbsent(TransactionMap.java:281) at app//org.h2.mvstore.db.MVPrimaryIndex.add(MVPrimaryIndex.java:113) at app//org.h2.mvstore.db.MVTable.addRow(MVTable.java:519) at app//org.h2.command.dml.Insert.insertRows(Insert.java:174) at app//org.h2.command.dml.Insert.update(Insert.java:135)...

SQLInvalidAuthorizationSpecException in TestMultiThreadedKernel

3

An unusual random failure in current master on Java 10: ``` 13:52:01 00:00.001 org.h2.test.db.TestMultiThreadedKernel FAIL org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-197] ERROR: FAIL (mvStore AES SOFT_LRU diskUndo diskResult traceLevelFile...

TestConcurrentJdbc: NPE in JdbcPreparedStatement

3

``` 14:49:34 00:00.180 org.h2.test.unit.TestConcurrentJdbc FAIL org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.NullPointerException" [50000-200] ------------------------------ org.h2.jdbc.JdbcSQLNonTransientException: General error: "java.lang.NullPointerException" [50000-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:511) at org.h2.message.DbException.getJdbcSQLException(DbException.java:435) at org.h2.message.DbException.get(DbException.java:189) at org.h2.message.DbException.convert(DbException.java:353) at org.h2.message.DbException.toSQLException(DbException.java:325) at org.h2.message.TraceObject.logAndConvert(TraceObject.java:366) at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:251)...

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

2

``` Test (23519 KB used) 12:48:58 00:01.254 org.h2.test.db.TestOptimizations FAIL java.sql.SQLException: GeneralError ERROR: FAIL () java.sql.SQLException: GeneralError java.sql.SQLException: GeneralError ------------------------------ java.sql.SQLException: GeneralError at org.h2.message.DbException.convert(DbException.java:412) at org.h2.message.DbException.toSQLException(DbException.java:379) at org.h2.message.TraceObject.logAndConvert(TraceObject.java:365) at org.h2.jdbc.JdbcConnection.close(JdbcConnection.java:368) at...

Table value constructor output contains unnecessary queries

3

The translate tool generates overcomplicated SQL for the table value constructor. Source ```SQL VALUES (1, 2); ``` Output for DB2 and PostgreSQL: ```SQL select v.c1, v.c2 from (values(1, 2)) as...

The SQL Standard requires `DECFLOAT` result with implementation-defined precision for trigonometric, power, square root and logarithm function at least one of their arguments has a `DECFLOAT` data type and implementation-defined...

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

1

```SQL CREATE TABLE A(A1 INTEGER, A2 INTEGER); > ok INSERT INTO A VALUES (1, 2); > update count: 2 CREATE TABLE B(B1 INTEGER); > ok ALTER TABLE A ALTER COLUMN...