blob: 3ed8dcf5ec65f2c049a03355bd016a0a0514a336 (
plain)
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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
--echo #
--echo # MDEV-27228 Deprecate Spider plugin variables that result in excessive tweak
--echo #
--disable_query_log
--disable_result_log
--source test_init.inc
--enable_result_log
--enable_query_log
--connection master_1
CREATE DATABASE auto_test_local;
USE auto_test_local;
--echo # MDEV-28297 Deprecate spider_internal_offset
SET spider_internal_offset = 1;
SHOW VARIABLES LIKE "spider_internal_offset";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='ios "1"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='internal_offset "1"';
DROP TABLE tbl_a;
DROP TABLE tbl_b;
--echo # MDEV-27981 Deprecate spider_internal_limit
SET spider_internal_limit = 1;
SHOW VARIABLES LIKE "spider_internal_limit";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='ilm "1"';
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";
--echo # MDEV-28007 Deprecate Spider plugin variables regarding statistics persistence
SET GLOBAL spider_store_last_sts = 0;
SHOW VARIABLES LIKE "spider_store_last_sts";
SET GLOBAL spider_store_last_crd = 0;
SHOW VARIABLES LIKE "spider_store_last_crd";
SET GLOBAL spider_load_sts_at_startup = 0;
SHOW VARIABLES LIKE "spider_load_sts_at_startup";
SET GLOBAL spider_load_crd_at_startup = 0;
SHOW VARIABLES LIKE "spider_load_crd_at_startup";
DROP TABLE tbl_a;
DROP TABLE tbl_b;
--echo # MDEV-28008 Deprecate spider_crd_mode and spider_sts_mode
SET spider_crd_mode = 1;
SHOW VARIABLES LIKE "spider_crd_mode";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='cmd "3"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='crd_mode "3"';
DROP TABLE tbl_a;
DROP TABLE tbl_b;
SET spider_sts_mode = 1;
SHOW VARIABLES LIKE "spider_sts_mode";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='smd "3"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='sts_mode "3"';
DROP TABLE tbl_a;
DROP TABLE tbl_b;
--echo # MDEV-28010 Deprecate spider_crd_type and spider_crd_weight
SET spider_crd_type = 1;
SHOW VARIABLES LIKE "spider_crd_type";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='ctp "1"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='crd_type "1"';
DROP TABLE tbl_a;
DROP TABLE tbl_b;
SET spider_crd_weight = 1;
SHOW VARIABLES LIKE "spider_crd_weight";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='cwg "1"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='crd_weight "1"';
DROP TABLE tbl_a;
DROP TABLE tbl_b;
--echo # MDEV-28560 Deprecate spider_buffer_size
SET spider_buffer_size = 1;
SHOW VARIABLES LIKE "spider_buffer_size";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='bfz "1"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='buffer_size "1"';
DROP TABLE tbl_a;
DROP TABLE tbl_b;
--echo # MDEV-27926 Deprecate spider_init_sql_alloc_size
SET spider_init_sql_alloc_size = 1;
SHOW VARIABLES LIKE "spider_init_sql_alloc_size";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='isa "1"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='init_sql_alloc_size "1"';
DROP TABLE tbl_a;
DROP TABLE tbl_b;
--echo # MDEV-28829 Deprecate spider_semi_table_lock and spider_semi_table_lock_connection
SET spider_semi_table_lock = 1;
SHOW VARIABLES LIKE "spider_semi_table_lock";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='stl "1"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='semi_table_lock "1"';
DROP TABLE tbl_a;
DROP TABLE tbl_b;
SET spider_semi_table_lock_connection = 0;
SHOW VARIABLES LIKE "spider_semi_table_lock_connection";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='stc "0"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='semi_table_lock_connection "0"';
DROP TABLE tbl_a;
DROP TABLE tbl_b;
--echo # MDEV-28795 Deprecate spider_bka_table_name_type
SET spider_bka_table_name_type = 1;
SHOW VARIABLES LIKE "spider_bka_table_name_type";
eval CREATE TABLE tbl_a (a INT) $MASTER_1_ENGINE COMMENT='btt "1"';
eval CREATE TABLE tbl_b (a INT) $MASTER_1_ENGINE COMMENT='bka_table_name_type "1"';
DROP TABLE tbl_a;
DROP TABLE tbl_b;
DROP DATABASE auto_test_local;
--disable_query_log
--disable_result_log
--source test_deinit.inc
--enable_result_log
--enable_query_log
|
