1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
-- source include/have_tokudb.inc
--disable_warnings
drop table if exists t1;
--enable_warnings
# test that simple xa commands work with TokuDB
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=tokudb;
xa begin 'a','ab';
insert into t1 values (1);
select * from t1;
xa end 'a','ab';
#select * from t1;
xa prepare 'a','ab';
#select * from t1;
xa commit 'a','ab';
select * from t1;
xa begin 'a','ab';
insert into t1 values (2);
select * from t1;
xa end 'a','ab';
#select * from t1;
xa prepare 'a','ab';
#select * from t1;
xa rollback 'a','ab';
select * from t1;
drop table t1;
|