Debian Codegraph @

mysql-test/suite/sys_vars/r/wsrep_mysql_replication_bundle_basic.result

raw
1 #
2 # wsrep_mysql_replication_bundle
3 #
4 # save the initial value
5 SET @wsrep_mysql_replication_bundle_global_saved = @@global.wsrep_mysql_replication_bundle;
6 # default
7 SELECT @@global.wsrep_mysql_replication_bundle;
8 @@global.wsrep_mysql_replication_bundle
9 0
10
11 # scope
12 SELECT @@session.wsrep_mysql_replication_bundle;
13 ERROR HY000: Variable 'wsrep_mysql_replication_bundle' is a GLOBAL variable
14 SELECT @@global.wsrep_mysql_replication_bundle;
15 @@global.wsrep_mysql_replication_bundle
16 0
17
18 # valid values
19 SET @@global.wsrep_mysql_replication_bundle=0;
20 SELECT @@global.wsrep_mysql_replication_bundle;
21 @@global.wsrep_mysql_replication_bundle
22 0
23 SET @@global.wsrep_mysql_replication_bundle=1000;
24 SELECT @@global.wsrep_mysql_replication_bundle;
25 @@global.wsrep_mysql_replication_bundle
26 1000
27 SET @@global.wsrep_mysql_replication_bundle=default;
28 SELECT @@global.wsrep_mysql_replication_bundle;
29 @@global.wsrep_mysql_replication_bundle
30 0
31
32 # invalid values
33 SET @@global.wsrep_mysql_replication_bundle=NULL;
34 ERROR 42000: Incorrect argument type to variable 'wsrep_mysql_replication_bundle'
35 SET @@global.wsrep_mysql_replication_bundle='junk';
36 ERROR 42000: Incorrect argument type to variable 'wsrep_mysql_replication_bundle'
37 SET @@global.wsrep_mysql_replication_bundle=-1;
38 Warnings:
39 Warning 1292 Truncated incorrect wsrep_mysql_replication_bundle value: '-1'
40 SELECT @@global.wsrep_mysql_replication_bundle;
41 @@global.wsrep_mysql_replication_bundle
42 0
43 SET @@global.wsrep_mysql_replication_bundle=1001;
44 Warnings:
45 Warning 1292 Truncated incorrect wsrep_mysql_replication_bundle value: '1001'
46 SELECT @@global.wsrep_mysql_replication_bundle;
47 @@global.wsrep_mysql_replication_bundle
48 1000
49
50 # restore the initial value
51 SET @@global.wsrep_mysql_replication_bundle = @wsrep_mysql_replication_bundle_global_saved;
52 # End of test