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