Debian Codegraph @

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

raw
1 RESET MASTER;
2 SET @start_global_value = @@global.enforce_gtid_consistency;
3 SELECT @start_global_value;
4 @start_global_value
5 OFF
6 select @@global.enforce_gtid_consistency;
7 @@global.enforce_gtid_consistency
8 OFF
9 select @@session.enforce_gtid_consistency;
10 ERROR HY000: Variable 'enforce_gtid_consistency' is a GLOBAL variable
11 show global variables like 'enforce_gtid_consistency';
12 Variable_name Value
13 enforce_gtid_consistency OFF
14 show session variables like 'enforce_gtid_consistency';
15 Variable_name Value
16 enforce_gtid_consistency OFF
17 select * from performance_schema.global_variables where variable_name='enforce_gtid_consistency';
18 VARIABLE_NAME VARIABLE_VALUE
19 enforce_gtid_consistency OFF
20 select * from performance_schema.session_variables where variable_name='enforce_gtid_consistency';
21 VARIABLE_NAME VARIABLE_VALUE
22 enforce_gtid_consistency OFF
23 set global enforce_gtid_consistency= 1;
24 select @@global.enforce_gtid_consistency;
25 @@global.enforce_gtid_consistency
26 ON
27 show variables like 'enforce_gtid_consistency';
28 Variable_name Value
29 enforce_gtid_consistency ON
30 select variable_value from performance_schema.global_variables
31 where variable_name= 'enforce_gtid_consistency';
32 variable_value
33 ON
34 set global enforce_gtid_consistency= 0;
35 select @@global.enforce_gtid_consistency;
36 @@global.enforce_gtid_consistency
37 OFF
38 show variables like 'enforce_gtid_consistency';
39 Variable_name Value
40 enforce_gtid_consistency OFF
41 select variable_value from performance_schema.global_variables
42 where variable_name= 'enforce_gtid_consistency';
43 variable_value
44 OFF
45 set global enforce_gtid_consistency= 2;
46 select @@global.enforce_gtid_consistency;
47 @@global.enforce_gtid_consistency
48 WARN
49 show variables like 'enforce_gtid_consistency';
50 Variable_name Value
51 enforce_gtid_consistency WARN
52 select variable_value from performance_schema.global_variables
53 where variable_name= 'enforce_gtid_consistency';
54 variable_value
55 WARN
56 set global enforce_gtid_consistency= ON;
57 select @@global.enforce_gtid_consistency;
58 @@global.enforce_gtid_consistency
59 ON
60 show variables like 'enforce_gtid_consistency';
61 Variable_name Value
62 enforce_gtid_consistency ON
63 select variable_value from performance_schema.global_variables
64 where variable_name= 'enforce_gtid_consistency';
65 variable_value
66 ON
67 set global enforce_gtid_consistency= OFF;
68 select @@global.enforce_gtid_consistency;
69 @@global.enforce_gtid_consistency
70 OFF
71 show variables like 'enforce_gtid_consistency';
72 Variable_name Value
73 enforce_gtid_consistency OFF
74 select variable_value from performance_schema.global_variables
75 where variable_name= 'enforce_gtid_consistency';
76 variable_value
77 OFF
78 set global enforce_gtid_consistency= TRUE;
79 select @@global.enforce_gtid_consistency;
80 @@global.enforce_gtid_consistency
81 ON
82 show variables like 'enforce_gtid_consistency';
83 Variable_name Value
84 enforce_gtid_consistency ON
85 select variable_value from performance_schema.global_variables
86 where variable_name= 'enforce_gtid_consistency';
87 variable_value
88 ON
89 set global enforce_gtid_consistency= FALSE;
90 select @@global.enforce_gtid_consistency;
91 @@global.enforce_gtid_consistency
92 OFF
93 show variables like 'enforce_gtid_consistency';
94 Variable_name Value
95 enforce_gtid_consistency OFF
96 select variable_value from performance_schema.global_variables
97 where variable_name= 'enforce_gtid_consistency';
98 variable_value
99 OFF
100 set global enforce_gtid_consistency= WARN;
101 select @@global.enforce_gtid_consistency;
102 @@global.enforce_gtid_consistency
103 WARN
104 show variables like 'enforce_gtid_consistency';
105 Variable_name Value
106 enforce_gtid_consistency WARN
107 select variable_value from performance_schema.global_variables
108 where variable_name= 'enforce_gtid_consistency';
109 variable_value
110 WARN
111 set session enforce_gtid_consistency= 1;
112 ERROR HY000: Variable 'enforce_gtid_consistency' is a GLOBAL variable and should be set with SET GLOBAL
113 select @@session.enforce_gtid_consistency;
114 ERROR HY000: Variable 'enforce_gtid_consistency' is a GLOBAL variable
115 set global enforce_gtid_consistency= -1;
116 ERROR 42000: Variable 'enforce_gtid_consistency' can't be set to the value of '-1'
117 set global enforce_gtid_consistency= 3;
118 ERROR 42000: Variable 'enforce_gtid_consistency' can't be set to the value of '3'
119 set global enforce_gtid_consistency= NULL;
120 ERROR 42000: Variable 'enforce_gtid_consistency' can't be set to the value of 'NULL'
121 set global enforce_gtid_consistency= '';
122 ERROR 42000: Variable 'enforce_gtid_consistency' can't be set to the value of ''
123 set global enforce_gtid_consistency= default;
124 set global enforce_gtid_consistency= ON;
125 set global gtid_mode=off_permissive;
126 set global gtid_mode=on_permissive;
127 set global gtid_mode=on;
128 set global enforce_gtid_consistency= WARN;
129 ERROR HY000: GTID_MODE = ON requires ENFORCE_GTID_CONSISTENCY = ON.
130 set global enforce_gtid_consistency= OFF;
131 ERROR HY000: GTID_MODE = ON requires ENFORCE_GTID_CONSISTENCY = ON.
132 set global enforce_gtid_consistency= ON;
133 set global enforce_gtid_consistency= TRUE;
134 set global enforce_gtid_consistency= 1;
135 set global gtid_mode=on_permissive;
136 set global gtid_mode=off_permissive;
137 CREATE TABLE t1 (a INT);
138 SET AUTOCOMMIT = 0;
139 SET SESSION GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
140 INSERT INTO t1 VALUES (1);
141 SET GLOBAL ENFORCE_GTID_CONSISTENCY = 'off';
142 ERROR HY000: The system variable enforce_gtid_consistency cannot be set when there is an ongoing transaction.
143 COMMIT;
144 SET SESSION GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
145 SET GLOBAL ENFORCE_GTID_CONSISTENCY = 'off';
146 ERROR HY000: Variable enforce_gtid_consistency cannot be changed by a client that owns a GTID. The client owns aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2. Ownership is released on COMMIT or ROLLBACK.
147 COMMIT;
148 SET GTID_NEXT = 'ANONYMOUS';
149 SET GLOBAL ENFORCE_GTID_CONSISTENCY = 'off';
150 ERROR HY000: Variable enforce_gtid_consistency cannot be changed by a client that owns a GTID. The client owns ANONYMOUS. Ownership is released on COMMIT or ROLLBACK.
151 COMMIT;
152 SET AUTOCOMMIT = 1;
153 SET SESSION GTID_NEXT = 'AUTOMATIC';
154 SET GLOBAL GTID_MODE = 'off';
155 DROP TABLE t1;
156 set global enforce_gtid_consistency= @start_global_value;