blob: eee908002860a5efb1eb8163136a43a9f642f8ff (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
drop table if exists t1;
SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
CREATE TABLE t1(a int);
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
INSERT INTO t1 VALUES(1);
select * from t1;
ERROR HY000: MyRocks supports only READ COMMITTED and REPEATABLE READ isolation levels. Please change from current isolation level SERIALIZABLE
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
select * from t1;
a
1
drop table t1;
|