1SET @save_binlog_transaction_dependency_tracking = @@GLOBAL.binlog_transaction_dependency_tracking; 2SET @save_transaction_write_set_extraction = @@GLOBAL.transaction_write_set_extraction; 3SET @@GLOBAL.transaction_write_set_extraction = XXHASH64; 4SET @@SESSION.transaction_write_set_extraction = XXHASH64; 5SET @@GLOBAL.binlog_transaction_dependency_tracking = WRITESET; 6SET NAMES 'utf8' COLLATE 'utf8_general_ci'; 7RESET MASTER; 8CREATE TABLE t1 ( 9id INT NOT NULL AUTO_INCREMENT, 10u_id INT NOT NULL, 11u_str VARCHAR(32) NOT NULL, 12PRIMARY KEY (id), 13UNIQUE KEY (u_id, u_str) 14) ENGINE=InnoDB; 15INSERT INTO t1 (u_id, u_str) VALUES (1, 'a'); 16INSERT INTO t1 (u_id, u_str) VALUES (1, 'A'); 17ERROR 23000: Duplicate entry '1-A' for key 'u_id' 18INSERT INTO t1 (u_id, u_str) VALUES (1, 'ã'); 19ERROR 23000: Duplicate entry '1-ã' for key 'u_id' 20INSERT INTO t1 (u_id, u_str) VALUES (1, 'Ã'); 21ERROR 23000: Duplicate entry '1-Ã' for key 'u_id' 22INSERT INTO t1 (u_id, u_str) VALUES (1, 'á'); 23ERROR 23000: Duplicate entry '1-á' for key 'u_id' 24DELETE FROM t1 WHERE u_id = 1 AND u_str = 'A'; 25INSERT INTO t1 (u_id, u_str) VALUES (1, 'ã'); 26DELETE FROM t1 WHERE u_id = 1 AND u_str = 'Ã'; 27INSERT INTO t1 (u_id, u_str) VALUES (1, 'á'); 28DROP TABLE t1; 29Processing binlog master-bin.000001 30FLUSH LOGS; 31include/include/assert_logical_timestamps.inc [0 1;1 2;2 3;3 4;4 5;5 6;6 7] 32SET @@GLOBAL.binlog_transaction_dependency_tracking = COMMIT_ORDER; 33SET @@GLOBAL.transaction_write_set_extraction= @save_transaction_write_set_extraction; 34SET @@GLOBAL.binlog_transaction_dependency_tracking= @save_binlog_transaction_dependency_tracking; 35