[MDEV-12066] mysqlbinlog --flashback does not reverse replace statements Created: 2017-02-14  Updated: 2017-07-04  Resolved: 2017-07-04

Status: Closed
Project: MariaDB Server
Component/s: Replication, Scripts & Clients
Affects Version/s: 10.2.4
Fix Version/s: 10.2.7

Type: Bug Priority: Major
Reporter: Oli Sennhauser Assignee: Lixun Peng
Resolution: Fixed Votes: 0
Labels: Flashback
Environment:

Linux Ubuntu 14.04 n.a.


Attachments: Text File flashback.000022.txt    

 Description   

mysqlbinlog --flashback should revert the following statement:

REPLACE INTO world.City VALUES (4078, 'Wrong value 5', '000', 'Wrong', 0)
, (NULL, 'Wrong value 6', '000', 'Wrong', 0);

into:

DELETE
UPDATE

but does a:

UPDATE
DELETE

If this is logially always correct I cannot say. But technically IMHO it is not.



 Comments   
Comment by Lixun Peng [ 2017-05-08 ]

The same as https://jira.mariadb.org/browse/MDEV-12067

Comment by Lixun Peng [ 2017-07-04 ]

Fixed in MDEV-12067

Generated at Thu Feb 08 07:54:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.