Comments - Row order in binary log event
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Yes, this behaviour should be guaranteed.
Whatever order the rows were updated in on the master, the row events will contain row updates in the same order, and matching before/after images. And applying the row updates one by one in order on the slave will result in the same data as on the master.
It though a very interesting/wierd case as you wrote, I wasn't aware that this kind of query was even possible.
(Answer probably too old to be useful to the author, just adding it for reference.)