Debian Codegraph @

mysql-test/suite/rpl/r/rpl_parallel_29322.result

raw
1 #
2 # MDEV-29322 ASAN use-after-free options_written_to_bin_log
3 #
4 include/master-slave.inc
5 [connection master]
6 # A. set the master and slave explicit_defaults_for_timestamp values crisscross to (1,0)
7 connection master;
8 set @sav.explicit_defaults_for_timestamp = @@session.explicit_defaults_for_timestamp;
9 set @@session.explicit_defaults_for_timestamp = 1;
10 connection slave;
11 set @sav.explicit_defaults_for_timestamp = @@global.explicit_defaults_for_timestamp;
12 set global explicit_defaults_for_timestamp = 0;
13 Warnings:
14 Warning 1287 'explicit_defaults_for_timestamp=0' is deprecated and will be removed in a future release
15 set @sav.slave_parallel_workers = @@global.slave_parallel_workers;
16 include/stop_slave.inc
17 set @@global.slave_parallel_workers = 1;
18 include/start_slave.inc
19 connection slave;
20 include/stop_slave.inc
21 include/reset_slave.inc
22 connection master;
23 reset master;
24 create table t2 (a timestamp, b int);
25 show create table t2;
26 Table Create Table
27 t2 CREATE TABLE `t2` (
28 `a` timestamp NULL DEFAULT NULL,
29 `b` int(11) DEFAULT NULL
30 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
31 connection slave;
32 include/start_slave.inc
33 include/stop_slave.inc
34 connection master;
35 insert into t2 values (null, 1);
36 flush binary logs;
37 flush binary logs;
38 insert into t2 values (null, 2);
39 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
40 /*!40019 SET @@session.max_delayed_threads=0*/;
41 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
42 DELIMITER /*!*/;
43 ROLLBACK/*!*/;
44 use `test`/*!*/;
45 SET TIMESTAMP=1658586280/*!*/;
46 SET @@session.pseudo_thread_id=999999999/*!*/;
47 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.system_versioning_insert_history=0/*!*/;
48 SET @@session.sql_mode=1411383296/*!*/;
49 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
50 /*!\C utf8mb3 *//*!*/;
51 SET @@session.character_set_client=utf8mb3,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
52 SET @@session.lc_time_names=0/*!*/;
53 SET @@session.collation_database=DEFAULT/*!*/;
54 create table t1 (f1 timestamp, f2 timestamp)
55 /*!*/;
56 START TRANSACTION
57 /*!*/;
58 SET TIMESTAMP=1658586288/*!*/;
59 insert t1 values (NULL, NULL)
60 /*!*/;
61 SET TIMESTAMP=1658586288/*!*/;
62 COMMIT
63 /*!*/;
64 START TRANSACTION
65 /*!*/;
66 SET TIMESTAMP=1658586335/*!*/;
67 insert t1 () values ()
68 /*!*/;
69 SET TIMESTAMP=1658586335/*!*/;
70 COMMIT
71 /*!*/;
72 DELIMITER ;
73 # End of log file
74 ROLLBACK /* added by mysqlbinlog */;
75 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
76 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
77 connection slave1;
78 lock table t2 write;
79 connection slave;
80 include/start_slave.inc
81 connection slave1;
82 unlock tables;
83 connection slave;
84 show create table t1;
85 Table Create Table
86 t1 CREATE TABLE `t1` (
87 `f1` timestamp NULL DEFAULT NULL,
88 `f2` timestamp NULL DEFAULT NULL
89 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
90 set statement time_zone='+2:00' for select * from t1;
91 f1 f2
92 NULL NULL
93 NULL NULL
94 drop table t1;
95 connection master;
96 connection slave;
97 show create table t2;
98 Table Create Table
99 t2 CREATE TABLE `t2` (
100 `a` timestamp NULL DEFAULT NULL,
101 `b` int(11) DEFAULT NULL
102 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
103 include/diff_tables.inc [master:t2,slave:t2]
104 connection master;
105 drop table t2;
106 connection slave;
107 # B. alternate the master and slave vars' values to (0,1)
108 connection master;
109 set @@session.explicit_defaults_for_timestamp = 0;
110 Warnings:
111 Warning 1287 'explicit_defaults_for_timestamp=0' is deprecated and will be removed in a future release
112 connection slave;
113 set @@global.explicit_defaults_for_timestamp = 1;
114 connection slave;
115 include/stop_slave.inc
116 include/reset_slave.inc
117 Warnings:
118 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
119 connection master;
120 reset master;
121 create table t2 (a timestamp, b int);
122 show create table t2;
123 Table Create Table
124 t2 CREATE TABLE `t2` (
125 `a` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
126 `b` int(11) DEFAULT NULL
127 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
128 connection slave;
129 include/start_slave.inc
130 include/stop_slave.inc
131 connection master;
132 insert into t2 values (null, 1);
133 flush binary logs;
134 flush binary logs;
135 insert into t2 values (null, 2);
136 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
137 /*!40019 SET @@session.max_delayed_threads=0*/;
138 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
139 DELIMITER /*!*/;
140 ROLLBACK/*!*/;
141 use `test`/*!*/;
142 SET TIMESTAMP=1658586280/*!*/;
143 SET @@session.pseudo_thread_id=999999999/*!*/;
144 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.system_versioning_insert_history=0/*!*/;
145 SET @@session.sql_mode=1411383296/*!*/;
146 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
147 /*!\C utf8mb3 *//*!*/;
148 SET @@session.character_set_client=utf8mb3,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
149 SET @@session.lc_time_names=0/*!*/;
150 SET @@session.collation_database=DEFAULT/*!*/;
151 create table t1 (f1 timestamp, f2 timestamp)
152 /*!*/;
153 START TRANSACTION
154 /*!*/;
155 SET TIMESTAMP=1658586288/*!*/;
156 insert t1 values (NULL, NULL)
157 /*!*/;
158 SET TIMESTAMP=1658586288/*!*/;
159 COMMIT
160 /*!*/;
161 START TRANSACTION
162 /*!*/;
163 SET TIMESTAMP=1658586335/*!*/;
164 insert t1 () values ()
165 /*!*/;
166 SET TIMESTAMP=1658586335/*!*/;
167 COMMIT
168 /*!*/;
169 DELIMITER ;
170 # End of log file
171 ROLLBACK /* added by mysqlbinlog */;
172 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
173 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
174 connection slave1;
175 lock table t2 write;
176 connection slave;
177 include/start_slave.inc
178 connection slave1;
179 unlock tables;
180 connection slave;
181 show create table t1;
182 Table Create Table
183 t1 CREATE TABLE `t1` (
184 `f1` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
185 `f2` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
186 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
187 set statement time_zone='+2:00' for select * from t1;
188 f1 f2
189 2022-07-23 16:24:48 2022-07-23 16:24:48
190 2022-07-23 16:25:35 0000-00-00 00:00:00
191 drop table t1;
192 connection master;
193 connection slave;
194 show create table t2;
195 Table Create Table
196 t2 CREATE TABLE `t2` (
197 `a` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
198 `b` int(11) DEFAULT NULL
199 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
200 include/diff_tables.inc [master:t2,slave:t2]
201 connection master;
202 drop table t2;
203 connection slave;
204 # C. the bug case on the same version binlogs also to demo on the patch's base
205 include/stop_slave.inc
206 set @@global.slave_parallel_workers = 4;
207 include/start_slave.inc
208 connection slave;
209 include/stop_slave.inc
210 include/reset_slave.inc
211 Warnings:
212 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
213 connection master;
214 reset master;
215 create table t2 (a timestamp, b int);
216 show create table t2;
217 Table Create Table
218 t2 CREATE TABLE `t2` (
219 `a` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
220 `b` int(11) DEFAULT NULL
221 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
222 connection slave;
223 include/start_slave.inc
224 include/stop_slave.inc
225 connection master;
226 connection slave;
227 include/start_slave.inc
228 connection slave;
229 show create table t2;
230 Table Create Table
231 t2 CREATE TABLE `t2` (
232 `a` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
233 `b` int(11) DEFAULT NULL
234 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
235 include/diff_tables.inc [master:t2,slave:t2]
236 connection master;
237 drop table t2;
238 connection slave;
239 connection master;
240 set @@session.explicit_defaults_for_timestamp = @sav.explicit_defaults_for_timestamp;
241 connection slave;
242 set @@global.explicit_defaults_for_timestamp = @sav.explicit_defaults_for_timestamp;
243 include/stop_slave.inc
244 set @@global.slave_parallel_workers = @sav.slave_parallel_workers;
245 include/start_slave.inc
246 include/rpl_end.inc