Debian Codegraph @

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

raw
1 SET @old_gtid_slave_pos= @@gtid_slave_pos;
2 SET GLOBAL gtid_slave_pos= '';
3 SELECT @@gtid_slave_pos;
4 @@gtid_slave_pos
5
6 SET GLOBAL gtid_slave_pos= '1-2-3';
7 SELECT variable_value FROM information_schema.global_variables
8 WHERE variable_name='gtid_slave_pos';
9 variable_value
10 1-2-3
11 SET @@global.gtid_slave_pos= '1-2-4';
12 SELECT @@gtid_slave_pos;
13 @@gtid_slave_pos
14 1-2-4
15 SET GLOBAL gtid_slave_pos= ' 1-2-3';
16 SELECT @@gtid_slave_pos;
17 @@gtid_slave_pos
18 1-2-3
19 SET GLOBAL gtid_slave_pos= '1-2-3, 2-4-6';
20 SELECT @@gtid_slave_pos;
21 @@gtid_slave_pos
22 1-2-3,2-4-6
23 SET GLOBAL gtid_slave_pos= '-1-2-3';
24 ERROR HY000: Could not parse GTID list
25 SET GLOBAL gtid_slave_pos= '1-2 -3';
26 ERROR HY000: Could not parse GTID list
27 SET GLOBAL gtid_slave_pos= '1-2-3 ';
28 ERROR HY000: Could not parse GTID list
29 SET GLOBAL gtid_slave_pos= '1-2-3,2-4';
30 ERROR HY000: Could not parse GTID list
31 SET GLOBAL gtid_slave_pos= '0-1-10,0-2-20';
32 ERROR HY000: GTID 0-2-20 and 0-1-10 conflict (duplicate domain id 0)
33 SET GLOBAL gtid_slave_pos= '0-1-10,1-2-20,2-3-30,1-20-200,3-4-1';
34 ERROR HY000: GTID 1-20-200 and 1-2-20 conflict (duplicate domain id 1)
35 SET gtid_slave_pos= '';
36 ERROR HY000: Variable 'gtid_slave_pos' is a GLOBAL variable and should be set with SET GLOBAL
37 SET SESSION gtid_slave_pos= '';
38 ERROR HY000: Variable 'gtid_slave_pos' is a GLOBAL variable and should be set with SET GLOBAL
39 SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6';
40 SELECT @@gtid_slave_pos;
41 @@gtid_slave_pos
42 1-2-3,2-4-6
43 SET GLOBAL gtid_slave_pos= DEFAULT;
44 ERROR 42000: Variable 'gtid_slave_pos' doesn't have a default value
45 SELECT @@session.gtid_slave_pos;
46 ERROR HY000: Variable 'gtid_slave_pos' is a GLOBAL variable
47 SET GLOBAL gtid_slave_pos= @old_gtid_slave_pos;