diff options
Diffstat (limited to 'storage/tokudb/mysql-test/suite/tokudb.bugs/r/xa.result')
-rw-r--r-- | storage/tokudb/mysql-test/suite/tokudb.bugs/r/xa.result | 135 |
1 files changed, 0 insertions, 135 deletions
diff --git a/storage/tokudb/mysql-test/suite/tokudb.bugs/r/xa.result b/storage/tokudb/mysql-test/suite/tokudb.bugs/r/xa.result deleted file mode 100644 index 457c5543f8c..00000000000 --- a/storage/tokudb/mysql-test/suite/tokudb.bugs/r/xa.result +++ /dev/null @@ -1,135 +0,0 @@ -drop table if exists t1, t2; -create table t1 (a int) engine=tokudb; -xa start 'test1'; -insert t1 values (10); -xa end 'test1'; -xa prepare 'test1'; -xa rollback 'test1'; -select * from t1; -a -xa start 'test2'; -xa start 'test-bad'; -ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state -insert t1 values (20); -xa prepare 'test2'; -ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state -xa end 'test2'; -xa prepare 'test2'; -xa commit 'test2'; -select * from t1; -a -20 -xa start 'testa','testb'; -insert t1 values (30); -commit; -ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state -xa end 'testa','testb'; -begin; -ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state -create table t2 (a int); -ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the IDLE state -xa start 'testa','testb'; -ERROR XAE08: XAER_DUPID: The XID already exists -xa start 'testa','testb', 123; -ERROR XAE08: XAER_DUPID: The XID already exists -xa start 0x7465737462, 0x2030405060, 0xb; -insert t1 values (40); -xa end 'testb',' 0@P`',11; -xa prepare 'testb',0x2030405060,11; -start transaction; -ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state -xa recover; -formatID gtrid_length bqual_length data -11 5 5 testb 0@P` -xa prepare 'testa','testb'; -xa recover; -formatID gtrid_length bqual_length data -11 5 5 testb 0@P` -1 5 5 testatestb -xa commit 'testb',0x2030405060,11; -ERROR XAE04: XAER_NOTA: Unknown XID -xa rollback 'testa','testb'; -xa start 'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz'; -ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 -xa rollback 'testb',0x2030405060,11; -select * from t1; -a -20 -drop table t1; -drop table if exists t1; -create table t1(a int, b int, c varchar(20), primary key(a)) engine = tokudb; -insert into t1 values(1, 1, 'a'); -insert into t1 values(2, 2, 'b'); -xa start 'a','b'; -update t1 set c = 'aa' where a = 1; -xa start 'a','c'; -update t1 set c = 'bb' where a = 2; -update t1 set c = 'bb' where a = 2; -update t1 set c = 'aa' where a = 1; -ERROR 40001: Deadlock found when trying to get lock; try restarting transaction -select count(*) from t1; -count(*) -2 -xa end 'a','c'; -xa rollback 'a','c'; -xa start 'a','c'; -xa end 'a','b'; -xa rollback 'a','b'; -drop table t1; -# -# BUG#51342 - more xid crashing -# -CREATE TABLE t1(a INT) ENGINE=TokuDB; -XA START 'x'; -SET SESSION autocommit=0; -INSERT INTO t1 VALUES(1); -SET SESSION autocommit=1; -ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state -SELECT @@autocommit; -@@autocommit -0 -INSERT INTO t1 VALUES(1); -XA END 'x'; -XA COMMIT 'x' ONE PHASE; -DROP TABLE t1; -SET SESSION autocommit=1; -End of 5.0 tests -xa start 'a'; -xa end 'a'; -xa rollback 'a'; -xa start 'a'; -xa end 'a'; -xa rollback 'a'; -xa start 'a'; -xa end 'a'; -xa prepare 'a'; -xa commit 'a'; -xa start 'a'; -xa end 'a'; -xa prepare 'a'; -xa commit 'a'; -CREATE TABLE t1(a INT, KEY(a)) ENGINE=TokuDB; -INSERT INTO t1 VALUES(1),(2); -BEGIN; -UPDATE t1 SET a=3 WHERE a=1; -BEGIN; -UPDATE t1 SET a=4 WHERE a=2; -UPDATE t1 SET a=5 WHERE a=2; -UPDATE t1 SET a=5 WHERE a=1; -ERROR 40001: Deadlock found when trying to get lock; try restarting transaction -ROLLBACK; -ROLLBACK; -BEGIN; -UPDATE t1 SET a=3 WHERE a=1; -XA START 'xid1'; -UPDATE t1 SET a=4 WHERE a=2; -UPDATE t1 SET a=5 WHERE a=2; -UPDATE t1 SET a=5 WHERE a=1; -ERROR 40001: Deadlock found when trying to get lock; try restarting transaction -XA END 'xid1'; -XA ROLLBACK 'xid1'; -XA START 'xid1'; -XA END 'xid1'; -XA ROLLBACK 'xid1'; -commit; -DROP TABLE t1; |