Debian Codegraph @

mysql-test/suite/galera/t/galera_var_wsrep_start_position.test

raw
1 --source include/galera_cluster.inc
2
3 --echo #
4 --echo # wsrep_start_position
5 --echo #
6
7 CALL mtr.add_suppression("WSREP: SST failed for position ");
8
9 SET @wsrep_start_position_global_saved = @@global.wsrep_start_position;
10 --echo # default
11 SELECT @@global.wsrep_start_position;
12
13 --echo
14 --echo # scope
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 SELECT @@session.wsrep_start_position;
17 SELECT @@global.wsrep_start_position;
18
19 --echo
20 --echo # valid values
21 SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:-1';
22 SELECT @@global.wsrep_start_position;
23
24 --echo
25 --error ER_WRONG_VALUE_FOR_VAR
26 SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:0';
27 SELECT @@global.wsrep_start_position;
28 --echo # invalid values
29 --error ER_WRONG_VALUE_FOR_VAR
30 SET @@global.wsrep_start_position='12345678-1234-1234-1234-123456789012:100';
31 SELECT @@global.wsrep_start_position;
32 --error ER_WRONG_VALUE_FOR_VAR
33 SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:-2';
34 SELECT @@global.wsrep_start_position;
35 --error ER_WRONG_VALUE_FOR_VAR
36 SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:-2A';
37 SELECT @@global.wsrep_start_position;
38 --error ER_WRONG_VALUE_FOR_VAR
39 SET @@global.wsrep_start_position='00000000-0000-0000-0000-000000000000:0A';
40 SELECT @@global.wsrep_start_position;
41 --error ER_WRONG_VALUE_FOR_VAR
42 SET @@global.wsrep_start_position='000000000000000-0000-0000-0000-000000000000:-1';
43 SELECT @@global.wsrep_start_position;
44 --error ER_WRONG_VALUE_FOR_VAR
45 SET @@global.wsrep_start_position='12345678-1234-1234-12345-123456789012:100';
46 SELECT @@global.wsrep_start_position;
47 --error ER_WRONG_VALUE_FOR_VAR
48 SET @@global.wsrep_start_position='12345678-1234-123-12345-123456789012:0';
49 SELECT @@global.wsrep_start_position;
50 --error ER_WRONG_VALUE_FOR_VAR
51 SET @@global.wsrep_start_position='12345678-1234-1234-1234-123456789012:_99999';
52 SELECT @@global.wsrep_start_position;
53 --error ER_WRONG_VALUE_FOR_VAR
54 SET @@global.wsrep_start_position='12345678-1234-1234-1234-123456789012:a';
55 SELECT @@global.wsrep_start_position;
56 --error ER_WRONG_VALUE_FOR_VAR
57 SET @@global.wsrep_start_position='OFF';
58 SELECT @@global.wsrep_start_position;
59 --error ER_WRONG_VALUE_FOR_VAR
60 SET @@global.wsrep_start_position=ON;
61 SELECT @@global.wsrep_start_position;
62 --error ER_WRONG_VALUE_FOR_VAR
63 SET @@global.wsrep_start_position='';
64 SELECT @@global.wsrep_start_position;
65 --error ER_WRONG_VALUE_FOR_VAR
66 SET @@global.wsrep_start_position=NULL;
67 SELECT @@global.wsrep_start_position;
68 --error ER_WRONG_VALUE_FOR_VAR
69 SET @@global.wsrep_start_position='junk';
70 SELECT @@global.wsrep_start_position;
71
72 --echo
73 --echo # restore the initial value
74 SET @@global.wsrep_start_position = @wsrep_start_position_global_saved;
75
76 --echo # End of test