sys_vars/t/gtid_mode_basic.test

7 SET @start_global_value = @@global.gtid_mode;
10 SET @start_enforce_gtid_consistency= @@global.enforce_gtid_consistency;
11 SET @@global.enforce_gtid_consistency = ON;
14 # exists as global only
16 select @@global.gtid_mode;
20 set gtid_mode = @start_global_value;
22 set @@session.gtid_mode = @start_global_value;
23 show global variables like 'gtid_mode';
33 set global gtid_mode = OFF;
35 set global gtid_mode = ON_PERMISSIVE;
37 set global gtid_mode = ON;
39 set global gtid_mode = OFF_PERMISSIVE;
40 set global gtid_mode = OFF_PERMISSIVE;
42 set global gtid_mode = ON;
44 set global gtid_mode = ON_PERMISSIVE;
45 set global gtid_mode = ON_PERMISSIVE;
47 set global gtid_mode = OFF;
49 set global gtid_mode = ON;
50 set global gtid_mode = ON;
52 set global gtid_mode = OFF;
54 set global gtid_mode = OFF_PERMISSIVE;
56 set global gtid_mode = ON_PERMISSIVE;
57 set global gtid_mode = OFF_PERMISSIVE;
58 set global gtid_mode = OFF;
61 set global gtid_mode = NULL;
62 select @@global.gtid_mode;
64 set global gtid_mode = default;
65 select @@global.gtid_mode;
67 set global gtid_mode = OFF_PERMISSIVE;
68 set global gtid_mode = default;
69 select @@global.gtid_mode;
71 set global gtid_mode = OFF_PERMISSIVE;
72 set global gtid_mode = ON_PERMISSIVE;
74 set global gtid_mode = default;
75 select @@global.gtid_mode;
77 set global gtid_mode = ON;
79 set global gtid_mode = default;
80 select @@global.gtid_mode;
83 set session gtid_mode = ON;
85 # can't set ON when sql_slave_skip_counter > 0
86 set global gtid_mode = on_permissive;
87 set global sql_slave_skip_counter = 1;
89 set global gtid_mode = on;
90 set global sql_slave_skip_counter = 0;
91 set global gtid_mode = on;
93 # can set everything except ON when enforce_gtid_consistency!=ON
94 set global gtid_mode = on_permissive;
95 SET @@global.enforce_gtid_consistency = OFF;
97 set global gtid_mode = off_permissive;
98 set global gtid_mode = off;
99 set global gtid_mode = off_permissive;
100 set global gtid_mode = on_permissive;
102 set global gtid_mode = on;
104 SET @@global.enforce_gtid_consistency = WARN;
106 set global gtid_mode = off_permissive;
107 set global gtid_mode = off;
108 set global gtid_mode = off_permissive;
109 set global gtid_mode = on_permissive;
111 set global gtid_mode = on;
120 ## is in progress and gtid_next is set to 'UUID:No'.
129 ## set to 'UUID:No'.
131 # GTID_NEXT was set, gtid_mode variable cannot be changed
150 SET @@global.enforce_gtid_consistency = @start_enforce_gtid_consistency;