2
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
8
PARTITION BY RANGE (id)
10
PARTITION p1 VALUES LESS THAN (2),
11
PARTITION p2 VALUES LESS THAN (4),
12
PARTITION p3 VALUES LESS THAN (10)
14
INSERT INTO t1 VALUES (1),(2),(3);
15
# Test READ COMMITTED -> REPEATABLE READ
17
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
25
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
27
INSERT INTO t1 VALUES(7);
32
# Test REPEATABLE READ -> READ COMMITTED
33
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
42
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
44
INSERT INTO t1 VALUES(9);
45
ERROR HY000: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'