diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-05-10 10:01:15 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-05-10 10:01:15 +0300 |
commit | 0e1437e147e8c7164600a0d352361c54c64eb12c (patch) | |
tree | d780b2f9e955e71e6d87424649ae11e93816cd90 /mysql-test/main/xa.result | |
parent | 35977e81f967ebe10db8ee40703801e693b2a0f4 (diff) | |
parent | 8c73fab7f7622b58062955fba5b5666643fa46a0 (diff) | |
download | mariadb-git-0e1437e147e8c7164600a0d352361c54c64eb12c.tar.gz |
Merge 10.4 into 10.5
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 46c0c8551a1..50089bb1d5e 100644 --- a/mysql-test/main/xa.result +++ b/mysql-test/main/xa.result @@ -429,6 +429,32 @@ XA ROLLBACK 'xid1'; # XA START 'gtrid', 'bqual', 0x80000000; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0x80000000' at line 1 +# +# 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 |