You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
An error message shows a variable that is not available
to change.
Analysis:
Several error messages have an explicit reference to
@@SESSION.GTID_NEXT_LIST.
The issue is that SESSION.GTID_NEXT_LIST is not
available to be changed and nor it should be, since it is a
future feature to be integrated in NDB, thus not being
available in the server mainline. The error messages are
misleading to a user.
Fix:
Change the error messages in order to state the only
possible source of error. Also corrected the binlog
tests that were expecting that specific message.
Copy file name to clipboardExpand all lines: mysql-test/suite/binlog/r/binlog_gtid_errors.result
+3-3Lines changed: 3 additions & 3 deletions
Original file line number
Diff line number
Diff line change
@@ -179,7 +179,7 @@ AUTOMATIC
179
179
# can't set inside transaction
180
180
BEGIN;
181
181
SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:12';
182
-
ERROR HY000: When @@SESSION.GTID_NEXT_LIST == NULL, the system variable @@SESSION.GTID_NEXT cannot change inside a transaction.
182
+
ERROR HY000: The system variable @@SESSION.GTID_NEXT cannot change inside a transaction.
183
183
INSERT INTO t1 VALUES (4);
184
184
ROLLBACK;
185
185
# can't set while owning a GTID
@@ -197,14 +197,14 @@ SET @@SESSION.GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:14';
197
197
# can't do implicit commit while gtid_next=SID:GNO
198
198
BEGIN;
199
199
CREATE TABLE t2 (a INT);
200
-
ERROR HY000: Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT != AUTOMATIC or @@SESSION.GTID_NEXT_LIST != NULL.
200
+
ERROR HY000: Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT != AUTOMATIC.
201
201
ROLLBACK;
202
202
SET GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:15';
203
203
# can't do implicit commit while gtid_next=SID:GNO
204
204
SET AUTOCOMMIT = 0;
205
205
INSERT INTO t1 VALUES (1);
206
206
CREATE TABLE t2 (a INT);
207
-
ERROR HY000: Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT != AUTOMATIC or @@SESSION.GTID_NEXT_LIST != NULL.
207
+
ERROR HY000: Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT != AUTOMATIC.
0 commit comments