Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_gtid_errors.result

raw
1 RESET MASTER;
2 ==== Conditions for gtid_executed ====
3 # Readable.
4 SELECT @@GLOBAL.GTID_EXECUTED;
5 @@GLOBAL.GTID_EXECUTED
6
7 SELECT @@SESSION.GTID_EXECUTED;
8 ERROR HY000: Variable 'gtid_executed' is a GLOBAL variable
9 # Read-only.
10 SET @@GLOBAL.GTID_EXECUTED= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
11 ERROR HY000: Variable 'gtid_executed' is a read only variable
12 SET @@SESSION.GTID_EXECUTED= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:2';
13 ERROR HY000: Variable 'gtid_executed' is a read only variable
14 ==== Conditions for gtid_purged ====
15 # Readable global variable
16 SELECT @@GLOBAL.GTID_PURGED;
17 @@GLOBAL.GTID_PURGED
18
19 # Not a session variable
20 SELECT @@SESSION.GTID_PURGED;
21 ERROR HY000: Variable 'gtid_purged' is a GLOBAL variable
22 # Read-only.
23 SET @@SESSION.GTID_PURGED= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3';
24 ERROR HY000: Variable 'gtid_purged' is a GLOBAL variable and should be set with SET GLOBAL
25 ==== Conditions for gtid_owned ====
26 # Readable.
27 SELECT @@GLOBAL.GTID_OWNED;
28 @@GLOBAL.GTID_OWNED
29
30 SELECT @@SESSION.GTID_OWNED;
31 @@SESSION.GTID_OWNED
32
33 # Read-only.
34 SET @@SESSION.GTID_OWNED= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:5';
35 ERROR HY000: Variable 'gtid_owned' is a read only variable
36 SET @@GLOBAL.GTID_OWNED= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:6#1';
37 ERROR HY000: Variable 'gtid_owned' is a read only variable
38 ==== Valid and invalid values for gtid_next ====
39 # Default should be AUTOMATIC
40 SELECT @@SESSION.GTID_NEXT;
41 @@SESSION.GTID_NEXT
42 AUTOMATIC
43 SET @@SESSION.GTID_NEXT= 'AUTOMATIC';
44 SELECT @@SESSION.GTID_NEXT;
45 @@SESSION.GTID_NEXT
46 AUTOMATIC
47 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10';
48 SELECT @@SESSION.GTID_NEXT;
49 @@SESSION.GTID_NEXT
50 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10
51 ROLLBACK;
52 SET @@SESSION.GTID_NEXT= '
53 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa : 10
54 ';
55 SELECT @@SESSION.GTID_NEXT;
56 @@SESSION.GTID_NEXT
57 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10
58 ROLLBACK;
59 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0x10';
60 SELECT @@SESSION.GTID_NEXT;
61 @@SESSION.GTID_NEXT
62 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:16
63 ROLLBACK;
64 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:010';
65 SELECT @@SESSION.GTID_NEXT;
66 @@SESSION.GTID_NEXT
67 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:8
68 ROLLBACK;
69 SET @@SESSION.GTID_NEXT= 'AUTOMATIC';
70 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10#';
71 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10#'.
72 SELECT @@SESSION.GTID_NEXT;
73 @@SESSION.GTID_NEXT
74 AUTOMATIC
75 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10';
76 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10'.
77 SELECT @@SESSION.GTID_NEXT;
78 @@SESSION.GTID_NEXT
79 AUTOMATIC
80 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3';
81 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1:3'.
82 SELECT @@SESSION.GTID_NEXT;
83 @@SESSION.GTID_NEXT
84 AUTOMATIC
85 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3';
86 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1,aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:3'.
87 SELECT @@SESSION.GTID_NEXT;
88 @@SESSION.GTID_NEXT
89 AUTOMATIC
90 SET @@SESSION.GTID_NEXT= NULL;
91 ERROR 42000: Variable 'gtid_next' can't be set to the value of 'NULL'
92 SELECT @@SESSION.GTID_NEXT;
93 @@SESSION.GTID_NEXT
94 AUTOMATIC
95 SET @@SESSION.GTID_NEXT= 10;
96 ERROR 42000: Incorrect argument type to variable 'gtid_next'
97 SELECT @@SESSION.GTID_NEXT;
98 @@SESSION.GTID_NEXT
99 AUTOMATIC
100 SET @@SESSION.GTID_NEXT= '10';
101 ERROR HY000: Malformed GTID specification '10'.
102 SELECT @@SESSION.GTID_NEXT;
103 @@SESSION.GTID_NEXT
104 AUTOMATIC
105 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:';
106 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:'.
107 SELECT @@SESSION.GTID_NEXT;
108 @@SESSION.GTID_NEXT
109 AUTOMATIC
110 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0';
111 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0'.
112 SELECT @@SESSION.GTID_NEXT;
113 @@SESSION.GTID_NEXT
114 AUTOMATIC
115 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0x8000000000000000';
116 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:0x8000000000000000'.
117 SELECT @@SESSION.GTID_NEXT;
118 @@SESSION.GTID_NEXT
119 AUTOMATIC
120 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:-33';
121 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:-33'.
122 SELECT @@SESSION.GTID_NEXT;
123 @@SESSION.GTID_NEXT
124 AUTOMATIC
125 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:66-33';
126 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:66-33'.
127 SELECT @@SESSION.GTID_NEXT;
128 @@SESSION.GTID_NEXT
129 AUTOMATIC
130 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:33 33';
131 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:33 33'.
132 SELECT @@SESSION.GTID_NEXT;
133 @@SESSION.GTID_NEXT
134 AUTOMATIC
135 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa-33';
136 ERROR HY000: Malformed GTID specification 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa-33'.
137 SELECT @@SESSION.GTID_NEXT;
138 @@SESSION.GTID_NEXT
139 AUTOMATIC
140 ==== Conditions for gtid_next ====
141 # Initialize
142 CREATE FUNCTION f() RETURNS INT BEGIN RETURN 1; END;
143 CREATE TABLE t1 (a INT) ENGINE = InnoDB;
144 CREATE USER nonsuper@localhost;
145 GRANT SELECT ON *.* TO nonsuper@localhost;
146 # Read/write session
147 SELECT @@SESSION.GTID_NEXT;
148 @@SESSION.GTID_NEXT
149 AUTOMATIC
150 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:7';
151 ROLLBACK;
152 # not global
153 SELECT @@GLOBAL.GTID_NEXT;
154 ERROR HY000: Variable 'gtid_next' is a SESSION variable
155 SET @@GLOBAL.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:8';
156 ERROR HY000: Variable 'gtid_next' is a SESSION variable and can't be used with SET GLOBAL
157 ROLLBACK;
158 SET GTID_NEXT = 'AUTOMATIC';
159 # Can't set value from stored function
160 CREATE FUNCTION set_var() RETURNS INT BEGIN SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:9'; RETURN 1; END;
161 SELECT set_var();
162 ERROR HY000: The system variable gtid_next cannot be set in stored functions or triggers.
163 DROP FUNCTION set_var;
164 # Can't set value from trigger
165 CREATE TRIGGER t BEFORE INSERT ON t1 FOR EACH ROW SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:10';
166 INSERT INTO t1 VALUES (1);
167 ERROR HY000: The system variable gtid_next cannot be set in stored functions or triggers.
168 DROP TRIGGER t;
169 # Can't set value when invoking SF
170 SET @@SESSION.GTID_NEXT = f();
171 ERROR HY000: The statement 'SET gtid_next' cannot invoke a stored function.
172 # must be SUPER
173 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:11';
174 ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN, SESSION_VARIABLES_ADMIN or REPLICATION_APPLIER privilege(s) for this operation
175 # can read even if non-SUPER
176 SELECT @@SESSION.GTID_NEXT;
177 @@SESSION.GTID_NEXT
178 AUTOMATIC
179 # can't set inside transaction
180 BEGIN;
181 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:12';
182 ERROR HY000: The system variable gtid_next cannot be set when there is an ongoing transaction.
183 INSERT INTO t1 VALUES (4);
184 ROLLBACK;
185 # can't set while owning a GTID
186 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:13';
187 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:14';
188 ERROR HY000: @@SESSION.GTID_NEXT cannot be changed by a client that owns a GTID. The client owns aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:13. Ownership is released on COMMIT or ROLLBACK.
189 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
190 ROLLBACK;
191 # can't set while owning a GTID
192 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:13';
193 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
194 ERROR HY000: @@SESSION.GTID_NEXT cannot be changed by a client that owns a GTID. The client owns aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:13. Ownership is released on COMMIT or ROLLBACK.
195 ROLLBACK;
196 # Can't set while owning ANONYMOUS
197 include/rpl_set_gtid_mode.inc [OFF on servers 1]
198 SET GTID_NEXT = 'ANONYMOUS';
199 SET GTID_NEXT = 'ANONYMOUS';
200 ERROR HY000: @@SESSION.GTID_NEXT cannot be changed by a client that owns a GTID. The client owns ANONYMOUS. Ownership is released on COMMIT or ROLLBACK.
201 SET GTID_NEXT = 'ANONYMOUS';
202 SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
203 ERROR HY000: @@SESSION.GTID_NEXT cannot be changed by a client that owns a GTID. The client owns ANONYMOUS. Ownership is released on COMMIT or ROLLBACK.
204 SET GTID_NEXT = 'ANONYMOUS';
205 SET GTID_NEXT = 'AUTOMATIC';
206 ERROR HY000: @@SESSION.GTID_NEXT cannot be changed by a client that owns a GTID. The client owns ANONYMOUS. Ownership is released on COMMIT or ROLLBACK.
207 SET GTID_NEXT = 'AUTOMATIC';
208 include/rpl_set_gtid_mode.inc [ON on servers 1]
209 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:14';
210 # can't do implicit commit while gtid_next=SID:GNO
211 BEGIN;
212 CREATE TABLE t2 (a INT);
213 ERROR HY000: Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
214 ROLLBACK;
215 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:15';
216 BEGIN;
217 INSERT INTO t1 VALUES (1);
218 CREATE TABLE t2 (a INT);
219 ERROR HY000: Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
220 COMMIT;
221 SET @@SESSION.GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:16';
222 CREATE TABLE t2 ENGINE=MyISAM AS SELECT * FROM t1;
223 ERROR HY000: Statement violates GTID consistency: CREATE TABLE ... SELECT.
224 COMMIT;
225 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:17';
226 # can't do implicit commit while gtid_next=SID:GNO
227 SET AUTOCOMMIT = 0;
228 INSERT INTO t1 VALUES (1);
229 CREATE TABLE t2 (a INT);
230 ERROR HY000: Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
231 ROLLBACK;
232 SELECT @@SESSION.GTID_NEXT;
233 @@SESSION.GTID_NEXT
234 aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:17
235 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
236 DROP TABLE t1;
237 DROP FUNCTION f;
238 DROP USER nonsuper@localhost;
239 CREATE PROCEDURE p ()
240 BEGIN
241 SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:16';
242 ROLLBACK;
243 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
244 END|
245 CALL p();
246 DROP PROCEDURE p;