Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 #
4 # wsrep_start_position
5 #
6 CALL mtr.add_suppression("WSREP: SST failed for position ");
7 SET @wsrep_start_position_global_saved = @@global.wsrep_start_position;
8 # default
9 SELECT @@global.wsrep_start_position;
10 @@global.wsrep_start_position
11 00000000-0000-0000-0000-000000000000:-1
12
13 # scope
14 SELECT @@session.wsrep_start_position;
15 ERROR HY000: Variable 'wsrep_start_position' is a GLOBAL variable
16 SELECT @@global.wsrep_start_position;
17 @@global.wsrep_start_position
18 00000000-0000-0000-0000-000000000000:-1
19
20 # valid values
21 SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:-1';
22 SELECT @@global.wsrep_start_position;
23 @@global.wsrep_start_position
24 00000000-0000-0000-0000-000000000000:-1
25
26 SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:0';
27 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '00000000-0000-0000-0000-000000000000:0'
28 SELECT @@global.wsrep_start_position;
29 @@global.wsrep_start_position
30 00000000-0000-0000-0000-000000000000:-1
31 # invalid values
32 SET @@global.wsrep_start_position='12345678-1234-1234-1234-123456789012:100';
33 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '12345678-1234-1234-1234-123456789012:100'
34 SELECT @@global.wsrep_start_position;
35 @@global.wsrep_start_position
36 00000000-0000-0000-0000-000000000000:-1
37 SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:-2';
38 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '00000000-0000-0000-0000-000000000000:-2'
39 SELECT @@global.wsrep_start_position;
40 @@global.wsrep_start_position
41 00000000-0000-0000-0000-000000000000:-1
42 SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:-2A';
43 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '00000000-0000-0000-0000-000000000000:-2A'
44 SELECT @@global.wsrep_start_position;
45 @@global.wsrep_start_position
46 00000000-0000-0000-0000-000000000000:-1
47 SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:0A';
48 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '00000000-0000-0000-0000-000000000000:0A'
49 SELECT @@global.wsrep_start_position;
50 @@global.wsrep_start_position
51 00000000-0000-0000-0000-000000000000:-1
52 SET @@global.wsrep_start_position='000000000000000-0000-0000-0000-000000000000:-1';
53 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '000000000000000-0000-0000-0000-000000000000:-1'
54 SELECT @@global.wsrep_start_position;
55 @@global.wsrep_start_position
56 00000000-0000-0000-0000-000000000000:-1
57 SET @@global.wsrep_start_position='12345678-1234-1234-12345-123456789012:100';
58 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '12345678-1234-1234-12345-123456789012:100'
59 SELECT @@global.wsrep_start_position;
60 @@global.wsrep_start_position
61 00000000-0000-0000-0000-000000000000:-1
62 SET @@global.wsrep_start_position='12345678-1234-123-12345-123456789012:0';
63 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '12345678-1234-123-12345-123456789012:0'
64 SELECT @@global.wsrep_start_position;
65 @@global.wsrep_start_position
66 00000000-0000-0000-0000-000000000000:-1
67 SET @@global.wsrep_start_position='12345678-1234-1234-1234-123456789012:_99999';
68 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '12345678-1234-1234-1234-123456789012:_99999'
69 SELECT @@global.wsrep_start_position;
70 @@global.wsrep_start_position
71 00000000-0000-0000-0000-000000000000:-1
72 SET @@global.wsrep_start_position='12345678-1234-1234-1234-123456789012:a';
73 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of '12345678-1234-1234-1234-123456789012:a'
74 SELECT @@global.wsrep_start_position;
75 @@global.wsrep_start_position
76 00000000-0000-0000-0000-000000000000:-1
77 SET @@global.wsrep_start_position='OFF';
78 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of 'OFF'
79 SELECT @@global.wsrep_start_position;
80 @@global.wsrep_start_position
81 00000000-0000-0000-0000-000000000000:-1
82 SET @@global.wsrep_start_position=ON;
83 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of 'ON'
84 SELECT @@global.wsrep_start_position;
85 @@global.wsrep_start_position
86 00000000-0000-0000-0000-000000000000:-1
87 SET @@global.wsrep_start_position='';
88 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of ''
89 SELECT @@global.wsrep_start_position;
90 @@global.wsrep_start_position
91 00000000-0000-0000-0000-000000000000:-1
92 SET @@global.wsrep_start_position=NULL;
93 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of 'NULL'
94 SELECT @@global.wsrep_start_position;
95 @@global.wsrep_start_position
96 00000000-0000-0000-0000-000000000000:-1
97 SET @@global.wsrep_start_position='junk';
98 ERROR 42000: Variable 'wsrep_start_position' can't be set to the value of 'junk'
99 SELECT @@global.wsrep_start_position;
100 @@global.wsrep_start_position
101 00000000-0000-0000-0000-000000000000:-1
102
103 # restore the initial value
104 SET @@global.wsrep_start_position = @wsrep_start_position_global_saved;
105 # End of test