Debian Codegraph @

mysql-test/suite/galera/r/wsrep_slave_threads_basic.result

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