hi i have modified the way rollback commands are determined to cater for this sort of case.
please replace your eq.jar file in your install directory for Execute Query with the one here: http://executequery.org/temp/latest/eq.jar it will also be included as a part of the next release from the normal bundles. let me know of any issues. thanks :) Takis On Tuesday, April 12, 2016 at 12:32:49 AM UTC+10, Niko Paltzer wrote: > > Hi, > > please consider the following example: > > > 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; > > > If I execute it with the H2 console, I get the expected result: One row > with value 1. > > If I execute the same snippet with Execute Query (www.executequery.org), > using org.h2.Driver from h2-1.3.176.jar (h2.1.4.191.jar resp.), then the > result is empty. > > I disabled auto-commit in both cases. > > Do you have any idea why this difference occurs? > > Thanks a lot! > > Best, Niko Paltzer > -- 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.
