Debian Codegraph @

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