Hi there
Do real nested transactions exist in H2?
For example:
(Running in H2 console, auto-commit checkbox OFF):
set lock_mode 1;
select * from test;
begin;
select * from test;
begin;
insert into test (value) values ('hello');
commit;
select * from test;
rollback;
select * from test;
This is adding rows to my 'test' table. The inner trans is being committed,
although it is a second-level transaction, and the first level being
rollbacked.
I'm sure this is easily explained.
Thanks
Rich
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/cb3c9ad3-5cd5-4e18-9875-e2372b53c71c%40googlegroups.com.
