[h2] Re: V 1.4.200 LAST_INSERT_ID() don't work

Ah, ok. Thank you very much for the detailed answer! Evgenij Ryazanov schrieb am Mittwoch, 8. Dezember 2021 um 01:33:17 UTC+1: > Hello. > > This function is a part of MSSQLServer compatibility mode and is not > available in other modes anymore. > > For identity columns In Regular mode you need t

Re: [h2] DB regression when exiting with SHUTDOWN COMPACT?

Hi all, Thank you Andreas for confirming. This is strange... With h2 version 1.4.200, although having the size creep, the database file ended up well formed and a posterior re-connection allowed DML changes on data... BR, Ivan On Thursday, December 9, 2021 at 3:09:42 PM UTC+1 and...@mantic

Re: [h2] DB regression when exiting with SHUTDOWN COMPACT?

Greetings! Unfortunately, this seems to be a kind of normal: As long as the DB is running, it will keep "leaking" file space . Our virgin 2 GByte DB grew to 400 GB eventually, after running for months. "Shutdown defrag" frees a lot of the claimed file space, but not all and it depends on a restart

[h2] DB regression when exiting with SHUTDOWN COMPACT?

Hi all, Creating a medium sized database (300MB with 800MB disk usage) and then exiting with SHUTDOWN COMPACT makes the database read-only, making impossible to modify the data via DML commands. I tried opening the DB in read-write mode in the connection string using ACCESS_MODE_DATA without s