blob: 1357c30b22d404f879cc90578853e5e2b43a49d7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
SET DEFAULT_STORAGE_ENGINE='tokudb';
drop table if exists t;
create table t (a int primary key, b int);
insert into t values (1,0),(2,1),(3,0);
begin;
update t set b=b+1 where b>0;
set transaction isolation level serializable;
select * from t where a!=2;
commit;
a b
1 0
3 0
drop table t;
|