diff options
Diffstat (limited to 'mysql-test/main/xa.result')
-rw-r--r-- | mysql-test/main/xa.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/main/xa.result b/mysql-test/main/xa.result index f02cb17b6ac..4717d51b09c 100644 --- a/mysql-test/main/xa.result +++ b/mysql-test/main/xa.result @@ -371,6 +371,32 @@ XA ROLLBACK 'xid'; DROP TABLE t1; disconnect con1; connection default; +# +# XA states and SHOW commands +# +create table t1 (pk int primary key) engine=innodb; +xa start 'foo'; +insert t1 set pk=1; +xa end 'foo'; +xa prepare 'foo'; +show status like 'foo'; +Variable_name Value +select table_name,table_comment from information_schema.tables where table_schema='test'; +table_name t1 +table_comment +select table_name,table_rows,table_comment from information_schema.tables where table_schema='test'; +table_name t1 +table_rows NULL +table_comment XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state +Warnings: +Level Warning +Code 1399 +Message XAER_RMFAIL: The command cannot be executed when global transaction is in the PREPARED state +xa commit 'foo'; +drop table t1; +# +# End of 10.2 tests +# XA BEGIN 'xid'; CREATE TEMPORARY SEQUENCE s; ERROR XAE07: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state |