Evgenij Ryazanov

An unusual failure on CI: ``` java.lang.AssertionError: i: 18 at org.h2.test.TestBase.fail(TestBase.java:332) at org.h2.test.TestBase.assertNotNull(TestBase.java:876) at org.h2.test.store.TestCacheLongKeyLIRS.testScanResistance(TestCacheLongKeyLIRS.java:401) at org.h2.test.store.TestCacheLongKeyLIRS.testCache(TestCacheLongKeyLIRS.java:45) at org.h2.test.store.TestCacheLongKeyLIRS.test(TestCacheLongKeyLIRS.java:32) ``` https://github.com/h2database/h2database/blob/45b609dec0e45125e6a93f85c9018d34551332a1/h2/src/test/org/h2/test/store/TestCacheLongKeyLIRS.java#L397-L405

H2 partially supports the identity columns from the Standard. There are some incompatibilities: - [x] H2 converts them to a plain columns with `DEFAULT` expression; but their identity status should...

``` test watchdog timed out "Timer-404" Id=18149 in RUNNABLE at sun.management.ThreadImpl.dumpThreads0(Native Method) at sun.management.ThreadImpl.getThreadInfo(ThreadImpl.java:461) at org.h2.util.ThreadDeadlockDetector.dumpThreadsAndLocks(ThreadDeadlockDetector.java:116) at org.h2.util.ThreadDeadlockDetector.dumpAllThreadsAndLocks(ThreadDeadlockDetector.java:90) at org.h2.util.ThreadDeadlockDetector.dumpAllThreadsAndLocks(ThreadDeadlockDetector.java:78) at org.h2.test.TestAll$1.run(TestAll.java:982) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Locked synchronizers: count =...

``` test watchdog timed out "main" Id=1 in WAITING on lock=java.lang.Thread@37b4c297 at [email protected]/java.lang.Object.wait(Native Method) at [email protected]/java.lang.Thread.join(Thread.java:1300) at [email protected]/java.lang.Thread.join(Thread.java:1375) at app//org.h2.util.Task.join(Task.java:120) at app//org.h2.util.Task.getException(Task.java:103) at app//org.h2.util.Task.get(Task.java:81) at app//org.h2.test.server.TestWeb.testStartWebServerWithConnection(TestWeb.java:573) at app//org.h2.test.server.TestWeb.test(TestWeb.java:76) "Timer-111" Id=4403...

``` org.h2.test.synth.TestKillRestart 14:05:56 killing: 0 org.h2.test.synth.TestKillRestart Expected: #..., got: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "TEST_META" already exists; SQL statement: org.h2.test.synth.TestKillRestart FAIL java.lang.AssertionError: Expected: #..., got: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "TEST_META" already exists; SQL statement: ERROR:...

MVStoreException: Map tempLobMap(7) is closed in LobStorageMap.doRemoveLob()

3

I'm not sure where it came from, most likely from `TestPowerOff `, but exceptions from other threads can be logged out of order: ``` Test AES SOFT_LRU diskUndo diskResult traceLevelFile...

AssertionError in mvstore.FileStore.serializeAndStore

1

Current `master` with small unrelated change: ``` Test utilities (23905 KB used) 01:09:20 00:00.817 org.h2.test.store.TestMVStore FAIL java.lang.AssertionError: Expected an SQLException or DbException with error code 4, but got a org.h2.mvstore.MVStoreException...

CREATE TABLE AS and empty strings

4

```SQL CREATE TABLE TEST AS SELECT '', X''; ``` creates a table with two invalid columns: ```SQL CREATE CACHED TABLE "PUBLIC"."TEST"( "''" CHARACTER VARYING(0), "X''" BINARY VARYING(0) ) ``` String...

TestAll (test.db.TestMultiThread): Map tempLobMap(7) is closed

2

``` Test (25139 KB used) ..... 12:45:35 00:14.029 org.h2.test.db.TestMultiThread Exception in thread "H2-lob-cleaner" org.h2.mvstore.MVStoreException: Map tempLobMap(7) is closed. null [2.2.219/4] at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1003) at org.h2.mvstore.MVMap.beforeWrite(MVMap.java:962) at org.h2.mvstore.MVMap.operate(MVMap.java:1757) at org.h2.mvstore.MVMap.remove(MVMap.java:518) at org.h2.mvstore.db.LobStorageMap.doRemoveLob(LobStorageMap.java:460)...

DROP ALL OBJECTS doesn't drop local temporary tables

1

```SQL CREATE LOCAL TEMPORARY TABLE T1(ID BIGINT PRIMARY KEY); INSERT INTO T1 VALUES 1, 2; DROP ALL OBJECTS; TABLE T1; > ID > -- > 1 > 2 ``` I...