Debian Codegraph @

mysql-test/suite/wsrep/t/wsrep_provider_plugin_basic.test

raw
1 --source include/have_wsrep.inc
2 --source include/have_innodb.inc
3
4 --let $galera_version=26.4.14
5 source include/check_galera_version.inc;
6
7 #
8 # Test string option
9 #
10
11 select variable_type, global_value from information_schema.system_variables where variable_name = 'wsrep_provider_socket_recv_buf_size';
12 --error ER_WRONG_VALUE_FOR_VAR
13 set global wsrep_provider_socket_recv_buf_size = 'foo';
14 set global wsrep_provider_socket_recv_buf_size = '1M';
15 show global variables like 'wsrep_provider_socket_recv_buf_size';
16 set global wsrep_provider_socket_recv_buf_size = default;
17 show global variables like 'wsrep_provider_socket_recv_buf_size';
18
19
20 #
21 # Test integer option
22 #
23
24 select variable_type, global_value from information_schema.system_variables where variable_name = 'wsrep_provider_evs_send_window';
25 --error ER_WRONG_VALUE_FOR_VAR
26 set global wsrep_provider_evs_send_window = -10;
27 set global wsrep_provider_evs_send_window = 10;
28 show global variables like 'wsrep_provider_evs_send_window';
29 set global wsrep_provider_evs_send_window = default;
30 show global variables like 'wsrep_provider_evs_send_window';
31
32
33 #
34 # Test double option
35 #
36
37 select variable_type from information_schema.system_variables where variable_name = 'wsrep_provider_gcs_max_throttle';
38 --error ER_WRONG_VALUE_FOR_VAR
39 set global wsrep_provider_gcs_max_throttle = 1.1;
40 set global wsrep_provider_gcs_max_throttle = 0.5;
41 show global variables like 'wsrep_provider_gcs_max_throttle';
42 set global wsrep_provider_gcs_max_throttle = default;
43 show global variables like 'wsrep_provider_gcs_max_throttle';
44
45
46 #
47 # Test bool option
48 #
49
50 select variable_type from information_schema.system_variables where variable_name = 'wsrep_provider_cert_log_conflicts';
51 set global wsrep_provider_cert_log_conflicts = on;
52 show global variables like 'wsrep_provider_cert_log_conflicts';
53 set global wsrep_provider_cert_log_conflicts = off;
54 show global variables like 'wsrep_provider_cert_log_conflicts';
55 set global wsrep_provider_cert_log_conflicts = default;
56 show global variables like 'wsrep_provider_cert_log_conflicts';
57
58
59 #
60 # Test read-only option
61 #
62
63 select read_only from information_schema.system_variables where variable_name = 'wsrep_provider_evs_auto_evict';
64 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
65 set global wsrep_provider_evs_auto_evict = on;
66
67
68 #
69 # Test deprecated option (expect warning in result file)
70 #
71
72 set global wsrep_provider_gcs_fc_master_slave = default;
73
74
75 call mtr.add_suppression("error setting param");
76 call mtr.add_suppression("Unknown parameter");
77 call mtr.add_suppression("Setting parameter");