statement ok
CREATE TABLE myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn));

statement ok
START TRANSACTION ISOLATION LEVEL REPEATABLE READ;

statement ok
INSERT INTO kanto.myschema.mytable (mycolumn) VALUES (1);

statement ok
SAVEPOINT one

statement ok
INSERT INTO kanto.myschema.mytable (mycolumn) VALUES (2);

statement ok
SAVEPOINT one

statement ok
INSERT INTO kanto.myschema.mytable (mycolumn) VALUES (3);

query I
SELECT * from kanto.myschema.mytable ORDER BY mycolumn ASC;
----
1
2
3

statement ok
ROLLBACK TO SAVEPOINT one;

query I
SELECT * from kanto.myschema.mytable ORDER BY mycolumn ASC;
----
1
2

statement ok
ROLLBACK TO SAVEPOINT one;

query I
SELECT * from kanto.myschema.mytable ORDER BY mycolumn ASC;
----
1

statement ok
ROLLBACK;

query I
SELECT count(*) from kanto.myschema.mytable;
----
0