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
COMMIT;

query I
SELECT * from kanto.myschema.mytable;
----
42