[h2] Re: generated keys are "cleared" inside of Session during INSERT (to the table with AUTOINCREMENT column) when there is a trigger (Java code, obviously) that does another INSERT (to different tab

2019-06-14 Thread Vitali
I was working with codebase of few months old where described issue was faced. As we are maintaining some large projects with H2 as spatial embedded database , we build customized releases from source code from time to time. I took latest codebase and tested in the morning. I should

[h2] Re: generated keys are "cleared" inside of Session during INSERT (to the table with AUTOINCREMENT column) when there is a trigger (Java code, obviously) that does another INSERT (to different tab

2019-06-13 Thread Evgenij Ryazanov
Hello. No, it's not a TODO. It's a comment why the conditions below are necessary. Nested DML commands weren't not supported. However, the current implementation is entirely different and hypothetically it should work in your use case. You can build H2 from the sources and test it with your