16 lines
317 B
Text
16 lines
317 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 (42);
|
|
|
|
statement ok
|
|
ROLLBACK;
|
|
|
|
query I
|
|
SELECT count(*) from kanto.myschema.mytable;
|
|
----
|
|
0
|