| 1 |
select @default_binlog_format:=@@global.binlog_format; |
| 2 |
@default_binlog_format:=@@global.binlog_format |
| 3 |
MIXED |
| 4 |
set global binlog_format=row; |
| 5 |
connect con1,localhost,root,,; |
| 6 |
connect con2,localhost,root,,; |
| 7 |
connection con1; |
| 8 |
set session debug_dbug="+d,optimizer_innodb_ds_mrr"; |
| 9 |
set autocommit=0; |
| 10 |
use test; |
| 11 |
drop table if exists t1; |
| 12 |
Warnings: |
| 13 |
Note 1051 Unknown table 'test.t1' |
| 14 |
create table t1 (dummy int primary key, a int unique, b int) engine=innodb; |
| 15 |
insert into t1 values(1,1,1),(3,3,3),(5,5,5); |
| 16 |
commit; |
| 17 |
set session transaction isolation level repeatable read; |
| 18 |
select @@transaction_isolation; |
| 19 |
@@transaction_isolation |
| 20 |
REPEATABLE-READ |
| 21 |
start transaction; |
| 22 |
select * from t1 where a > 2 for update; |
| 23 |
dummy a b |
| 24 |
3 3 3 |
| 25 |
5 5 5 |
| 26 |
connection con2; |
| 27 |
use test; |
| 28 |
set autocommit=0; |
| 29 |
start transaction; |
| 30 |
select 1; |
| 31 |
1 |
| 32 |
1 |
| 33 |
insert into t1 values(2,2,2); |
| 34 |
ERROR HY000: Lock wait timeout exceeded; try restarting transaction |
| 35 |
rollback; |
| 36 |
connection con1; |
| 37 |
rollback; |
| 38 |
drop table t1; |
| 39 |
connection default; |
| 40 |
set global binlog_format=@default_binlog_format; |