1
--source include/have_partition.inc
2
--source include/have_binlog_format_statement.inc
3
--source include/have_innodb.inc
5
--echo # connection default
6
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
13
PARTITION BY RANGE (id)
15
PARTITION p1 VALUES LESS THAN (2),
16
PARTITION p2 VALUES LESS THAN (4),
17
PARTITION p3 VALUES LESS THAN (10)
20
INSERT INTO t1 VALUES (1),(2),(3);
22
--echo # Test READ COMMITTED -> REPEATABLE READ
24
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
28
connect (con1, localhost, root,,);
31
--echo #connection con1
32
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
34
INSERT INTO t1 VALUES(7);
38
--echo # connection default
43
--echo # Test REPEATABLE READ -> READ COMMITTED
44
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
50
--echo # connection con1
51
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
53
--error ER_BINLOG_LOGGING_IMPOSSIBLE
54
INSERT INTO t1 VALUES(9);