blob: 192d32d9a95e345e746f4e19207d03d5d61634db (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
drop table if exists t;
set default_storage_engine='tokudb';
create table t (id bigint primary key, b bigint not null default 0);
begin;
insert noar into t (id) values (1) on duplicate key update b=b+1;
begin;
insert noar into t (id) values (2) on duplicate key update b=b-1;
insert noar into t (id) values (2) on duplicate key update b=b+1;
insert noar into t (id) values (1) on duplicate key update b=b-1;
Got one of the listed errors
rollback;
commit;
select * from t;
id b
1 0
2 0
drop table t;
|