Debian Codegraph @

mysql-test/suite/sys_vars/t/wsrep_mysql_replication_bundle_basic.test

raw
1 --source include/have_wsrep.inc
2
3 --echo #
4 --echo # wsrep_mysql_replication_bundle
5 --echo #
6
7 --echo # save the initial value
8 SET @wsrep_mysql_replication_bundle_global_saved = @@global.wsrep_mysql_replication_bundle;
9
10 --echo # default
11 SELECT @@global.wsrep_mysql_replication_bundle;
12
13 --echo
14 --echo # scope
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 SELECT @@session.wsrep_mysql_replication_bundle;
17 SELECT @@global.wsrep_mysql_replication_bundle;
18
19 --echo
20 --echo # valid values
21 SET @@global.wsrep_mysql_replication_bundle=0;
22 SELECT @@global.wsrep_mysql_replication_bundle;
23 SET @@global.wsrep_mysql_replication_bundle=1000;
24 SELECT @@global.wsrep_mysql_replication_bundle;
25 SET @@global.wsrep_mysql_replication_bundle=default;
26 SELECT @@global.wsrep_mysql_replication_bundle;
27
28 --echo
29 --echo # invalid values
30 --error ER_WRONG_TYPE_FOR_VAR
31 SET @@global.wsrep_mysql_replication_bundle=NULL;
32 --error ER_WRONG_TYPE_FOR_VAR
33 SET @@global.wsrep_mysql_replication_bundle='junk';
34 # expect warning (truncated incorrect value)
35 SET @@global.wsrep_mysql_replication_bundle=-1;
36 SELECT @@global.wsrep_mysql_replication_bundle;
37 # expect warning (truncated incorrect value)
38 SET @@global.wsrep_mysql_replication_bundle=1001;
39 SELECT @@global.wsrep_mysql_replication_bundle;
40
41 --echo
42 --echo # restore the initial value
43 SET @@global.wsrep_mysql_replication_bundle = @wsrep_mysql_replication_bundle_global_saved;
44
45 --echo # End of test