diff options
author | Nayuta Yanagisawa <nayuta.yanagisawa@hey.com> | 2022-04-05 17:37:49 +0900 |
---|---|---|
committer | Nayuta Yanagisawa <nayuta.yanagisawa@hey.com> | 2022-04-14 23:31:15 +0900 |
commit | 3be8f66185c9b9d3c954c375208bcb873163603f (patch) | |
tree | 7d2d4185b3350fdb0cbf9202bb9023175bb5b6ba /storage/spider/mysql-test | |
parent | c235295525e6dfd0f209e554c3a2baa1115d3879 (diff) | |
download | mariadb-git-3be8f66185c9b9d3c954c375208bcb873163603f.tar.gz |
MDEV-28244 Deprecate spider_xa_register_mode
We deprecate the variable spider_xa_register_mode because there is
no need to perform a two phase commit for a read-only transaction.
Note that the variable only affects Spider's internal XA transactions.
Diffstat (limited to 'storage/spider/mysql-test')
-rw-r--r-- | storage/spider/mysql-test/spider/r/variable_deprecation.result | 7 | ||||
-rw-r--r-- | storage/spider/mysql-test/spider/t/variable_deprecation.test | 4 |
2 files changed, 11 insertions, 0 deletions
diff --git a/storage/spider/mysql-test/spider/r/variable_deprecation.result b/storage/spider/mysql-test/spider/r/variable_deprecation.result index 6d715d95b9f..06cd0d991f1 100644 --- a/storage/spider/mysql-test/spider/r/variable_deprecation.result +++ b/storage/spider/mysql-test/spider/r/variable_deprecation.result @@ -74,6 +74,13 @@ Warnings: Warning 1287 The table parameter 'internal_limit' is deprecated and will be removed in a future release DROP TABLE tbl_a; DROP TABLE tbl_b; +# MDEV-28244 Deprecate spider_xa_register_mode +SET spider_xa_register_mode = 0; +Warnings: +Warning 1287 '@@spider_xa_register_mode' is deprecated and will be removed in a future release +SHOW VARIABLES LIKE "spider_xa_register_mode"; +Variable_name Value +spider_xa_register_mode 0 DROP DATABASE auto_test_local; for master_1 for child2 diff --git a/storage/spider/mysql-test/spider/t/variable_deprecation.test b/storage/spider/mysql-test/spider/t/variable_deprecation.test index 8521f5595d1..9da3793d690 100644 --- a/storage/spider/mysql-test/spider/t/variable_deprecation.test +++ b/storage/spider/mysql-test/spider/t/variable_deprecation.test @@ -46,6 +46,10 @@ eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='internal_limit "1"'; DROP TABLE tbl_a; DROP TABLE tbl_b; +--echo # MDEV-28244 Deprecate spider_xa_register_mode +SET spider_xa_register_mode = 0; +SHOW VARIABLES LIKE "spider_xa_register_mode"; + DROP DATABASE auto_test_local; --disable_query_log |