Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_sp_innodb.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 drop database if exists mysqltest1;
7 create database mysqltest1;
8 use mysqltest1;
9 create table t1 (a varchar(100)) engine=innodb;
10 use mysqltest1;
11 create procedure foo()
12 begin
13 declare b int;
14 set b = 8;
15 insert into t1 values (b);
16 insert into t1 values (unix_timestamp());
17 end|
18 select * from information_schema.routines where routine_schema='mysqltest1' and routine_name='foo';
19 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
20 foo def mysqltest1 foo PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL begin
21 declare b int;
22 set b = 8;
23 insert into t1 values (b);
24 insert into t1 values (unix_timestamp());
25 end NULL SQL SQL NO CONTAINS SQL NULL DEFINER # # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
26 select * from information_schema.routines where routine_schema='mysqltest1' and routine_name='foo';
27 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
28 foo def mysqltest1 foo PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL begin
29 declare b int;
30 set b = 8;
31 insert into t1 values (b);
32 insert into t1 values (unix_timestamp());
33 end NULL SQL SQL NO CONTAINS SQL NULL DEFINER # # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
34 set timestamp=1000000000;
35 call foo();
36 select * from t1;
37 a
38 8
39 1000000000
40 select * from t1;
41 a
42 8
43 1000000000
44 delete from t1;
45 create procedure foo2()
46 select * from mysqltest1.t1;
47 call foo2();
48 a
49 alter procedure foo2 contains sql;
50 set timestamp = DEFAULT;
51 drop table t1;
52 create table t1 (a int) engine=innodb;
53 create table t2 like t1;
54 create procedure foo3()
55 deterministic
56 insert into t1 values (15);
57 create user "zedjzlcsjhd"@127.0.0.1;
58 grant CREATE ROUTINE, EXECUTE on mysqltest1.* to "zedjzlcsjhd"@127.0.0.1;
59 grant SELECT on mysqltest1.t1 to "zedjzlcsjhd"@127.0.0.1;
60 grant SELECT, INSERT on mysqltest1.t2 to "zedjzlcsjhd"@127.0.0.1;
61 SELECT 1;
62 1
63 1
64 create procedure foo4()
65 deterministic
66 begin
67 insert into t2 values(3);
68 insert into t1 values (5);
69 end|
70 call foo4();
71 Got one of the listed errors
72 call foo3();
73 show warnings;
74 Level Code Message
75 call foo4();
76 Got one of the listed errors
77 alter procedure foo4 sql security invoker;
78 call foo4();
79 show warnings;
80 Level Code Message
81 select * from t1;
82 a
83 15
84 5
85 select * from t2;
86 a
87 3
88 3
89 3
90 select * from t1;
91 a
92 15
93 5
94 select * from t2;
95 a
96 3
97 3
98 3
99 delete from t2;
100 alter table t2 add unique (a);
101 drop procedure foo4;
102 create procedure foo4()
103 deterministic
104 begin
105 insert into t2 values(20),(20);
106 end|
107 call foo4();
108 ERROR 23000: Duplicate entry '20' for key 't2.a'
109 show warnings;
110 Level Code Message
111 Error 1062 Duplicate entry '20' for key 't2.a'
112 select * from t2;
113 a
114 select * from t2;
115 a
116 select * from information_schema.routines where routine_schema='mysqltest1' and routine_name='foo4';
117 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
118 foo4 def mysqltest1 foo4 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL begin
119 insert into t2 values(20),(20);
120 end NULL SQL SQL YES CONTAINS SQL NULL DEFINER # # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
121 drop procedure foo4;
122 select * from information_schema.routines where routine_schema='mysqltest1' and routine_name='foo4';
123 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
124 select * from information_schema.routines where routine_schema='mysqltest1' and routine_name='foo4';
125 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
126 drop procedure foo;
127 drop procedure foo2;
128 drop procedure foo3;
129 create function fn1(x int)
130 returns int
131 begin
132 insert into t1 values (x);
133 return x+2;
134 end|
135 ERROR HY000: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
136 create function fn1(x int)
137 returns int
138 deterministic
139 begin
140 insert into t1 values (x);
141 return x+2;
142 end|
143 delete t1,t2 from t1,t2;
144 select fn1(20);
145 fn1(20)
146 22
147 insert into t2 values(fn1(21));
148 select * from t1;
149 a
150 15
151 5
152 20
153 21
154 select * from t2;
155 a
156 23
157 select * from t1;
158 a
159 15
160 5
161 20
162 21
163 select * from t2;
164 a
165 23
166 drop function fn1;
167 create function fn1()
168 returns int
169 no sql
170 begin
171 return unix_timestamp();
172 end|
173 alter function fn1 contains sql;
174 ERROR HY000: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
175 delete from t1;
176 set timestamp=1000000000;
177 insert into t1 values(fn1());
178 create function fn2()
179 returns int
180 no sql
181 begin
182 return unix_timestamp();
183 end|
184 ERROR HY000: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
185 set @old_log_bin_trust_function_creators= @@global.log_bin_trust_function_creators;
186 Warnings:
187 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
188 set global log_bin_trust_function_creators=0;
189 Warnings:
190 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
191 set global log_bin_trust_function_creators=1;
192 Warnings:
193 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
194 set @old_log_bin_trust_function_creators= @@global.log_bin_trust_function_creators;
195 Warnings:
196 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
197 set global log_bin_trust_function_creators=1;
198 Warnings:
199 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
200 create function fn2()
201 returns int
202 no sql
203 begin
204 return unix_timestamp();
205 end|
206 create function fn3()
207 returns int
208 not deterministic
209 reads sql data
210 begin
211 return 0;
212 end|
213 select fn3();
214 fn3()
215 0
216 select * from information_schema.routines where routine_schema='mysqltest1';
217 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
218 fn1 def mysqltest1 fn1 FUNCTION int NULL NULL 10 0 NULL NULL NULL int SQL begin
219 return unix_timestamp();
220 end NULL SQL SQL NO NO SQL NULL DEFINER # # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
221 fn2 def mysqltest1 fn2 FUNCTION int NULL NULL 10 0 NULL NULL NULL int SQL begin
222 return unix_timestamp();
223 end NULL SQL SQL NO NO SQL NULL DEFINER # # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION zedjzlcsjhd@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
224 fn3 def mysqltest1 fn3 FUNCTION int NULL NULL 10 0 NULL NULL NULL int SQL begin
225 return 0;
226 end NULL SQL SQL NO READS SQL DATA NULL DEFINER # # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
227 select * from t1;
228 a
229 1000000000
230 use mysqltest1;
231 select * from t1;
232 a
233 1000000000
234 select * from information_schema.routines where routine_schema='mysqltest1';
235 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
236 fn1 def mysqltest1 fn1 FUNCTION int NULL NULL 10 0 NULL NULL NULL int SQL begin
237 return unix_timestamp();
238 end NULL SQL SQL NO NO SQL NULL DEFINER # # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
239 fn2 def mysqltest1 fn2 FUNCTION int NULL NULL 10 0 NULL NULL NULL int SQL begin
240 return unix_timestamp();
241 end NULL SQL SQL NO NO SQL NULL DEFINER # # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION zedjzlcsjhd@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
242 fn3 def mysqltest1 fn3 FUNCTION int NULL NULL 10 0 NULL NULL NULL int SQL begin
243 return 0;
244 end NULL SQL SQL NO READS SQL DATA NULL DEFINER # # ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
245 delete from t2;
246 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
247 alter table t2 add unique (a);
248 Warnings:
249 Warning 1831 Duplicate index 'a_2' defined on the table 'mysqltest1.t2'. This is deprecated and will be disallowed in a future release.
250 SET sql_mode = default;
251 drop function fn1;
252 create function fn1(x int)
253 returns int
254 begin
255 insert into t2 values(x),(x);
256 return 10;
257 end|
258 do fn1(100);
259 ERROR 23000: Duplicate entry '100' for key 't2.a'
260 select fn1(20);
261 ERROR 23000: Duplicate entry '20' for key 't2.a'
262 select * from t2;
263 a
264 select * from t2;
265 a
266 create trigger trg before insert on t1 for each row set new.a= 10;
267 ERROR 42000: TRIGGER command denied to user 'zedjzlcsjhd'@'localhost' for table 't1'
268 delete from t1;
269 create trigger trg before insert on t1 for each row set new.a= 10;
270 insert into t1 values (1);
271 select * from t1;
272 a
273 10
274 select * from t1;
275 a
276 10
277 delete from t1;
278 drop trigger trg;
279 insert into t1 values (1);
280 select * from t1;
281 a
282 1
283 select * from t1;
284 a
285 1
286 create procedure foo()
287 not deterministic
288 reads sql data
289 select * from t1;
290 call foo();
291 a
292 1
293 drop procedure foo;
294 drop function fn1;
295 drop database mysqltest1;
296 drop user "zedjzlcsjhd"@127.0.0.1;
297 use test;
298 use test;
299 drop function if exists f1;
300 create function f1() returns int reads sql data
301 begin
302 declare var integer;
303 declare c cursor for select a from v1;
304 open c;
305 fetch c into var;
306 close c;
307 return var;
308 end|
309 create view v1 as select 1 as a;
310 create table t1 (a int) engine=innodb;
311 insert into t1 (a) values (f1());
312 select * from t1;
313 a
314 1
315 drop view v1;
316 drop function f1;
317 select * from t1;
318 a
319 1
320 DROP PROCEDURE IF EXISTS p1;
321 DROP TABLE IF EXISTS t1;
322 CREATE TABLE t1(col VARCHAR(10)) engine=innodb;
323 CREATE PROCEDURE p1(arg VARCHAR(10))
324 INSERT INTO t1 VALUES(arg);
325 CALL p1('test');
326 SELECT * FROM t1;
327 col
328 test
329 SELECT * FROM t1;
330 col
331 test
332 DROP PROCEDURE p1;
333
334 ---> Test for BUG#20438
335
336 ---> Preparing environment...
337 ---> connection: master
338 DROP PROCEDURE IF EXISTS p1;
339 DROP FUNCTION IF EXISTS f1;
340
341 ---> Synchronizing slave with master...
342
343 ---> connection: master
344
345 ---> Creating procedure...
346 /*!50003 CREATE PROCEDURE p1() SET @a = 1 */;
347 /*!50003 CREATE FUNCTION f1() RETURNS INT RETURN 0 */;
348
349 ---> Checking on master...
350 SHOW CREATE PROCEDURE p1;
351 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
352 p1 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
353 SET @a = 1 utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
354 SHOW CREATE FUNCTION f1;
355 Function sql_mode Create Function character_set_client collation_connection Database Collation
356 f1 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int
357 RETURN 0 utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
358
359 ---> Synchronizing slave with master...
360 ---> connection: master
361
362 ---> Checking on slave...
363 SHOW CREATE PROCEDURE p1;
364 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
365 p1 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
366 SET @a = 1 utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
367 SHOW CREATE FUNCTION f1;
368 Function sql_mode Create Function character_set_client collation_connection Database Collation
369 f1 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int
370 RETURN 0 utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
371
372 ---> connection: master
373
374 ---> Cleaning up...
375 DROP PROCEDURE p1;
376 DROP FUNCTION f1;
377 drop table t1;
378 drop database if exists mysqltest;
379 drop database if exists mysqltest2;
380 create database mysqltest;
381 create database mysqltest2;
382 use mysqltest2;
383 create table t ( t integer ) engine=innodb;
384 create procedure mysqltest.test() begin end;
385 insert into t values ( 1 );
386 create procedure `\\`.test() begin end;
387 ERROR 42000: Unknown database '\\'
388 create function f1 () returns int
389 begin
390 insert into t values (1);
391 return 0;
392 end|
393 use mysqltest;
394 set @a:= mysqltest2.f1();
395 include/show_binlog_events.inc
396 Log_name Pos Event_type Server_id End_log_pos Info
397 master-bin.000001 # Query # # drop database if exists mysqltest1
398 master-bin.000001 # Query # # create database mysqltest1
399 master-bin.000001 # Query # # use `mysqltest1`; create table t1 (a varchar(100)) engine=innodb
400 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
401 begin
402 declare b int;
403 set b = 8;
404 insert into t1 values (b);
405 insert into t1 values (unix_timestamp());
406 end
407 master-bin.000001 # Query # # BEGIN
408 master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values ( NAME_CONST('b',8))
409 master-bin.000001 # Query # # COMMIT
410 master-bin.000001 # Query # # BEGIN
411 master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (unix_timestamp())
412 master-bin.000001 # Query # # COMMIT
413 master-bin.000001 # Query # # BEGIN
414 master-bin.000001 # Query # # use `mysqltest1`; delete from t1
415 master-bin.000001 # Query # # COMMIT
416 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo2`()
417 select * from mysqltest1.t1
418 master-bin.000001 # Query # # use `mysqltest1`; alter procedure foo2 contains sql
419 master-bin.000001 # Query # # use `mysqltest1`; DROP TABLE `t1` /* generated by server */
420 master-bin.000001 # Query # # use `mysqltest1`; create table t1 (a int) engine=innodb
421 master-bin.000001 # Query # # use `mysqltest1`; create table t2 like t1
422 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo3`()
423 DETERMINISTIC
424 insert into t1 values (15)
425 master-bin.000001 # Query # # use `mysqltest1`; CREATE USER 'zedjzlcsjhd'@'127.0.0.1' IDENTIFIED WITH 'caching_sha2_password'
426 master-bin.000001 # Query # # use `mysqltest1`; GRANT EXECUTE, CREATE ROUTINE ON `mysqltest1`.* TO 'zedjzlcsjhd'@'127.0.0.1'
427 master-bin.000001 # Query # # use `mysqltest1`; GRANT SELECT ON `mysqltest1`.`t1` TO 'zedjzlcsjhd'@'127.0.0.1'
428 master-bin.000001 # Query # # use `mysqltest1`; GRANT SELECT, INSERT ON `mysqltest1`.`t2` TO 'zedjzlcsjhd'@'127.0.0.1'
429 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` PROCEDURE `foo4`()
430 DETERMINISTIC
431 begin
432 insert into t2 values(3);
433 insert into t1 values (5);
434 end
435 master-bin.000001 # Query # # BEGIN
436 master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(3)
437 master-bin.000001 # Query # # COMMIT
438 master-bin.000001 # Query # # BEGIN
439 master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (15)
440 master-bin.000001 # Query # # COMMIT
441 master-bin.000001 # Query # # BEGIN
442 master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(3)
443 master-bin.000001 # Query # # COMMIT
444 master-bin.000001 # Query # # use `mysqltest1`; alter procedure foo4 sql security invoker
445 master-bin.000001 # Query # # BEGIN
446 master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(3)
447 master-bin.000001 # Query # # COMMIT
448 master-bin.000001 # Query # # BEGIN
449 master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (5)
450 master-bin.000001 # Query # # COMMIT
451 master-bin.000001 # Query # # BEGIN
452 master-bin.000001 # Query # # use `mysqltest1`; delete from t2
453 master-bin.000001 # Query # # COMMIT
454 master-bin.000001 # Query # # use `mysqltest1`; alter table t2 add unique (a)
455 master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo4
456 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo4`()
457 DETERMINISTIC
458 begin
459 insert into t2 values(20),(20);
460 end
461 master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo4
462 master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo
463 master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo2
464 master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo3
465 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int
466 DETERMINISTIC
467 begin
468 insert into t1 values (x);
469 return x+2;
470 end
471 master-bin.000001 # Query # # BEGIN
472 master-bin.000001 # Query # # use `mysqltest1`; delete t1,t2 from t1,t2
473 master-bin.000001 # Query # # COMMIT
474 master-bin.000001 # Query # # BEGIN
475 master-bin.000001 # Query # # use `mysqltest1`; SELECT `mysqltest1`.`fn1`(20)
476 master-bin.000001 # Query # # COMMIT
477 master-bin.000001 # Query # # BEGIN
478 master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(fn1(21))
479 master-bin.000001 # Query # # COMMIT
480 master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
481 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`() RETURNS int
482 NO SQL
483 begin
484 return unix_timestamp();
485 end
486 master-bin.000001 # Query # # BEGIN
487 master-bin.000001 # Query # # use `mysqltest1`; delete from t1
488 master-bin.000001 # Query # # COMMIT
489 master-bin.000001 # Query # # BEGIN
490 master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values(fn1())
491 master-bin.000001 # Query # # COMMIT
492 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` FUNCTION `fn2`() RETURNS int
493 NO SQL
494 begin
495 return unix_timestamp();
496 end
497 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn3`() RETURNS int
498 READS SQL DATA
499 begin
500 return 0;
501 end
502 master-bin.000001 # Query # # BEGIN
503 master-bin.000001 # Query # # use `mysqltest1`; delete from t2
504 master-bin.000001 # Query # # COMMIT
505 master-bin.000001 # Query # # use `mysqltest1`; alter table t2 add unique (a)
506 master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
507 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int
508 begin
509 insert into t2 values(x),(x);
510 return 10;
511 end
512 master-bin.000001 # Query # # BEGIN
513 master-bin.000001 # Query # # use `mysqltest1`; delete from t1
514 master-bin.000001 # Query # # COMMIT
515 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` trigger trg before insert on t1 for each row set new.a= 10
516 master-bin.000001 # Query # # BEGIN
517 master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (1)
518 master-bin.000001 # Query # # COMMIT
519 master-bin.000001 # Query # # BEGIN
520 master-bin.000001 # Query # # use `mysqltest1`; delete from t1
521 master-bin.000001 # Query # # COMMIT
522 master-bin.000001 # Query # # use `mysqltest1`; drop trigger trg
523 master-bin.000001 # Query # # BEGIN
524 master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (1)
525 master-bin.000001 # Query # # COMMIT
526 master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
527 READS SQL DATA
528 select * from t1
529 master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo
530 master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
531 master-bin.000001 # Query # # drop database mysqltest1
532 master-bin.000001 # Query # # drop user "zedjzlcsjhd"@127.0.0.1
533 master-bin.000001 # Query # # use `test`; drop function if exists f1
534 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int
535 READS SQL DATA
536 begin
537 declare var integer;
538 declare c cursor for select a from v1;
539 open c;
540 fetch c into var;
541 close c;
542 return var;
543 end
544 master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 as a
545 master-bin.000001 # Query # # use `test`; create table t1 (a int) engine=innodb
546 master-bin.000001 # Query # # BEGIN
547 master-bin.000001 # Query # # use `test`; insert into t1 (a) values (f1())
548 master-bin.000001 # Query # # COMMIT
549 master-bin.000001 # Query # # use `test`; drop view v1
550 master-bin.000001 # Query # # use `test`; drop function f1
551 master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS p1
552 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
553 master-bin.000001 # Query # # use `test`; CREATE TABLE t1(col VARCHAR(10)) engine=innodb
554 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(arg VARCHAR(10))
555 INSERT INTO t1 VALUES(arg)
556 master-bin.000001 # Query # # BEGIN
557 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES( NAME_CONST('arg',_utf8mb4'test' COLLATE 'utf8mb4_0900_ai_ci'))
558 master-bin.000001 # Query # # COMMIT
559 master-bin.000001 # Query # # use `test`; DROP PROCEDURE p1
560 master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS p1
561 master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS f1
562 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
563 SET @a = 1
564 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int
565 RETURN 0
566 master-bin.000001 # Query # # use `test`; DROP PROCEDURE p1
567 master-bin.000001 # Query # # use `test`; DROP FUNCTION f1
568 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
569 master-bin.000001 # Query # # drop database if exists mysqltest
570 master-bin.000001 # Query # # drop database if exists mysqltest2
571 master-bin.000001 # Query # # create database mysqltest
572 master-bin.000001 # Query # # create database mysqltest2
573 master-bin.000001 # Query # # use `mysqltest2`; create table t ( t integer ) engine=innodb
574 master-bin.000001 # Query # # use `mysqltest2`; CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltest`.`test`()
575 begin end
576 master-bin.000001 # Query # # BEGIN
577 master-bin.000001 # Query # # use `mysqltest2`; insert into t values ( 1 )
578 master-bin.000001 # Query # # COMMIT
579 master-bin.000001 # Query # # use `mysqltest2`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int
580 begin
581 insert into t values (1);
582 return 0;
583 end
584 master-bin.000001 # Query # # BEGIN
585 master-bin.000001 # Query # # use `mysqltest`; SELECT `mysqltest2`.`f1`()
586 master-bin.000001 # Query # # COMMIT
587 set @@global.log_bin_trust_function_creators= @old_log_bin_trust_function_creators;
588 Warnings:
589 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
590 set @@global.log_bin_trust_function_creators= @old_log_bin_trust_function_creators;
591 Warnings:
592 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
593 drop database mysqltest;
594 drop database mysqltest2;
595 use test;
596 /*!50001 create procedure `mysqltestbug36570_p1`() */
597 begin
598 select 1;
599 end|
600 use mysql|
601 create procedure test.` mysqltestbug36570_p2`(/*!50001 a int*/)`label`:
602 begin
603 select a;
604 end|
605 /*!50001 create function test.mysqltestbug36570_f1() */
606 returns int
607 /*!50001 deterministic */
608 begin
609 return 3;
610 end|
611 use test|
612 show procedure status like '%mysqltestbug36570%';
613 Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
614 test mysqltestbug36570_p2 PROCEDURE root@localhost t t DEFINER utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
615 test mysqltestbug36570_p1 PROCEDURE root@localhost t t DEFINER utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
616 show create procedure ` mysqltestbug36570_p2`;
617 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
618 mysqltestbug36570_p2 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE ` mysqltestbug36570_p2`( a int )
619 `label`:
620 begin
621 select a;
622 end utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
623 show procedure status like '%mysqltestbug36570%';
624 Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
625 test mysqltestbug36570_p2 PROCEDURE root@localhost t t DEFINER utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
626 test mysqltestbug36570_p1 PROCEDURE root@localhost t t DEFINER utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
627 show create procedure ` mysqltestbug36570_p2`;
628 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
629 mysqltestbug36570_p2 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE ` mysqltestbug36570_p2`( a int )
630 `label`:
631 begin
632 select a;
633 end utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
634 call ` mysqltestbug36570_p2`(42);
635 a
636 42
637 show function status like '%mysqltestbug36570%';
638 Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
639 test mysqltestbug36570_f1 FUNCTION root@localhost t t DEFINER utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
640 flush logs;
641 include/mysqlbinlog.inc
642 # The proper term is pseudo_replica_mode, but we use this compatibility alias
643 # to make the statement usable on server versions 8.0.24 and older.
644 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
645 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
646 DELIMITER /*!*/;
647 ROLLBACK/*!*/;
648 # [empty]
649 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
650 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
651 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
652 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
653 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
654 SET @@SESSION.GTID_NEXT= '#'/*!*/;
655 SET TIMESTAMP=#/*!*/;
656 SET @@session.pseudo_thread_id=#/*!*/;
657 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
658 SET @@session.sql_mode=1168113696/*!*/;
659 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
660 /*!\C utf8mb4 *//*!*/;
661 SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
662 SET @@session.lc_time_names=0/*!*/;
663 SET @@session.collation_database=DEFAULT/*!*/;
664 /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
665 drop database if exists mysqltest1
666 /*!*/;
667 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
668 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
669 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
670 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
671 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
672 SET @@SESSION.GTID_NEXT= '#'/*!*/;
673 SET TIMESTAMP=#/*!*/;
674 /*!80016 SET @@session.default_table_encryption=0*//*!*/;
675 create database mysqltest1
676 /*!*/;
677 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
678 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
679 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
680 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
681 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
682 SET @@SESSION.GTID_NEXT= '#'/*!*/;
683 use `mysqltest1`/*!*/;
684 SET TIMESTAMP=#/*!*/;
685 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
686 create table t1 (a varchar(100)) engine=innodb
687 /*!*/;
688 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
689 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
690 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
691 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
692 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
693 SET @@SESSION.GTID_NEXT= '#'/*!*/;
694 SET TIMESTAMP=#/*!*/;
695 CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
696 begin
697 declare b int;
698 set b = 8;
699 insert into t1 values (b);
700 insert into t1 values (unix_timestamp());
701 end
702 /*!*/;
703 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
704 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
705 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
706 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
707 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
708 SET @@SESSION.GTID_NEXT= '#'/*!*/;
709 SET TIMESTAMP=#/*!*/;
710 BEGIN
711 /*!*/;
712 SET TIMESTAMP=#/*!*/;
713 insert into t1 values ( NAME_CONST('b',8))
714 /*!*/;
715 COMMIT/*!*/;
716 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
717 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
718 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
719 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
720 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
721 SET @@SESSION.GTID_NEXT= '#'/*!*/;
722 SET TIMESTAMP=#/*!*/;
723 BEGIN
724 /*!*/;
725 SET TIMESTAMP=#/*!*/;
726 insert into t1 values (unix_timestamp())
727 /*!*/;
728 COMMIT/*!*/;
729 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
730 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
731 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
732 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
733 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
734 SET @@SESSION.GTID_NEXT= '#'/*!*/;
735 SET TIMESTAMP=#/*!*/;
736 BEGIN
737 /*!*/;
738 SET TIMESTAMP=#/*!*/;
739 delete from t1
740 /*!*/;
741 COMMIT/*!*/;
742 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
743 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
744 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
745 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
746 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
747 SET @@SESSION.GTID_NEXT= '#'/*!*/;
748 SET TIMESTAMP=#/*!*/;
749 CREATE DEFINER=`root`@`localhost` PROCEDURE `foo2`()
750 select * from mysqltest1.t1
751 /*!*/;
752 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
753 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
754 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
755 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
756 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
757 SET @@SESSION.GTID_NEXT= '#'/*!*/;
758 SET TIMESTAMP=#/*!*/;
759 alter procedure foo2 contains sql
760 /*!*/;
761 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
762 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
763 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
764 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
765 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
766 SET @@SESSION.GTID_NEXT= '#'/*!*/;
767 SET TIMESTAMP=#/*!*/;
768 DROP TABLE `t1` /* generated by server */
769 /*!*/;
770 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
771 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
772 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
773 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
774 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
775 SET @@SESSION.GTID_NEXT= '#'/*!*/;
776 SET TIMESTAMP=#/*!*/;
777 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
778 create table t1 (a int) engine=innodb
779 /*!*/;
780 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
781 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
782 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
783 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
784 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
785 SET @@SESSION.GTID_NEXT= '#'/*!*/;
786 SET TIMESTAMP=#/*!*/;
787 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
788 create table t2 like t1
789 /*!*/;
790 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
791 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
792 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
793 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
794 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
795 SET @@SESSION.GTID_NEXT= '#'/*!*/;
796 SET TIMESTAMP=#/*!*/;
797 CREATE DEFINER=`root`@`localhost` PROCEDURE `foo3`()
798 DETERMINISTIC
799 insert into t1 values (15)
800 /*!*/;
801 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
802 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
803 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
804 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
805 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
806 SET @@SESSION.GTID_NEXT= '#'/*!*/;
807 SET TIMESTAMP=#/*!*/;
808 CREATE USER 'zedjzlcsjhd'@'127.0.0.1' IDENTIFIED WITH 'caching_sha2_password'
809 /*!*/;
810 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
811 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
812 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
813 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
814 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
815 SET @@SESSION.GTID_NEXT= '#'/*!*/;
816 SET TIMESTAMP=#/*!*/;
817 GRANT EXECUTE, CREATE ROUTINE ON `mysqltest1`.* TO 'zedjzlcsjhd'@'127.0.0.1'
818 /*!*/;
819 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
820 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
821 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
822 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
823 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
824 SET @@SESSION.GTID_NEXT= '#'/*!*/;
825 SET TIMESTAMP=#/*!*/;
826 GRANT SELECT ON `mysqltest1`.`t1` TO 'zedjzlcsjhd'@'127.0.0.1'
827 /*!*/;
828 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
829 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
830 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
831 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
832 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
833 SET @@SESSION.GTID_NEXT= '#'/*!*/;
834 SET TIMESTAMP=#/*!*/;
835 GRANT SELECT, INSERT ON `mysqltest1`.`t2` TO 'zedjzlcsjhd'@'127.0.0.1'
836 /*!*/;
837 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
838 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
839 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
840 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
841 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
842 SET @@SESSION.GTID_NEXT= '#'/*!*/;
843 SET TIMESTAMP=#/*!*/;
844 CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` PROCEDURE `foo4`()
845 DETERMINISTIC
846 begin
847 insert into t2 values(3);
848 insert into t1 values (5);
849 end
850 /*!*/;
851 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
852 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
853 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
854 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
855 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
856 SET @@SESSION.GTID_NEXT= '#'/*!*/;
857 SET TIMESTAMP=#/*!*/;
858 BEGIN
859 /*!*/;
860 SET TIMESTAMP=#/*!*/;
861 insert into t2 values(3)
862 /*!*/;
863 COMMIT/*!*/;
864 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
865 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
866 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
867 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
868 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
869 SET @@SESSION.GTID_NEXT= '#'/*!*/;
870 SET TIMESTAMP=#/*!*/;
871 BEGIN
872 /*!*/;
873 SET TIMESTAMP=#/*!*/;
874 insert into t1 values (15)
875 /*!*/;
876 COMMIT/*!*/;
877 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
878 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
879 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
880 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
881 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
882 SET @@SESSION.GTID_NEXT= '#'/*!*/;
883 SET TIMESTAMP=#/*!*/;
884 BEGIN
885 /*!*/;
886 SET TIMESTAMP=#/*!*/;
887 insert into t2 values(3)
888 /*!*/;
889 COMMIT/*!*/;
890 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
891 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
892 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
893 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
894 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
895 SET @@SESSION.GTID_NEXT= '#'/*!*/;
896 SET TIMESTAMP=#/*!*/;
897 alter procedure foo4 sql security invoker
898 /*!*/;
899 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
900 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
901 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
902 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
903 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
904 SET @@SESSION.GTID_NEXT= '#'/*!*/;
905 SET TIMESTAMP=#/*!*/;
906 BEGIN
907 /*!*/;
908 SET TIMESTAMP=#/*!*/;
909 insert into t2 values(3)
910 /*!*/;
911 COMMIT/*!*/;
912 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
913 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
914 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
915 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
916 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
917 SET @@SESSION.GTID_NEXT= '#'/*!*/;
918 SET TIMESTAMP=#/*!*/;
919 BEGIN
920 /*!*/;
921 SET TIMESTAMP=#/*!*/;
922 insert into t1 values (5)
923 /*!*/;
924 COMMIT/*!*/;
925 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
926 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
927 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
928 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
929 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
930 SET @@SESSION.GTID_NEXT= '#'/*!*/;
931 SET TIMESTAMP=#/*!*/;
932 BEGIN
933 /*!*/;
934 SET TIMESTAMP=#/*!*/;
935 delete from t2
936 /*!*/;
937 COMMIT/*!*/;
938 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
939 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
940 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
941 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
942 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
943 SET @@SESSION.GTID_NEXT= '#'/*!*/;
944 SET TIMESTAMP=#/*!*/;
945 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
946 alter table t2 add unique (a)
947 /*!*/;
948 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
949 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
950 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
951 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
952 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
953 SET @@SESSION.GTID_NEXT= '#'/*!*/;
954 SET TIMESTAMP=#/*!*/;
955 drop procedure foo4
956 /*!*/;
957 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
958 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
959 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
960 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
961 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
962 SET @@SESSION.GTID_NEXT= '#'/*!*/;
963 SET TIMESTAMP=#/*!*/;
964 CREATE DEFINER=`root`@`localhost` PROCEDURE `foo4`()
965 DETERMINISTIC
966 begin
967 insert into t2 values(20),(20);
968 end
969 /*!*/;
970 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
971 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
972 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
973 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
974 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
975 SET @@SESSION.GTID_NEXT= '#'/*!*/;
976 SET TIMESTAMP=#/*!*/;
977 drop procedure foo4
978 /*!*/;
979 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
980 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
981 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
982 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
983 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
984 SET @@SESSION.GTID_NEXT= '#'/*!*/;
985 SET TIMESTAMP=#/*!*/;
986 drop procedure foo
987 /*!*/;
988 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
989 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
990 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
991 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
992 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
993 SET @@SESSION.GTID_NEXT= '#'/*!*/;
994 SET TIMESTAMP=#/*!*/;
995 drop procedure foo2
996 /*!*/;
997 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
998 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
999 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1000 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1001 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1002 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1003 SET TIMESTAMP=#/*!*/;
1004 drop procedure foo3
1005 /*!*/;
1006 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1007 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1008 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1009 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1010 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1011 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1012 SET TIMESTAMP=#/*!*/;
1013 CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int
1014 DETERMINISTIC
1015 begin
1016 insert into t1 values (x);
1017 return x+2;
1018 end
1019 /*!*/;
1020 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1021 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1022 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1023 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1024 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1025 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1026 SET TIMESTAMP=#/*!*/;
1027 BEGIN
1028 /*!*/;
1029 SET TIMESTAMP=#/*!*/;
1030 delete t1,t2 from t1,t2
1031 /*!*/;
1032 SET TIMESTAMP=#/*!*/;
1033 COMMIT
1034 /*!*/;
1035 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1036 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1037 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1038 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1039 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1040 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1041 SET TIMESTAMP=#/*!*/;
1042 BEGIN
1043 /*!*/;
1044 SET TIMESTAMP=#/*!*/;
1045 SELECT `mysqltest1`.`fn1`(20)
1046 /*!*/;
1047 COMMIT/*!*/;
1048 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1049 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1050 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1051 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1052 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1053 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1054 SET TIMESTAMP=#/*!*/;
1055 BEGIN
1056 /*!*/;
1057 SET TIMESTAMP=#/*!*/;
1058 insert into t2 values(fn1(21))
1059 /*!*/;
1060 COMMIT/*!*/;
1061 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1062 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1063 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1064 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1065 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1066 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1067 SET TIMESTAMP=#/*!*/;
1068 drop function fn1
1069 /*!*/;
1070 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1071 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1072 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1073 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1074 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1075 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1076 SET TIMESTAMP=#/*!*/;
1077 CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`() RETURNS int
1078 NO SQL
1079 begin
1080 return unix_timestamp();
1081 end
1082 /*!*/;
1083 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1084 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1085 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1086 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1087 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1088 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1089 SET TIMESTAMP=#/*!*/;
1090 BEGIN
1091 /*!*/;
1092 SET TIMESTAMP=#/*!*/;
1093 delete from t1
1094 /*!*/;
1095 COMMIT/*!*/;
1096 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1097 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1098 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1099 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1100 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1101 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1102 SET TIMESTAMP=#/*!*/;
1103 BEGIN
1104 /*!*/;
1105 SET TIMESTAMP=#/*!*/;
1106 insert into t1 values(fn1())
1107 /*!*/;
1108 COMMIT/*!*/;
1109 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1110 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1111 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1112 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1113 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1114 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1115 SET TIMESTAMP=#/*!*/;
1116 CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` FUNCTION `fn2`() RETURNS int
1117 NO SQL
1118 begin
1119 return unix_timestamp();
1120 end
1121 /*!*/;
1122 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1123 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1124 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1125 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1126 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1127 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1128 SET TIMESTAMP=#/*!*/;
1129 CREATE DEFINER=`root`@`localhost` FUNCTION `fn3`() RETURNS int
1130 READS SQL DATA
1131 begin
1132 return 0;
1133 end
1134 /*!*/;
1135 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1136 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1137 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1138 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1139 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1140 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1141 SET TIMESTAMP=#/*!*/;
1142 BEGIN
1143 /*!*/;
1144 SET TIMESTAMP=#/*!*/;
1145 delete from t2
1146 /*!*/;
1147 COMMIT/*!*/;
1148 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1149 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1150 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1151 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1152 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1153 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1154 SET TIMESTAMP=#/*!*/;
1155 SET @@session.sql_mode=1073741824/*!*/;
1156 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
1157 alter table t2 add unique (a)
1158 /*!*/;
1159 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1160 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1161 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1162 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1163 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1164 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1165 SET TIMESTAMP=#/*!*/;
1166 SET @@session.sql_mode=1168113696/*!*/;
1167 drop function fn1
1168 /*!*/;
1169 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1170 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1171 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1172 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1173 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1174 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1175 SET TIMESTAMP=#/*!*/;
1176 CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int
1177 begin
1178 insert into t2 values(x),(x);
1179 return 10;
1180 end
1181 /*!*/;
1182 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1183 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1184 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1185 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1186 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1187 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1188 SET TIMESTAMP=#/*!*/;
1189 BEGIN
1190 /*!*/;
1191 SET TIMESTAMP=#/*!*/;
1192 delete from t1
1193 /*!*/;
1194 COMMIT/*!*/;
1195 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1196 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1197 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1198 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1199 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1200 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1201 SET TIMESTAMP=#/*!*/;
1202 CREATE DEFINER=`root`@`localhost` trigger trg before insert on t1 for each row set new.a= 10
1203 /*!*/;
1204 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1205 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1206 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1207 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1208 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1209 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1210 SET TIMESTAMP=#/*!*/;
1211 BEGIN
1212 /*!*/;
1213 SET TIMESTAMP=#/*!*/;
1214 insert into t1 values (1)
1215 /*!*/;
1216 COMMIT/*!*/;
1217 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1218 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1219 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1220 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1221 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1222 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1223 SET TIMESTAMP=#/*!*/;
1224 BEGIN
1225 /*!*/;
1226 SET TIMESTAMP=#/*!*/;
1227 delete from t1
1228 /*!*/;
1229 COMMIT/*!*/;
1230 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1231 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1232 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1233 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1234 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1235 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1236 SET TIMESTAMP=#/*!*/;
1237 drop trigger trg
1238 /*!*/;
1239 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1240 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1241 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1242 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1243 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1244 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1245 SET TIMESTAMP=#/*!*/;
1246 BEGIN
1247 /*!*/;
1248 SET TIMESTAMP=#/*!*/;
1249 insert into t1 values (1)
1250 /*!*/;
1251 COMMIT/*!*/;
1252 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1253 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1254 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1255 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1256 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1257 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1258 SET TIMESTAMP=#/*!*/;
1259 CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
1260 READS SQL DATA
1261 select * from t1
1262 /*!*/;
1263 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1264 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1265 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1266 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1267 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1268 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1269 SET TIMESTAMP=#/*!*/;
1270 drop procedure foo
1271 /*!*/;
1272 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1273 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1274 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1275 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1276 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1277 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1278 SET TIMESTAMP=#/*!*/;
1279 drop function fn1
1280 /*!*/;
1281 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1282 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1283 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1284 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1285 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1286 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1287 SET TIMESTAMP=#/*!*/;
1288 drop database mysqltest1
1289 /*!*/;
1290 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1291 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1292 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1293 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1294 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1295 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1296 SET TIMESTAMP=#/*!*/;
1297 drop user "zedjzlcsjhd"@127.0.0.1
1298 /*!*/;
1299 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1300 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1301 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1302 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1303 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1304 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1305 use `test`/*!*/;
1306 SET TIMESTAMP=#/*!*/;
1307 drop function if exists f1
1308 /*!*/;
1309 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1310 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1311 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1312 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1313 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1314 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1315 SET TIMESTAMP=#/*!*/;
1316 CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int
1317 READS SQL DATA
1318 begin
1319 declare var integer;
1320 declare c cursor for select a from v1;
1321 open c;
1322 fetch c into var;
1323 close c;
1324 return var;
1325 end
1326 /*!*/;
1327 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1328 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1329 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1330 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1331 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1332 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1333 SET TIMESTAMP=#/*!*/;
1334 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 as a
1335 /*!*/;
1336 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1337 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1338 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1339 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1340 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1341 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1342 SET TIMESTAMP=#/*!*/;
1343 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
1344 create table t1 (a int) engine=innodb
1345 /*!*/;
1346 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1347 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1348 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1349 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1350 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1351 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1352 SET TIMESTAMP=#/*!*/;
1353 BEGIN
1354 /*!*/;
1355 SET TIMESTAMP=#/*!*/;
1356 insert into t1 (a) values (f1())
1357 /*!*/;
1358 COMMIT/*!*/;
1359 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1360 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1361 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1362 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1363 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1364 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1365 SET TIMESTAMP=#/*!*/;
1366 drop view v1
1367 /*!*/;
1368 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1369 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1370 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1371 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1372 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1373 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1374 SET TIMESTAMP=#/*!*/;
1375 drop function f1
1376 /*!*/;
1377 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1378 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1379 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1380 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1381 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1382 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1383 SET TIMESTAMP=#/*!*/;
1384 DROP PROCEDURE IF EXISTS p1
1385 /*!*/;
1386 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1387 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1388 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1389 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1390 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1391 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1392 SET TIMESTAMP=#/*!*/;
1393 DROP TABLE IF EXISTS `t1` /* generated by server */
1394 /*!*/;
1395 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1396 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1397 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1398 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1399 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1400 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1401 SET TIMESTAMP=#/*!*/;
1402 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
1403 CREATE TABLE t1(col VARCHAR(10)) engine=innodb
1404 /*!*/;
1405 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1406 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1407 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1408 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1409 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1410 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1411 SET TIMESTAMP=#/*!*/;
1412 CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(arg VARCHAR(10))
1413 INSERT INTO t1 VALUES(arg)
1414 /*!*/;
1415 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1416 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1417 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1418 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1419 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1420 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1421 SET TIMESTAMP=#/*!*/;
1422 BEGIN
1423 /*!*/;
1424 SET TIMESTAMP=#/*!*/;
1425 INSERT INTO t1 VALUES( NAME_CONST('arg',_utf8mb4'test' COLLATE 'utf8mb4_0900_ai_ci'))
1426 /*!*/;
1427 COMMIT/*!*/;
1428 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1429 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1430 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1431 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1432 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1433 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1434 SET TIMESTAMP=#/*!*/;
1435 DROP PROCEDURE p1
1436 /*!*/;
1437 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1438 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1439 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1440 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1441 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1442 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1443 SET TIMESTAMP=#/*!*/;
1444 DROP PROCEDURE IF EXISTS p1
1445 /*!*/;
1446 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1447 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1448 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1449 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1450 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1451 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1452 SET TIMESTAMP=#/*!*/;
1453 DROP FUNCTION IF EXISTS f1
1454 /*!*/;
1455 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1456 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1457 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1458 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1459 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1460 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1461 SET TIMESTAMP=#/*!*/;
1462 CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
1463 SET @a = 1
1464 /*!*/;
1465 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1466 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1467 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1468 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1469 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1470 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1471 SET TIMESTAMP=#/*!*/;
1472 CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int
1473 RETURN 0
1474 /*!*/;
1475 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1476 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1477 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1478 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1479 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1480 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1481 SET TIMESTAMP=#/*!*/;
1482 DROP PROCEDURE p1
1483 /*!*/;
1484 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1485 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1486 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1487 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1488 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1489 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1490 SET TIMESTAMP=#/*!*/;
1491 DROP FUNCTION f1
1492 /*!*/;
1493 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1494 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1495 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1496 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1497 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1498 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1499 SET TIMESTAMP=#/*!*/;
1500 DROP TABLE `t1` /* generated by server */
1501 /*!*/;
1502 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1503 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1504 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1505 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1506 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1507 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1508 SET TIMESTAMP=#/*!*/;
1509 drop database if exists mysqltest
1510 /*!*/;
1511 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1512 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1513 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1514 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1515 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1516 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1517 SET TIMESTAMP=#/*!*/;
1518 drop database if exists mysqltest2
1519 /*!*/;
1520 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1521 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1522 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1523 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1524 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1525 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1526 SET TIMESTAMP=#/*!*/;
1527 /*!80016 SET @@session.default_table_encryption=0*//*!*/;
1528 create database mysqltest
1529 /*!*/;
1530 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1531 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1532 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1533 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1534 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1535 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1536 SET TIMESTAMP=#/*!*/;
1537 /*!80016 SET @@session.default_table_encryption=0*//*!*/;
1538 create database mysqltest2
1539 /*!*/;
1540 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1541 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1542 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1543 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1544 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1545 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1546 use `mysqltest2`/*!*/;
1547 SET TIMESTAMP=#/*!*/;
1548 /*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
1549 create table t ( t integer ) engine=innodb
1550 /*!*/;
1551 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1552 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1553 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1554 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1555 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1556 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1557 SET TIMESTAMP=#/*!*/;
1558 CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltest`.`test`()
1559 begin end
1560 /*!*/;
1561 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1562 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1563 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1564 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1565 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1566 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1567 SET TIMESTAMP=#/*!*/;
1568 BEGIN
1569 /*!*/;
1570 SET TIMESTAMP=#/*!*/;
1571 insert into t values ( 1 )
1572 /*!*/;
1573 COMMIT/*!*/;
1574 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1575 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1576 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1577 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1578 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1579 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1580 SET TIMESTAMP=#/*!*/;
1581 CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int
1582 begin
1583 insert into t values (1);
1584 return 0;
1585 end
1586 /*!*/;
1587 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1588 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1589 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1590 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1591 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1592 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1593 SET TIMESTAMP=#/*!*/;
1594 BEGIN
1595 /*!*/;
1596 use `mysqltest`/*!*/;
1597 SET TIMESTAMP=#/*!*/;
1598 SELECT `mysqltest2`.`f1`()
1599 /*!*/;
1600 COMMIT/*!*/;
1601 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1602 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1603 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1604 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1605 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1606 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1607 SET TIMESTAMP=#/*!*/;
1608 drop database mysqltest
1609 /*!*/;
1610 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1611 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1612 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1613 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1614 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1615 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1616 SET TIMESTAMP=#/*!*/;
1617 drop database mysqltest2
1618 /*!*/;
1619 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1620 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1621 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1622 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1623 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1624 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1625 use `test`/*!*/;
1626 SET TIMESTAMP=#/*!*/;
1627 CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltestbug36570_p1`()
1628 begin
1629 select 1;
1630 end
1631 /*!*/;
1632 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1633 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1634 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1635 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1636 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1637 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1638 use `mysql`/*!*/;
1639 SET TIMESTAMP=#/*!*/;
1640 CREATE DEFINER=`root`@`localhost` PROCEDURE `test`.` mysqltestbug36570_p2`( a int )
1641 `label`:
1642 begin
1643 select a;
1644 end
1645 /*!*/;
1646 # original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1647 # immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
1648 /*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
1649 /*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
1650 /*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
1651 SET @@SESSION.GTID_NEXT= '#'/*!*/;
1652 SET TIMESTAMP=#/*!*/;
1653 CREATE DEFINER=`root`@`localhost` FUNCTION `test`.`mysqltestbug36570_f1`() RETURNS int
1654 DETERMINISTIC
1655 begin
1656 return 3;
1657 end
1658 /*!*/;
1659 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
1660 DELIMITER ;
1661 # End of log file
1662 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
1663 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
1664 use test;
1665 drop procedure mysqltestbug36570_p1;
1666 drop procedure ` mysqltestbug36570_p2`;
1667 drop function mysqltestbug36570_f1;
1668 End of 5.0 tests
1669 # End of 5.1 tests
1670 #
1671 # Test Bug#30977 Concurrent statement using stored
1672 # function and DROP FUNCTION breaks SBR.
1673 #
1674 # Demonstrate that stored function DDL can not go through,
1675 # or, worse yet, make its way into the binary log, while
1676 # the stored function is in use.
1677 # For that, try to insert a result of a stored function
1678 # into a table. Block the insert in the beginning, waiting
1679 # on a table lock. While insert is blocked, attempt to
1680 # drop the routine. Verify that this attempt
1681 # blocks and waits for INSERT to complete. Commit and
1682 # reap the chain of events. Master and slave must contain
1683 # identical data. Statements in the binrary log must be
1684 # consistent with data in the table.
1685 #
1686 # --> connection default
1687 drop table if exists t1, t2;
1688 drop function if exists t1;
1689 create table t1 (a int) engine=innodb;
1690 create table t2 (a int) engine=innodb as select 1 as a;
1691 create function f1() returns int deterministic return (select max(a) from t2);
1692 lock table t2 write;
1693 # --> connection master
1694 # Sending 'insert into t1 (a) values (f1())'...
1695 insert into t1 (a) values (f1());
1696 # Waitng for 'insert into t1 ...' to get blocked on table lock...
1697 # Sending 'drop function f1'. It will wait till insert finishes.
1698 drop function f1;;
1699 # --> connection default
1700 # Check that 'drop function f1' gets blocked.
1701 # Now let's let 'insert' go through...
1702 unlock tables;
1703 # --> connection master
1704 # Reaping 'insert into t1 (a) values (f1())'...
1705 # --> connection master1
1706 # Reaping 'drop function f1'
1707 # --> connection master
1708 select * from t1;
1709 a
1710 1
1711 select * from t1;
1712 a
1713 1
1714 drop table t1, t2;
1715 drop function f1;
1716 ERROR 42000: FUNCTION test.f1 does not exist
1717 #
1718 # Bug #11918 Can't use a declared variable in LIMIT clause
1719 #
1720 include/rpl_reset.inc
1721 create table t1 (c1 int) engine=innodb;
1722 insert into t1 (c1) values
1723 (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
1724 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
1725 create procedure p1(p1 integer)
1726 delete from t1 limit p1;
1727 set @save_binlog_format=@@session.binlog_format;
1728 Warnings:
1729 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1730 set @@session.binlog_format=STATEMENT;
1731 Warnings:
1732 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1733 call p1(NULL);
1734 call p1(0);
1735 call p1(1);
1736 call p1(2);
1737 call p1(3);
1738 select * from t1;
1739 c1
1740 7
1741 8
1742 9
1743 10
1744 select * from t1;
1745 c1
1746 7
1747 8
1748 9
1749 10
1750 call p1(-1);
1751 select * from t1;
1752 c1
1753 select * from t1;
1754 c1
1755 # Cleanup
1756 set @@session.binlog_format=@save_binlog_format;
1757 Warnings:
1758 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
1759 drop table t1;
1760 drop procedure p1;
1761 # End of 5.5 tests.
1762 include/rpl_end.inc