Andrei Tokar

I do not think any progress is going to happen here without a standalone reproducible test case

Sure, I can try. Actually, I did same exact exercise two years ago when I was playing with compact representation for native values and db rows backed by generated classes....

@svladykin, yes it is good to be wealthy and healthy, but in reality data is mutable and we need rows as separate entities. How do you grow / shrink your...

I also fail to understand how renaming and moving stuff around will reduce “smells”. And what it is, anyway? If you would state some clear goal of such refactoring, like...

But the question is - what TRUNCATE(TIMESTAMP WITH TIMEZONE) should do? Since timezone offset changes at 2am, midnight still have and old offset, but source timestamp has a new one....

Can you be sure that exception above is not a result of out-of-heap memory exhaustion? What is the value of -XX:MaxDirectMemorySize and what is amount of data? How connection URL...

``` 4:14:00 00:03.790 org.h2.test.synth.TestKillRestartMulti FAIL org.h2.jdbc.JdbcSQLSyntaxErrorException: Sequence "SYSTEM_SEQUENCE_748E9BF6_91FA_426A_8727_55166D3724F0" not found; SQL statement: CREATE CACHED TABLE PUBLIC.TEST5( ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_748E9BF6_91FA_426A_8727_55166D3724F0) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_748E9BF6_91FA_426A_8727_55166D3724F0, NAME VARCHAR...

And again: ``` 02:12:26 00:03.336 org.h2.test.synth.TestKillRestartMulti FAIL org.h2.jdbc.JdbcSQLSyntaxErrorException: Sequence "SYSTEM_SEQUENCE_415D86AA_B2B0_4666_8D8F_F12B4E054D32" not found; SQL statement: CREATE CACHED TABLE PUBLIC.TEST6( ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_415D86AA_B2B0_4666_8D8F_F12B4E054D32) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_415D86AA_B2B0_4666_8D8F_F12B4E054D32,...

And the main drawback of multiple storages would be the fact that "dirty set" (data to be written) becomes partitioned too. So it is either longer periods between writes (and...

Yes, COMPACT is now a synonym for DEFRAG, they used to mean different things in the past. I can see that this command was broken (only) for **encrypted** databases, since...