i apologize for being ignorant and poor sql skills here...
I'm trying to do the following:
DROP TABLE TEST;
CREATE TABLE TEST(ID NUMERIC(15) NOT NULL);
insert into test values (1);
savepoint test_savepoint;
insert into test values (2);
rollback to savepoint test_savepoint;
select * from test;
and it doesn't work.
well, it does, but the "rollback to savepoint" does not. so I
permanently have two rows.
I am using an old H2 (1.3.153) at the moment, no particular reason
except that I have a couple of older databases, and I haven't "upgraded"
them. (one is deployed on the web and is a little harder to upgrade than
I'd like)
does this really not work?
I'm trying to do some tests re bulk transactions...
related:
rollback transaction <name>
where does that <name> come from? I was sort of expecting to see
something like
begin transaction <foo>
so I could use
rollback transaction <foo>
or
commit transaction <foo>
-- clint
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
