Debian Codegraph @

mysql-test/suite/rpl/t/binlog_multi_column_write_set_varchar.test

raw
1 # === Purpose ===
2 # Check that multicolumn unique key write sets refer to substrings of fields.
3 #
4 # === Requirements ===
5 # R1. Multicolumn unique key write sets must refer to substrings of fields.
6 #
7 # === Implementation ===
8 # 1. Create tables with varchar columns and unique keys with key_part(length)
9 # 2. Perform DML so that key_part(length) conflict with each other
10 # 3. Check last_committed and sequence_number
11 #
12 # === References ===
13 #
14 # Bug#35404584 Multi-column indexes with writest will cause HA_ERR_FOUND_DUPP_KEY
15 #
16 --source include/have_debug.inc
17 --source include/have_debug_sync.inc
18 --source include/have_binlog_format_row.inc
19 --source include/master-slave.inc
20
21 --echo #
22 --echo # Initialization
23 --echo #
24
25 --let $sysvars_to_save = [ "GLOBAL.binlog_transaction_dependency_tracking" ]
26 --source include/save_sysvars.inc
27
28 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET;
29
30 --echo #
31 --echo # Check test_table last_committed and sequence_number
32 --echo #
33
34 DROP TABLE IF EXISTS test_table;
35
36 CREATE TABLE test_table (
37 id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
38 t_id varchar(64) NOT NULL,
39 s_id varchar(64) NOT NULL,
40 a_type varchar(64) NOT NULL,
41 a_no varchar(1800) NOT NULL DEFAULT '',
42 PRIMARY KEY (`id`),
43 UNIQUE KEY `uniq_idx_t` (`s_id`(3),`a_type`(3),`a_no`(3),`t_id`(3))
44 ) ENGINE=InnoDB;
45
46 --echo #
47 --echo # Insert rows into test_table
48 --echo #
49
50 --source include/save_binlog_position.inc
51
52 # insert row1: unique key: (aaa-bbb-2-1)
53 INSERT INTO test_table VALUES (1, 1, 'aaabbb', 'bbbccc', 2);
54
55 # delete row1: unique key: (aaa-bbb-2-1)
56 DELETE FROM test_table WHERE id = 1;
57
58 --echo #
59 --echo # Value validation int test_table
60 --echo #
61
62 # insert row2: unique key: (aaa-bbb-2-1)
63 # This writeset of this transaction will conflict with 'DELETE row1'
64 # and cannot be executed in parallel on the replica. Its
65 # 'last_committed' should be equal to 'DELETE row1' sequence_number .
66 INSERT INTO test_table VALUES (2, 1, 'aaaddd', 'bbbeee', 2);
67
68 # Flush logs to force binlog to rotate
69 --let $binlog_file = query_get_value(SHOW MASTER STATUS, File, 1)
70 --let $logical_timestamps=2 3;3 4;4 5
71 --source include/assert_logical_timestamps.inc
72
73 --echo #
74 --echo # Check test2 last_committed and sequence_number
75 --echo #
76
77 DROP TABLE IF EXISTS test2;
78
79 CREATE TABLE test2 (
80 id varchar(64) NOT NULL,
81 did int DEFAULT NULL,
82 PRIMARY KEY (`id`(3))
83 ) ENGINE=InnoDB;
84
85 --echo #
86 --echo # Insert rows into test2
87 --echo #
88
89 --source include/save_binlog_position.inc
90
91 # last_committed=7 sequence_number=8
92 INSERT INTO test2 VALUES ('aaabbb', 1);
93
94 # last_committed=8 sequence_number=9
95 DELETE FROM test2 WHERE did = 1;
96
97 # last_committed=9 sequence_number=10
98 INSERT INTO test2 VALUES ('aaabbc', 2);
99
100 # last_committed=10 sequence_number=11
101 DELETE FROM test2 WHERE did = 2;
102
103 # last_committed=11 sequence_number=12
104 INSERT INTO test2 VALUES ('aaabbf', 3);
105
106 # last_committed=12 sequence_number=13
107 DELETE FROM test2 WHERE did = 3;
108
109 --echo #
110 --echo # Value validation in test2
111 --echo #
112
113 # Flush logs to force binlog to rotate
114 --let $binlog_file = query_get_value(SHOW MASTER STATUS, File, 1)
115 --let $logical_timestamps=7 8;8 9;9 10;10 11;11 12;12 13
116 --source include/assert_logical_timestamps.inc
117
118 --echo #
119 --echo # Clean up
120 --echo #
121
122 DROP TABLE test_table;
123 DROP TABLE test2;
124
125 --source include/restore_sysvars.inc
126 --source include/rpl_end.inc