--
-- ### Transaction checks
--

create table t1 ( a int, b string(30));

start transaction;
insert into t1 values ( 1, 'xxx');
insert into t1 values ( 2, 'yyy');
insert into t1 values ( 3, 'zzz');
commit;

start transaction;
insert into t1 values ( 4, 'Iwan');
insert into t1 values ( 5, 'Hugo');
insert into t1 values ( 6, 'Ida');
rollback;

select * from t1;

start transaction;
insert into t1 values ( 4, 'Iwan');
insert into t1 values ( 5, 'Hugo');
insert into t1 values ( 6, 'Ida');
commit;


drop table t1;
