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
|
#
# The purpose of this test is to preserve the current state of the following:
# * SHOW VARIABLES LIKE 'wsrep%'
# * wsrep_provider_options
# * The names of the Galera status variables
#
# This way, if there is any change, inadvertent or not, the test will fail and the
# developer and QA will be alerted.
#
--source include/galera_cluster.inc
--source include/have_innodb.inc
# Make sure that the test is operating on the right version of galera library.
--disable_query_log
--let $galera_version=25.3.20
source ../wsrep/include/check_galera_version.inc;
--enable_query_log
# Global Variables
SELECT COUNT(*) = 43 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE 'wsrep_%';
SELECT VARIABLE_NAME, VARIABLE_VALUE
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
WHERE VARIABLE_NAME LIKE 'wsrep_%'
AND VARIABLE_NAME NOT IN (
'WSREP_PROVIDER_OPTIONS',
'WSREP_SST_RECEIVE_ADDRESS',
'WSREP_NODE_ADDRESS',
'WSREP_NODE_NAME',
'WSREP_PROVIDER',
'WSREP_DATA_HOME_DIR',
'WSREP_NODE_INCOMING_ADDRESS',
'WSREP_START_POSITION',
'WSREP_PATCH_VERSION'
)
ORDER BY VARIABLE_NAME;
|
