52 lines
832 B
Text
52 lines
832 B
Text
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
|