Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
2.5.21, 6.4.1, 22.08.0
-
None
Description
If a write query modifies a user variable in it, the query is treated as a session command instead of being properly classified as a write. This either corrupted the replicas if GTID strict mode wasn't used or broke replication if it was in use.
The problem can be reproduced with the following query:
UPDATE test.t1 SET id = (@var := @var + 1); |