1742 lines
80 KiB
Plaintext
1742 lines
80 KiB
Plaintext
include/master-slave.inc
|
|
Warnings:
|
|
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
|
|
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
|
|
[connection master]
|
|
drop database if exists mysqltest1;
|
|
create database mysqltest1;
|
|
use mysqltest1;
|
|
create table t1 (a varchar(100)) engine=XENGINE;
|
|
use mysqltest1;
|
|
create procedure foo()
|
|
begin
|
|
declare b int;
|
|
set b = 8;
|
|
insert into t1 values (b);
|
|
insert into t1 values (unix_timestamp());
|
|
end|
|
|
select * from information_schema.routines where routine_schema='mysqltest1' and routine_name='foo';
|
|
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
|
|
foo def mysqltest1 foo PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL begin
|
|
declare b int;
|
|
set b = 8;
|
|
insert into t1 values (b);
|
|
insert into t1 values (unix_timestamp());
|
|
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_general_ci
|
|
select * from information_schema.routines where routine_schema='mysqltest1' and routine_name='foo';
|
|
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
|
|
foo def mysqltest1 foo PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL begin
|
|
declare b int;
|
|
set b = 8;
|
|
insert into t1 values (b);
|
|
insert into t1 values (unix_timestamp());
|
|
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_general_ci
|
|
set timestamp=1000000000;
|
|
call foo();
|
|
select * from t1;
|
|
a
|
|
8
|
|
1000000000
|
|
select * from t1;
|
|
a
|
|
8
|
|
1000000000
|
|
delete from t1;
|
|
create procedure foo2()
|
|
select * from mysqltest1.t1;
|
|
call foo2();
|
|
a
|
|
alter procedure foo2 contains sql;
|
|
set timestamp = DEFAULT;
|
|
drop table t1;
|
|
create table t1 (a int) engine=XENGINE;
|
|
create table t2 like t1;
|
|
create procedure foo3()
|
|
deterministic
|
|
insert into t1 values (15);
|
|
create user "zedjzlcsjhd"@127.0.0.1;
|
|
grant CREATE ROUTINE, EXECUTE on mysqltest1.* to "zedjzlcsjhd"@127.0.0.1;
|
|
grant SELECT on mysqltest1.t1 to "zedjzlcsjhd"@127.0.0.1;
|
|
grant SELECT, INSERT on mysqltest1.t2 to "zedjzlcsjhd"@127.0.0.1;
|
|
SELECT 1;
|
|
1
|
|
1
|
|
create procedure foo4()
|
|
deterministic
|
|
begin
|
|
insert into t2 values(3);
|
|
insert into t1 values (5);
|
|
end|
|
|
call foo4();
|
|
Got one of the listed errors
|
|
call foo3();
|
|
show warnings;
|
|
Level Code Message
|
|
call foo4();
|
|
Got one of the listed errors
|
|
alter procedure foo4 sql security invoker;
|
|
call foo4();
|
|
show warnings;
|
|
Level Code Message
|
|
select * from t1;
|
|
a
|
|
15
|
|
5
|
|
select * from t2;
|
|
a
|
|
3
|
|
3
|
|
3
|
|
select * from t1;
|
|
a
|
|
15
|
|
5
|
|
select * from t2;
|
|
a
|
|
3
|
|
3
|
|
3
|
|
delete from t2;
|
|
alter table t2 add unique (a);
|
|
drop procedure foo4;
|
|
create procedure foo4()
|
|
deterministic
|
|
begin
|
|
insert into t2 values(20),(20);
|
|
end|
|
|
call foo4();
|
|
ERROR 23000: Duplicate entry '20' for key 'a'
|
|
show warnings;
|
|
Level Code Message
|
|
Error 1062 Duplicate entry '20' for key 'a'
|
|
select * from t2;
|
|
a
|
|
select * from t2;
|
|
a
|
|
select * from information_schema.routines where routine_schema='mysqltest1' and routine_name='foo4';
|
|
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
|
|
foo4 def mysqltest1 foo4 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL begin
|
|
insert into t2 values(20),(20);
|
|
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_general_ci
|
|
drop procedure foo4;
|
|
select * from information_schema.routines where routine_schema='mysqltest1' and routine_name='foo4';
|
|
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
|
|
select * from information_schema.routines where routine_schema='mysqltest1' and routine_name='foo4';
|
|
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
|
|
drop procedure foo;
|
|
drop procedure foo2;
|
|
drop procedure foo3;
|
|
create function fn1(x int)
|
|
returns int
|
|
begin
|
|
insert into t1 values (x);
|
|
return x+2;
|
|
end|
|
|
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)
|
|
create function fn1(x int)
|
|
returns int
|
|
deterministic
|
|
begin
|
|
insert into t1 values (x);
|
|
return x+2;
|
|
end|
|
|
delete t1,t2 from t1,t2;
|
|
select fn1(20);
|
|
fn1(20)
|
|
22
|
|
insert into t2 values(fn1(21));
|
|
select * from t1;
|
|
a
|
|
15
|
|
5
|
|
20
|
|
21
|
|
select * from t2;
|
|
a
|
|
23
|
|
select * from t1;
|
|
a
|
|
15
|
|
5
|
|
20
|
|
21
|
|
select * from t2;
|
|
a
|
|
23
|
|
drop function fn1;
|
|
create function fn1()
|
|
returns int
|
|
no sql
|
|
begin
|
|
return unix_timestamp();
|
|
end|
|
|
alter function fn1 contains sql;
|
|
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)
|
|
delete from t1;
|
|
set timestamp=1000000000;
|
|
insert into t1 values(fn1());
|
|
create function fn2()
|
|
returns int
|
|
no sql
|
|
begin
|
|
return unix_timestamp();
|
|
end|
|
|
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)
|
|
set @old_log_bin_trust_function_creators= @@global.log_bin_trust_function_creators;
|
|
set global log_bin_trust_function_creators=0;
|
|
set global log_bin_trust_function_creators=1;
|
|
set @old_log_bin_trust_function_creators= @@global.log_bin_trust_function_creators;
|
|
set global log_bin_trust_function_creators=1;
|
|
create function fn2()
|
|
returns int
|
|
no sql
|
|
begin
|
|
return unix_timestamp();
|
|
end|
|
|
create function fn3()
|
|
returns int
|
|
not deterministic
|
|
reads sql data
|
|
begin
|
|
return 0;
|
|
end|
|
|
select fn3();
|
|
fn3()
|
|
0
|
|
select * from information_schema.routines where routine_schema='mysqltest1';
|
|
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
|
|
fn1 def mysqltest1 fn1 FUNCTION int NULL NULL 10 0 NULL NULL NULL int(11) SQL begin
|
|
return unix_timestamp();
|
|
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_general_ci
|
|
fn2 def mysqltest1 fn2 FUNCTION int NULL NULL 10 0 NULL NULL NULL int(11) SQL begin
|
|
return unix_timestamp();
|
|
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_general_ci
|
|
fn3 def mysqltest1 fn3 FUNCTION int NULL NULL 10 0 NULL NULL NULL int(11) SQL begin
|
|
return 0;
|
|
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_general_ci
|
|
select * from t1;
|
|
a
|
|
1000000000
|
|
use mysqltest1;
|
|
select * from t1;
|
|
a
|
|
1000000000
|
|
select * from information_schema.routines where routine_schema='mysqltest1';
|
|
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
|
|
fn1 def mysqltest1 fn1 FUNCTION int NULL NULL 10 0 NULL NULL NULL int(11) SQL begin
|
|
return unix_timestamp();
|
|
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_general_ci
|
|
fn2 def mysqltest1 fn2 FUNCTION int NULL NULL 10 0 NULL NULL NULL int(11) SQL begin
|
|
return unix_timestamp();
|
|
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_general_ci
|
|
fn3 def mysqltest1 fn3 FUNCTION int NULL NULL 10 0 NULL NULL NULL int(11) SQL begin
|
|
return 0;
|
|
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_general_ci
|
|
delete from t2;
|
|
SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
|
|
alter table t2 add unique (a);
|
|
Warnings:
|
|
Warning 1831 Duplicate index 'a_2' defined on the table 'mysqltest1.t2'. This is deprecated and will be disallowed in a future release.
|
|
SET sql_mode = default;
|
|
drop function fn1;
|
|
create function fn1(x int)
|
|
returns int
|
|
begin
|
|
insert into t2 values(x),(x);
|
|
return 10;
|
|
end|
|
|
do fn1(100);
|
|
ERROR 23000: Duplicate entry '100' for key 'a'
|
|
select fn1(20);
|
|
ERROR 23000: Duplicate entry '20' for key 'a'
|
|
select * from t2;
|
|
a
|
|
20
|
|
select * from t2;
|
|
a
|
|
create trigger trg before insert on t1 for each row set new.a= 10;
|
|
ERROR 42000: TRIGGER command denied to user 'zedjzlcsjhd'@'localhost' for table 't1'
|
|
delete from t1;
|
|
create trigger trg before insert on t1 for each row set new.a= 10;
|
|
insert into t1 values (1);
|
|
select * from t1;
|
|
a
|
|
10
|
|
select * from t1;
|
|
a
|
|
10
|
|
delete from t1;
|
|
drop trigger trg;
|
|
insert into t1 values (1);
|
|
select * from t1;
|
|
a
|
|
1
|
|
select * from t1;
|
|
a
|
|
1
|
|
create procedure foo()
|
|
not deterministic
|
|
reads sql data
|
|
select * from t1;
|
|
call foo();
|
|
a
|
|
1
|
|
drop procedure foo;
|
|
drop function fn1;
|
|
drop database mysqltest1;
|
|
drop user "zedjzlcsjhd"@127.0.0.1;
|
|
use test;
|
|
use test;
|
|
drop function if exists f1;
|
|
create function f1() returns int reads sql data
|
|
begin
|
|
declare var integer;
|
|
declare c cursor for select a from v1;
|
|
open c;
|
|
fetch c into var;
|
|
close c;
|
|
return var;
|
|
end|
|
|
create view v1 as select 1 as a;
|
|
create table t1 (a int) engine=XENGINE;
|
|
insert into t1 (a) values (f1());
|
|
select * from t1;
|
|
a
|
|
1
|
|
drop view v1;
|
|
drop function f1;
|
|
select * from t1;
|
|
a
|
|
1
|
|
DROP PROCEDURE IF EXISTS p1;
|
|
DROP TABLE IF EXISTS t1;
|
|
CREATE TABLE t1(col VARCHAR(10)) engine=XENGINE;
|
|
CREATE PROCEDURE p1(arg VARCHAR(10))
|
|
INSERT INTO t1 VALUES(arg);
|
|
CALL p1('test');
|
|
SELECT * FROM t1;
|
|
col
|
|
test
|
|
SELECT * FROM t1;
|
|
col
|
|
test
|
|
DROP PROCEDURE p1;
|
|
|
|
---> Test for BUG#20438
|
|
|
|
---> Preparing environment...
|
|
---> connection: master
|
|
DROP PROCEDURE IF EXISTS p1;
|
|
DROP FUNCTION IF EXISTS f1;
|
|
|
|
---> Synchronizing slave with master...
|
|
|
|
---> connection: master
|
|
|
|
---> Creating procedure...
|
|
/*!50003 CREATE PROCEDURE p1() SET @a = 1 */;
|
|
/*!50003 CREATE FUNCTION f1() RETURNS INT RETURN 0 */;
|
|
|
|
---> Checking on master...
|
|
SHOW CREATE PROCEDURE p1;
|
|
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
|
|
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`()
|
|
SET @a = 1 utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
SHOW CREATE FUNCTION f1;
|
|
Function sql_mode Create Function character_set_client collation_connection Database Collation
|
|
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(11)
|
|
RETURN 0 utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
|
|
---> Synchronizing slave with master...
|
|
---> connection: master
|
|
|
|
---> Checking on slave...
|
|
SHOW CREATE PROCEDURE p1;
|
|
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
|
|
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`()
|
|
SET @a = 1 utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
SHOW CREATE FUNCTION f1;
|
|
Function sql_mode Create Function character_set_client collation_connection Database Collation
|
|
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(11)
|
|
RETURN 0 utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
|
|
---> connection: master
|
|
|
|
---> Cleaning up...
|
|
DROP PROCEDURE p1;
|
|
DROP FUNCTION f1;
|
|
drop table t1;
|
|
drop database if exists mysqltest;
|
|
drop database if exists mysqltest2;
|
|
create database mysqltest;
|
|
create database mysqltest2;
|
|
use mysqltest2;
|
|
create table t ( t integer ) engine=XENGINE;
|
|
create procedure mysqltest.test() begin end;
|
|
insert into t values ( 1 );
|
|
create procedure `\\`.test() begin end;
|
|
ERROR 42000: Unknown database '\\'
|
|
create function f1 () returns int
|
|
begin
|
|
insert into t values (1);
|
|
return 0;
|
|
end|
|
|
use mysqltest;
|
|
set @a:= mysqltest2.f1();
|
|
include/show_binlog_events.inc
|
|
Log_name Pos Event_type Server_id End_log_pos Info
|
|
master-bin.000001 # Query # # drop database if exists mysqltest1
|
|
master-bin.000001 # Query # # create database mysqltest1
|
|
master-bin.000001 # Query # # use `mysqltest1`; create table t1 (a varchar(100)) engine=XENGINE
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
|
|
begin
|
|
declare b int;
|
|
set b = 8;
|
|
insert into t1 values (b);
|
|
insert into t1 values (unix_timestamp());
|
|
end
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values ( NAME_CONST('b',8))
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (unix_timestamp())
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; delete from t1
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo2`()
|
|
select * from mysqltest1.t1
|
|
master-bin.000001 # Query # # use `mysqltest1`; alter procedure foo2 contains sql
|
|
master-bin.000001 # Query # # use `mysqltest1`; DROP TABLE `t1` /* generated by server */
|
|
master-bin.000001 # Query # # use `mysqltest1`; create table t1 (a int) engine=XENGINE
|
|
master-bin.000001 # Query # # use `mysqltest1`; create table t2 like t1
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo3`()
|
|
DETERMINISTIC
|
|
insert into t1 values (15)
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE USER 'zedjzlcsjhd'@'127.0.0.1' IDENTIFIED WITH 'caching_sha2_password'
|
|
master-bin.000001 # Query # # use `mysqltest1`; GRANT EXECUTE, CREATE ROUTINE ON `mysqltest1`.* TO 'zedjzlcsjhd'@'127.0.0.1'
|
|
master-bin.000001 # Query # # use `mysqltest1`; GRANT SELECT ON `mysqltest1`.`t1` TO 'zedjzlcsjhd'@'127.0.0.1'
|
|
master-bin.000001 # Query # # use `mysqltest1`; GRANT SELECT, INSERT ON `mysqltest1`.`t2` TO 'zedjzlcsjhd'@'127.0.0.1'
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` PROCEDURE `foo4`()
|
|
DETERMINISTIC
|
|
begin
|
|
insert into t2 values(3);
|
|
insert into t1 values (5);
|
|
end
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(3)
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (15)
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(3)
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `mysqltest1`; alter procedure foo4 sql security invoker
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(3)
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (5)
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; delete from t2
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `mysqltest1`; alter table t2 add unique (a)
|
|
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo4
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo4`()
|
|
DETERMINISTIC
|
|
begin
|
|
insert into t2 values(20),(20);
|
|
end
|
|
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo4
|
|
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo
|
|
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo2
|
|
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo3
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
|
|
DETERMINISTIC
|
|
begin
|
|
insert into t1 values (x);
|
|
return x+2;
|
|
end
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; delete t1,t2 from t1,t2
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; SELECT `mysqltest1`.`fn1`(20)
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t2 values(fn1(21))
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`() RETURNS int(11)
|
|
NO SQL
|
|
begin
|
|
return unix_timestamp();
|
|
end
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; delete from t1
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values(fn1())
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` FUNCTION `fn2`() RETURNS int(11)
|
|
NO SQL
|
|
begin
|
|
return unix_timestamp();
|
|
end
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn3`() RETURNS int(11)
|
|
READS SQL DATA
|
|
begin
|
|
return 0;
|
|
end
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; delete from t2
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `mysqltest1`; alter table t2 add unique (a)
|
|
master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
|
|
begin
|
|
insert into t2 values(x),(x);
|
|
return 10;
|
|
end
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; delete from t1
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` trigger trg before insert on t1 for each row set new.a= 10
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (1)
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; delete from t1
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `mysqltest1`; drop trigger trg
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest1`; insert into t1 values (1)
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `mysqltest1`; CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
|
|
READS SQL DATA
|
|
select * from t1
|
|
master-bin.000001 # Query # # use `mysqltest1`; drop procedure foo
|
|
master-bin.000001 # Query # # use `mysqltest1`; drop function fn1
|
|
master-bin.000001 # Query # # drop database mysqltest1
|
|
master-bin.000001 # Query # # drop user "zedjzlcsjhd"@127.0.0.1
|
|
master-bin.000001 # Query # # use `test`; drop function if exists f1
|
|
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
|
|
READS SQL DATA
|
|
begin
|
|
declare var integer;
|
|
declare c cursor for select a from v1;
|
|
open c;
|
|
fetch c into var;
|
|
close c;
|
|
return var;
|
|
end
|
|
master-bin.000001 # Query # # use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 as a
|
|
master-bin.000001 # Query # # use `test`; create table t1 (a int) engine=XENGINE
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `test`; insert into t1 (a) values (f1())
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `test`; drop view v1
|
|
master-bin.000001 # Query # # use `test`; drop function f1
|
|
master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS p1
|
|
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
|
|
master-bin.000001 # Query # # use `test`; CREATE TABLE t1(col VARCHAR(10)) engine=XENGINE
|
|
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(arg VARCHAR(10))
|
|
INSERT INTO t1 VALUES(arg)
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES( NAME_CONST('arg',_utf8mb4'test' COLLATE 'utf8mb4_0900_ai_ci'))
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `test`; DROP PROCEDURE p1
|
|
master-bin.000001 # Query # # use `test`; DROP PROCEDURE IF EXISTS p1
|
|
master-bin.000001 # Query # # use `test`; DROP FUNCTION IF EXISTS f1
|
|
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
|
|
SET @a = 1
|
|
master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
|
|
RETURN 0
|
|
master-bin.000001 # Query # # use `test`; DROP PROCEDURE p1
|
|
master-bin.000001 # Query # # use `test`; DROP FUNCTION f1
|
|
master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
|
|
master-bin.000001 # Query # # drop database if exists mysqltest
|
|
master-bin.000001 # Query # # drop database if exists mysqltest2
|
|
master-bin.000001 # Query # # create database mysqltest
|
|
master-bin.000001 # Query # # create database mysqltest2
|
|
master-bin.000001 # Query # # use `mysqltest2`; create table t ( t integer ) engine=XENGINE
|
|
master-bin.000001 # Query # # use `mysqltest2`; CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltest`.`test`()
|
|
begin end
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest2`; insert into t values ( 1 )
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Query # # use `mysqltest2`; CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
|
|
begin
|
|
insert into t values (1);
|
|
return 0;
|
|
end
|
|
master-bin.000001 # Query # # BEGIN
|
|
master-bin.000001 # Query # # use `mysqltest`; SELECT `mysqltest2`.`f1`()
|
|
master-bin.000001 # Query # # COMMIT
|
|
set @@global.log_bin_trust_function_creators= @old_log_bin_trust_function_creators;
|
|
set @@global.log_bin_trust_function_creators= @old_log_bin_trust_function_creators;
|
|
drop database mysqltest;
|
|
drop database mysqltest2;
|
|
use test;
|
|
/*!50001 create procedure `mysqltestbug36570_p1`() */
|
|
begin
|
|
select 1;
|
|
end|
|
|
use mysql|
|
|
create procedure test.` mysqltestbug36570_p2`(/*!50001 a int*/)`label`:
|
|
begin
|
|
select a;
|
|
end|
|
|
/*!50001 create function test.mysqltestbug36570_f1() */
|
|
returns int
|
|
/*!50001 deterministic */
|
|
begin
|
|
return 3;
|
|
end|
|
|
use test|
|
|
show procedure status like '%mysqltestbug36570%';
|
|
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
|
|
test mysqltestbug36570_p2 PROCEDURE root@localhost t t DEFINER utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
test mysqltestbug36570_p1 PROCEDURE root@localhost t t DEFINER utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
show create procedure ` mysqltestbug36570_p2`;
|
|
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
|
|
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 )
|
|
`label`:
|
|
begin
|
|
select a;
|
|
end utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
show procedure status like '%mysqltestbug36570%';
|
|
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
|
|
test mysqltestbug36570_p2 PROCEDURE root@localhost t t DEFINER utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
test mysqltestbug36570_p1 PROCEDURE root@localhost t t DEFINER utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
show create procedure ` mysqltestbug36570_p2`;
|
|
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
|
|
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 )
|
|
`label`:
|
|
begin
|
|
select a;
|
|
end utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
call ` mysqltestbug36570_p2`(42);
|
|
a
|
|
42
|
|
show function status like '%mysqltestbug36570%';
|
|
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
|
|
test mysqltestbug36570_f1 FUNCTION root@localhost t t DEFINER utf8mb4 utf8mb4_0900_ai_ci utf8mb4_0900_ai_ci
|
|
flush logs;
|
|
include/mysqlbinlog.inc
|
|
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
|
|
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
|
|
DELIMITER /*!*/;
|
|
ROLLBACK/*!*/;
|
|
# [empty]
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
SET @@session.pseudo_thread_id=#/*!*/;
|
|
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
|
|
SET @@session.sql_mode=1168113696/*!*/;
|
|
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
|
|
/*!\C utf8mb4 *//*!*/;
|
|
SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/;
|
|
SET @@session.lc_time_names=0/*!*/;
|
|
SET @@session.collation_database=DEFAULT/*!*/;
|
|
/*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/;
|
|
drop database if exists mysqltest1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
/*!80016 SET @@session.default_table_encryption=0*//*!*/;
|
|
create database mysqltest1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
use `mysqltest1`/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
|
|
create table t1 (a varchar(100)) engine=XENGINE
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
|
|
begin
|
|
declare b int;
|
|
set b = 8;
|
|
insert into t1 values (b);
|
|
insert into t1 values (unix_timestamp());
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t1 values ( NAME_CONST('b',8))
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t1 values (unix_timestamp())
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
delete from t1
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo2`()
|
|
select * from mysqltest1.t1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
alter procedure foo2 contains sql
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
DROP TABLE `t1` /* generated by server */
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
|
|
create table t1 (a int) engine=XENGINE
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
|
|
create table t2 like t1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo3`()
|
|
DETERMINISTIC
|
|
insert into t1 values (15)
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE USER 'zedjzlcsjhd'@'127.0.0.1' IDENTIFIED WITH 'caching_sha2_password'
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
GRANT EXECUTE, CREATE ROUTINE ON `mysqltest1`.* TO 'zedjzlcsjhd'@'127.0.0.1'
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
GRANT SELECT ON `mysqltest1`.`t1` TO 'zedjzlcsjhd'@'127.0.0.1'
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
GRANT SELECT, INSERT ON `mysqltest1`.`t2` TO 'zedjzlcsjhd'@'127.0.0.1'
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` PROCEDURE `foo4`()
|
|
DETERMINISTIC
|
|
begin
|
|
insert into t2 values(3);
|
|
insert into t1 values (5);
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t2 values(3)
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t1 values (15)
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t2 values(3)
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
alter procedure foo4 sql security invoker
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t2 values(3)
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t1 values (5)
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
delete from t2
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
|
|
alter table t2 add unique (a)
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop procedure foo4
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo4`()
|
|
DETERMINISTIC
|
|
begin
|
|
insert into t2 values(20),(20);
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop procedure foo4
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop procedure foo
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop procedure foo2
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop procedure foo3
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
|
|
DETERMINISTIC
|
|
begin
|
|
insert into t1 values (x);
|
|
return x+2;
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
delete t1,t2 from t1,t2
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
COMMIT
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
SELECT `mysqltest1`.`fn1`(20)
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t2 values(fn1(21))
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop function fn1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`() RETURNS int(11)
|
|
NO SQL
|
|
begin
|
|
return unix_timestamp();
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
delete from t1
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t1 values(fn1())
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` FUNCTION `fn2`() RETURNS int(11)
|
|
NO SQL
|
|
begin
|
|
return unix_timestamp();
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` FUNCTION `fn3`() RETURNS int(11)
|
|
READS SQL DATA
|
|
begin
|
|
return 0;
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
delete from t2
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
SET @@session.sql_mode=1073741824/*!*/;
|
|
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
|
|
alter table t2 add unique (a)
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
SET @@session.sql_mode=1168113696/*!*/;
|
|
drop function fn1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
|
|
begin
|
|
insert into t2 values(x),(x);
|
|
return 10;
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
delete from t1
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` trigger trg before insert on t1 for each row set new.a= 10
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t1 values (1)
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
delete from t1
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop trigger trg
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t1 values (1)
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
|
|
READS SQL DATA
|
|
select * from t1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop procedure foo
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop function fn1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop database mysqltest1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop user "zedjzlcsjhd"@127.0.0.1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
use `test`/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop function if exists f1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
|
|
READS SQL DATA
|
|
begin
|
|
declare var integer;
|
|
declare c cursor for select a from v1;
|
|
open c;
|
|
fetch c into var;
|
|
close c;
|
|
return var;
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 as a
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
|
|
create table t1 (a int) engine=XENGINE
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t1 (a) values (f1())
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop view v1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop function f1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
DROP PROCEDURE IF EXISTS p1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
DROP TABLE IF EXISTS `t1` /* generated by server */
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
|
|
CREATE TABLE t1(col VARCHAR(10)) engine=XENGINE
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(arg VARCHAR(10))
|
|
INSERT INTO t1 VALUES(arg)
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
INSERT INTO t1 VALUES( NAME_CONST('arg',_utf8mb4'test' COLLATE 'utf8mb4_0900_ai_ci'))
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
DROP PROCEDURE p1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
DROP PROCEDURE IF EXISTS p1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
DROP FUNCTION IF EXISTS f1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
|
|
SET @a = 1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
|
|
RETURN 0
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
DROP PROCEDURE p1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
DROP FUNCTION f1
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
DROP TABLE `t1` /* generated by server */
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop database if exists mysqltest
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop database if exists mysqltest2
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
/*!80016 SET @@session.default_table_encryption=0*//*!*/;
|
|
create database mysqltest
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
/*!80016 SET @@session.default_table_encryption=0*//*!*/;
|
|
create database mysqltest2
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
use `mysqltest2`/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
/*!80013 SET @@session.sql_require_primary_key=0*//*!*/;
|
|
create table t ( t integer ) engine=XENGINE
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltest`.`test`()
|
|
begin end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
insert into t values ( 1 )
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
|
|
begin
|
|
insert into t values (1);
|
|
return 0;
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
BEGIN
|
|
/*!*/;
|
|
use `mysqltest`/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
SELECT `mysqltest2`.`f1`()
|
|
/*!*/;
|
|
COMMIT/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop database mysqltest
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
drop database mysqltest2
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
use `test`/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltestbug36570_p1`()
|
|
begin
|
|
select 1;
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
use `mysql`/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `test`.` mysqltestbug36570_p2`( a int )
|
|
`label`:
|
|
begin
|
|
select a;
|
|
end
|
|
/*!*/;
|
|
# original_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
# immediate_commit_timestamp= MICROSECONDS-FROM-EPOCH (YYYY-MM-DD HOURS:MINUTES:SECONDS TZ)
|
|
/*!80001 SET @@session.original_commit_timestamp= MICROSECONDS-FROM-EPOCH*//*!*/;
|
|
/*!80014 SET @@session.original_server_version= ORIGINAL_SERVER_VERSION*//*!*/;
|
|
/*!80014 SET @@session.immediate_server_version= IMMEDIATE_SERVER_VERSION*//*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#'/*!*/;
|
|
SET TIMESTAMP=#/*!*/;
|
|
CREATE DEFINER=`root`@`localhost` FUNCTION `test`.`mysqltestbug36570_f1`() RETURNS int(11)
|
|
DETERMINISTIC
|
|
begin
|
|
return 3;
|
|
end
|
|
/*!*/;
|
|
SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/;
|
|
DELIMITER ;
|
|
# End of log file
|
|
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
|
|
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
|
|
use test;
|
|
drop procedure mysqltestbug36570_p1;
|
|
drop procedure ` mysqltestbug36570_p2`;
|
|
drop function mysqltestbug36570_f1;
|
|
End of 5.0 tests
|
|
# End of 5.1 tests
|
|
#
|
|
# Test Bug#30977 Concurrent statement using stored
|
|
# function and DROP FUNCTION breaks SBR.
|
|
#
|
|
# Demonstrate that stored function DDL can not go through,
|
|
# or, worse yet, make its way into the binary log, while
|
|
# the stored function is in use.
|
|
# For that, try to insert a result of a stored function
|
|
# into a table. Block the insert in the beginning, waiting
|
|
# on a table lock. While insert is blocked, attempt to
|
|
# drop the routine. Verify that this attempt
|
|
# blocks and waits for INSERT to complete. Commit and
|
|
# reap the chain of events. Master and slave must contain
|
|
# identical data. Statements in the binrary log must be
|
|
# consistent with data in the table.
|
|
#
|
|
# --> connection default
|
|
drop table if exists t1, t2;
|
|
drop function if exists t1;
|
|
create table t1 (a int) engine=XENGINE;
|
|
create table t2 (a int) engine=XENGINE as select 1 as a;
|
|
create function f1() returns int deterministic return (select max(a) from t2);
|
|
lock table t2 write;
|
|
# --> connection master
|
|
# Sending 'insert into t1 (a) values (f1())'...
|
|
insert into t1 (a) values (f1());
|
|
# Waitng for 'insert into t1 ...' to get blocked on table lock...
|
|
# Sending 'drop function f1'. It will wait till insert finishes.
|
|
drop function f1;;
|
|
# --> connection default
|
|
# Check that 'drop function f1' gets blocked.
|
|
# Now let's let 'insert' go through...
|
|
unlock tables;
|
|
# --> connection master
|
|
# Reaping 'insert into t1 (a) values (f1())'...
|
|
# --> connection master1
|
|
# Reaping 'drop function f1'
|
|
# --> connection master
|
|
select * from t1;
|
|
a
|
|
1
|
|
select * from t1;
|
|
a
|
|
1
|
|
drop table t1, t2;
|
|
drop function f1;
|
|
ERROR 42000: FUNCTION test.f1 does not exist
|
|
#
|
|
# Bug #11918 Can't use a declared variable in LIMIT clause
|
|
#
|
|
include/rpl_reset.inc
|
|
create table t1 (c1 int) engine=XENGINE;
|
|
insert into t1 (c1) values
|
|
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
|
|
call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
|
|
create procedure p1(p1 integer)
|
|
delete from t1 limit p1;
|
|
set @save_binlog_format=@@session.binlog_format;
|
|
set @@session.binlog_format=STATEMENT;
|
|
call p1(NULL);
|
|
call p1(0);
|
|
call p1(1);
|
|
call p1(2);
|
|
call p1(3);
|
|
select * from t1;
|
|
c1
|
|
7
|
|
8
|
|
9
|
|
10
|
|
select * from t1;
|
|
c1
|
|
7
|
|
8
|
|
9
|
|
10
|
|
call p1(-1);
|
|
select * from t1;
|
|
c1
|
|
select * from t1;
|
|
c1
|
|
# Cleanup
|
|
set @@session.binlog_format=@save_binlog_format;
|
|
drop table t1;
|
|
drop procedure p1;
|
|
# End of 5.5 tests.
|
|
include/rpl_end.inc
|