Debian Codegraph @

mysql-test/suite/sys_vars/t/gtid_slave_pos_basic.test

raw
1 --source include/not_embedded.inc
2
3 SET @old_gtid_slave_pos= @@gtid_slave_pos;
4
5 SET GLOBAL gtid_slave_pos= '';
6 SELECT @@gtid_slave_pos;
7 SET GLOBAL gtid_slave_pos= '1-2-3';
8 SELECT variable_value FROM information_schema.global_variables
9 WHERE variable_name='gtid_slave_pos';
10 SET @@global.gtid_slave_pos= '1-2-4';
11 SELECT @@gtid_slave_pos;
12
13 SET GLOBAL gtid_slave_pos= ' 1-2-3';
14 SELECT @@gtid_slave_pos;
15 SET GLOBAL gtid_slave_pos= '1-2-3, 2-4-6';
16 SELECT @@gtid_slave_pos;
17
18 --error ER_INCORRECT_GTID_STATE
19 SET GLOBAL gtid_slave_pos= '-1-2-3';
20 --error ER_INCORRECT_GTID_STATE
21 SET GLOBAL gtid_slave_pos= '1-2 -3';
22 --error ER_INCORRECT_GTID_STATE
23 SET GLOBAL gtid_slave_pos= '1-2-3 ';
24 --error ER_INCORRECT_GTID_STATE
25 SET GLOBAL gtid_slave_pos= '1-2-3,2-4';
26
27 --error ER_DUPLICATE_GTID_DOMAIN
28 SET GLOBAL gtid_slave_pos= '0-1-10,0-2-20';
29 --error ER_DUPLICATE_GTID_DOMAIN
30 SET GLOBAL gtid_slave_pos= '0-1-10,1-2-20,2-3-30,1-20-200,3-4-1';
31
32 --error ER_GLOBAL_VARIABLE
33 SET gtid_slave_pos= '';
34 --error ER_GLOBAL_VARIABLE
35 SET SESSION gtid_slave_pos= '';
36
37 SET GLOBAL gtid_slave_pos= '1-2-3,2-4-6';
38 SELECT @@gtid_slave_pos;
39
40 --error ER_NO_DEFAULT
41 SET GLOBAL gtid_slave_pos= DEFAULT;
42
43 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
44 SELECT @@session.gtid_slave_pos;
45
46 SET GLOBAL gtid_slave_pos= @old_gtid_slave_pos;