Hi, Not sure about version 1.3.153, but with a current version of H2, I get, depending on autocommit enabled or not:
Autocommit enabled: rollback to savepoint test_savepoint; Savepoint is invalid: "TEST_SAVEPOINT"; SQL statement: rollback to savepoint test_savepoint [90063-192] 90063/90063 Autocommit disabled: select returns only one row. Regards, Thomas On Wednesday, June 8, 2016, Clint Hyde <[email protected]> wrote: > 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. > -- 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.
