blob: ac1e99c932a8bcc5fbdaad6605d16e3749dc1457 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
set tokudb_enable_fast_update=1;
set session sql_mode=(select replace(@@sql_mode,'STRICT_TRANS_TABLES',''));
set session sql_mode=(select replace(@@sql_mode,'STRICT_ALL_TABLES',''));
create table t (id bigint primary key,
b bigint not null default 0) engine = tokudb;
insert into t (id) values (1),(2);
set tokudb_enable_fast_update=1;
set session sql_mode=(select replace(@@sql_mode,'STRICT_TRANS_TABLES',''));
set session sql_mode=(select replace(@@sql_mode,'STRICT_ALL_TABLES',''));
begin;
update t set b=b+1 where id=1;
begin;
update t set b=b-1 where id=2;
update t set b=b+1 where id=2;
update t set b=b-1 where id=1;
Got one of the listed errors
rollback;
commit;
select * from t;
id b
1 1
2 1
drop table t;
|