[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@18.225.55.42: ~ $ 
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));
include/sync_slave_sql_with_master.inc
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 mysql.proc where name='foo' and db='mysqltest1';
db	name	type	specific_name	language	sql_data_access	is_deterministic	security_type	param_list	returns	body	definer	created	modified	sql_mode	comment	character_set_client	collation_connection	db_collation	body_utf8
mysqltest1	foo	PROCEDURE	foo	SQL	CONTAINS_SQL	NO	DEFINER			begin
declare b int;
set b = 8;
insert into t1 values (b);
insert into t1 values (unix_timestamp());
end	root@localhost	#	#	NO_ENGINE_SUBSTITUTION		latin1	latin1_swedish_ci	latin1_swedish_ci	begin
declare b int;
set b = 8;
insert into t1 values (b);
insert into t1 values (unix_timestamp());
end
include/sync_slave_sql_with_master.inc
select * from mysql.proc where name='foo' and db='mysqltest1';
db	name	type	specific_name	language	sql_data_access	is_deterministic	security_type	param_list	returns	body	definer	created	modified	sql_mode	comment	character_set_client	collation_connection	db_collation	body_utf8
mysqltest1	foo	PROCEDURE	foo	SQL	CONTAINS_SQL	NO	DEFINER			begin
declare b int;
set b = 8;
insert into t1 values (b);
insert into t1 values (unix_timestamp());
end	root@localhost	#	#	NO_ENGINE_SUBSTITUTION		latin1	latin1_swedish_ci	latin1_swedish_ci	begin
declare b int;
set b = 8;
insert into t1 values (b);
insert into t1 values (unix_timestamp());
end
set timestamp=1000000000;
call foo();
select * from t1;
a
8
1000000000
include/sync_slave_sql_with_master.inc
select * from t1;
a
8
1000000000
delete from t1;
create procedure foo2()
select * from mysqltest1.t1;
call foo2();
a
alter procedure foo2 contains sql;
drop table t1;
create table t1 (a int);
create table t2 like t1;
create procedure foo3()
deterministic
insert into t1 values (15);
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
include/sync_slave_sql_with_master.inc
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'
Warning	1196	Some non-transactional changed tables couldn't be rolled back
select * from t2;
a
20
include/sync_slave_sql_with_master.inc
select * from t2;
a
20
select * from mysql.proc where name="foo4" and db='mysqltest1';
db	name	type	specific_name	language	sql_data_access	is_deterministic	security_type	param_list	returns	body	definer	created	modified	sql_mode	comment	character_set_client	collation_connection	db_collation	body_utf8
mysqltest1	foo4	PROCEDURE	foo4	SQL	CONTAINS_SQL	YES	DEFINER			begin
insert into t2 values(20),(20);
end	root@localhost	#	#	NO_ENGINE_SUBSTITUTION		latin1	latin1_swedish_ci	latin1_swedish_ci	begin
insert into t2 values(20),(20);
end
drop procedure foo4;
select * from mysql.proc where name="foo4" and db='mysqltest1';
db	name	type	specific_name	language	sql_data_access	is_deterministic	security_type	param_list	returns	body	definer	created	modified	sql_mode	comment	character_set_client	collation_connection	db_collation	body_utf8
include/sync_slave_sql_with_master.inc
select * from mysql.proc where name="foo4" and db='mysqltest1';
db	name	type	specific_name	language	sql_data_access	is_deterministic	security_type	param_list	returns	body	definer	created	modified	sql_mode	comment	character_set_client	collation_connection	db_collation	body_utf8
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
21
20
select * from t2;
a
23
include/sync_slave_sql_with_master.inc
select * from t1;
a
21
20
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 mysql.proc where db='mysqltest1';
db	name	type	specific_name	language	sql_data_access	is_deterministic	security_type	param_list	returns	body	definer	created	modified	sql_mode	comment	character_set_client	collation_connection	db_collation	body_utf8
mysqltest1	fn1	FUNCTION	fn1	SQL	NO_SQL	NO	DEFINER		int(11)	begin
return unix_timestamp();
end	root@localhost	#	#	NO_ENGINE_SUBSTITUTION		latin1	latin1_swedish_ci	latin1_swedish_ci	begin
return unix_timestamp();
end
mysqltest1	fn2	FUNCTION	fn2	SQL	NO_SQL	NO	DEFINER		int(11)	begin
return unix_timestamp();
end	zedjzlcsjhd@localhost	#	#	NO_ENGINE_SUBSTITUTION		latin1	latin1_swedish_ci	latin1_swedish_ci	begin
return unix_timestamp();
end
mysqltest1	fn3	FUNCTION	fn3	SQL	READS_SQL_DATA	NO	DEFINER		int(11)	begin
return 0;
end	root@localhost	#	#	NO_ENGINE_SUBSTITUTION		latin1	latin1_swedish_ci	latin1_swedish_ci	begin
return 0;
end
select * from t1;
a
1000000000
include/sync_slave_sql_with_master.inc
use mysqltest1;
select * from t1;
a
1000000000
select * from mysql.proc where db='mysqltest1';
db	name	type	specific_name	language	sql_data_access	is_deterministic	security_type	param_list	returns	body	definer	created	modified	sql_mode	comment	character_set_client	collation_connection	db_collation	body_utf8
mysqltest1	fn1	FUNCTION	fn1	SQL	NO_SQL	NO	DEFINER		int(11)	begin
return unix_timestamp();
end	root@localhost	#	#	NO_ENGINE_SUBSTITUTION		latin1	latin1_swedish_ci	latin1_swedish_ci	begin
return unix_timestamp();
end
mysqltest1	fn2	FUNCTION	fn2	SQL	NO_SQL	NO	DEFINER		int(11)	begin
return unix_timestamp();
end	zedjzlcsjhd@localhost	#	#	NO_ENGINE_SUBSTITUTION		latin1	latin1_swedish_ci	latin1_swedish_ci	begin
return unix_timestamp();
end
mysqltest1	fn3	FUNCTION	fn3	SQL	READS_SQL_DATA	NO	DEFINER		int(11)	begin
return 0;
end	root@localhost	#	#	NO_ENGINE_SUBSTITUTION		latin1	latin1_swedish_ci	latin1_swedish_ci	begin
return 0;
end
delete from t2;
alter table t2 add unique (a);
Warnings:
Note	1831	Duplicate index 'a_2' defined on the table 'mysqltest1.t2'. This is deprecated and will be disallowed in a future release.
drop function fn1;
create function fn1(x int)
returns int
begin
insert into t2 values(x),(x);
return 10;
end|
do fn1(100);
Warnings:
Error	1062	Duplicate entry '100' for key 'a'
Warning	1196	Some non-transactional changed tables couldn't be rolled back
select fn1(20);
ERROR 23000: Duplicate entry '20' for key 'a'
select * from t2;
a
20
100
include/sync_slave_sql_with_master.inc
select * from t2;
a
20
100
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
include/sync_slave_sql_with_master.inc
select * from t1;
a
10
delete from t1;
drop trigger trg;
insert into t1 values (1);
select * from t1;
a
1
include/sync_slave_sql_with_master.inc
select * from t1;
a
1
create procedure foo()
not deterministic
reads sql data
select * from t1;
include/sync_slave_sql_with_master.inc
call foo();
a
1
drop procedure foo;
include/sync_slave_sql_with_master.inc
drop function fn1;
drop database mysqltest1;
drop user "zedjzlcsjhd"@127.0.0.1;
use test;
include/sync_slave_sql_with_master.inc
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);
insert into t1 (a) values (f1());
select * from t1;
a
1
drop view v1;
drop function f1;
include/sync_slave_sql_with_master.inc
select * from t1;
a
1
DROP PROCEDURE IF EXISTS p1;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1(col VARCHAR(10));
CREATE PROCEDURE p1(arg VARCHAR(10))
INSERT INTO t1 VALUES(arg);
CALL p1('test');
SELECT * FROM t1;
col
test
include/sync_slave_sql_with_master.inc
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...
include/sync_slave_sql_with_master.inc

---> 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	NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
SHOW CREATE FUNCTION f1;
Function	sql_mode	Create Function	character_set_client	collation_connection	Database Collation
f1	NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
RETURN 0	latin1	latin1_swedish_ci	latin1_swedish_ci

---> Synchronizing slave with master...
include/sync_slave_sql_with_master.inc
---> connection: master

---> Checking on slave...
SHOW CREATE PROCEDURE p1;
Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation
p1	NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
SET @a = 1	latin1	latin1_swedish_ci	latin1_swedish_ci
SHOW CREATE FUNCTION f1;
Function	sql_mode	Create Function	character_set_client	collation_connection	Database Collation
f1	NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
RETURN 0	latin1	latin1_swedish_ci	latin1_swedish_ci

---> connection: master

---> Cleaning up...
DROP PROCEDURE p1;
DROP FUNCTION f1;
include/sync_slave_sql_with_master.inc
drop table t1;
include/sync_slave_sql_with_master.inc
drop database if exists mysqltest;
drop database if exists mysqltest2;
create database mysqltest;
create database mysqltest2;
use mysqltest2;
create table t ( t integer );
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|
include/sync_slave_sql_with_master.inc
use mysqltest;
set @a:= mysqltest2.f1();
include/sync_slave_sql_with_master.inc
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))
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)
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`; grant CREATE ROUTINE, EXECUTE 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	#	#	BEGIN
master-bin.000001	#	Query	#	#	use `mysqltest1`; insert into t2 values(20),(20)
master-bin.000001	#	Query	#	#	COMMIT
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`; SELECT `mysqltest1`.`fn1`(100)
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`; 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)
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))
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',_latin1'test' COLLATE 'latin1_swedish_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 )
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;
include/sync_slave_sql_with_master.inc
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		latin1	latin1_swedish_ci	latin1_swedish_ci
test	mysqltestbug36570_p1	PROCEDURE	root@localhost	t	t	DEFINER		latin1	latin1_swedish_ci	latin1_swedish_ci
show create procedure ` mysqltestbug36570_p2`;
Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation
 mysqltestbug36570_p2	NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE ` mysqltestbug36570_p2`( a int )
`label`:
begin
select a;
end	latin1	latin1_swedish_ci	latin1_swedish_ci
include/sync_slave_sql_with_master.inc
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		latin1	latin1_swedish_ci	latin1_swedish_ci
test	mysqltestbug36570_p1	PROCEDURE	root@localhost	t	t	DEFINER		latin1	latin1_swedish_ci	latin1_swedish_ci
show create procedure ` mysqltestbug36570_p2`;
Procedure	sql_mode	Create Procedure	character_set_client	collation_connection	Database Collation
 mysqltestbug36570_p2	NO_ENGINE_SUBSTITUTION	CREATE DEFINER=`root`@`localhost` PROCEDURE ` mysqltestbug36570_p2`( a int )
`label`:
begin
select a;
end	latin1	latin1_swedish_ci	latin1_swedish_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		latin1	latin1_swedish_ci	latin1_swedish_ci
flush logs;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
ROLLBACK/*!*/;
SET TIMESTAMP=t/*!*/;
SET @@session.pseudo_thread_id=999999999/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1073741824/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C latin1 *//*!*/;
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
drop database if exists mysqltest1
/*!*/;
SET TIMESTAMP=t/*!*/;
create database mysqltest1
/*!*/;
use `mysqltest1`/*!*/;
SET TIMESTAMP=t/*!*/;
create table t1 (a varchar(100))
/*!*/;
SET TIMESTAMP=t/*!*/;
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
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t1 values ( NAME_CONST('b',8))
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t1 values (unix_timestamp())
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
delete from t1
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo2`()
select * from mysqltest1.t1
/*!*/;
SET TIMESTAMP=t/*!*/;
alter procedure foo2 contains sql
/*!*/;
SET TIMESTAMP=t/*!*/;
DROP TABLE `t1` /* generated by server */
/*!*/;
SET TIMESTAMP=t/*!*/;
create table t1 (a int)
/*!*/;
SET TIMESTAMP=t/*!*/;
create table t2 like t1
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo3`()
    DETERMINISTIC
insert into t1 values (15)
/*!*/;
SET TIMESTAMP=t/*!*/;
grant CREATE ROUTINE, EXECUTE on mysqltest1.* to "zedjzlcsjhd"@127.0.0.1
/*!*/;
SET TIMESTAMP=t/*!*/;
grant SELECT on mysqltest1.t1 to "zedjzlcsjhd"@127.0.0.1
/*!*/;
SET TIMESTAMP=t/*!*/;
grant SELECT, INSERT on mysqltest1.t2 to "zedjzlcsjhd"@127.0.0.1
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` PROCEDURE `foo4`()
    DETERMINISTIC
begin
insert into t2 values(3);
insert into t1 values (5);
end
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t2 values(3)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t1 values (15)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t2 values(3)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
alter procedure foo4 sql security invoker
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t2 values(3)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t1 values (5)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
delete from t2
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
alter table t2 add unique (a)
/*!*/;
SET TIMESTAMP=t/*!*/;
drop procedure foo4
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo4`()
    DETERMINISTIC
begin
insert into t2 values(20),(20);
end
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t2 values(20),(20)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
drop procedure foo4
/*!*/;
SET TIMESTAMP=t/*!*/;
drop procedure foo
/*!*/;
SET TIMESTAMP=t/*!*/;
drop procedure foo2
/*!*/;
SET TIMESTAMP=t/*!*/;
drop procedure foo3
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
    DETERMINISTIC
begin
insert into t1 values (x);
return x+2;
end
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
delete t1,t2 from t1,t2
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
SELECT `mysqltest1`.`fn1`(20)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t2 values(fn1(21))
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
drop function fn1
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`() RETURNS int(11)
    NO SQL
begin
return unix_timestamp();
end
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
delete from t1
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t1 values(fn1())
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`zedjzlcsjhd`@`127.0.0.1` FUNCTION `fn2`() RETURNS int(11)
    NO SQL
begin
return unix_timestamp();
end
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` FUNCTION `fn3`() RETURNS int(11)
    READS SQL DATA
begin
return 0;
end
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
delete from t2
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
alter table t2 add unique (a)
/*!*/;
SET TIMESTAMP=t/*!*/;
drop function fn1
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` FUNCTION `fn1`(x int) RETURNS int(11)
begin
insert into t2 values(x),(x);
return 10;
end
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
SELECT `mysqltest1`.`fn1`(100)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
SELECT `mysqltest1`.`fn1`(20)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
delete from t1
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` trigger trg before insert on t1 for each row set new.a= 10
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t1 values (1)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
delete from t1
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
drop trigger trg
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t1 values (1)
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` PROCEDURE `foo`()
    READS SQL DATA
select * from t1
/*!*/;
SET TIMESTAMP=t/*!*/;
drop procedure foo
/*!*/;
SET TIMESTAMP=t/*!*/;
drop function fn1
/*!*/;
SET TIMESTAMP=t/*!*/;
drop database mysqltest1
/*!*/;
SET TIMESTAMP=t/*!*/;
drop user "zedjzlcsjhd"@127.0.0.1
/*!*/;
use `test`/*!*/;
SET TIMESTAMP=t/*!*/;
drop function if exists f1
/*!*/;
SET TIMESTAMP=t/*!*/;
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
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 as a
/*!*/;
SET TIMESTAMP=t/*!*/;
create table t1 (a int)
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t1 (a) values (f1())
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
drop view v1
/*!*/;
SET TIMESTAMP=t/*!*/;
drop function f1
/*!*/;
SET TIMESTAMP=t/*!*/;
DROP PROCEDURE IF EXISTS p1
/*!*/;
SET TIMESTAMP=t/*!*/;
DROP TABLE IF EXISTS `t1` /* generated by server */
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE TABLE t1(col VARCHAR(10))
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`(arg VARCHAR(10))
INSERT INTO t1 VALUES(arg)
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
INSERT INTO t1 VALUES( NAME_CONST('arg',_latin1'test' COLLATE 'latin1_swedish_ci'))
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
DROP PROCEDURE p1
/*!*/;
SET TIMESTAMP=t/*!*/;
DROP PROCEDURE IF EXISTS p1
/*!*/;
SET TIMESTAMP=t/*!*/;
DROP FUNCTION IF EXISTS f1
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
SET @a = 1
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
RETURN 0
/*!*/;
SET TIMESTAMP=t/*!*/;
DROP PROCEDURE p1
/*!*/;
SET TIMESTAMP=t/*!*/;
DROP FUNCTION f1
/*!*/;
SET TIMESTAMP=t/*!*/;
DROP TABLE `t1` /* generated by server */
/*!*/;
SET TIMESTAMP=t/*!*/;
drop database if exists mysqltest
/*!*/;
SET TIMESTAMP=t/*!*/;
drop database if exists mysqltest2
/*!*/;
SET TIMESTAMP=t/*!*/;
create database mysqltest
/*!*/;
SET TIMESTAMP=t/*!*/;
create database mysqltest2
/*!*/;
use `mysqltest2`/*!*/;
SET TIMESTAMP=t/*!*/;
create table t ( t integer )
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltest`.`test`()
begin end
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=t/*!*/;
insert into t values ( 1 )
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
begin
insert into t values (1);
return 0;
end
/*!*/;
SET TIMESTAMP=t/*!*/;
BEGIN
/*!*/;
use `mysqltest`/*!*/;
SET TIMESTAMP=t/*!*/;
SELECT `mysqltest2`.`f1`()
/*!*/;
SET TIMESTAMP=t/*!*/;
COMMIT
/*!*/;
SET TIMESTAMP=t/*!*/;
drop database mysqltest
/*!*/;
SET TIMESTAMP=t/*!*/;
drop database mysqltest2
/*!*/;
use `test`/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` PROCEDURE `mysqltestbug36570_p1`()
begin
select 1;
end
/*!*/;
use `mysql`/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` PROCEDURE `test`.` mysqltestbug36570_p2`( a int )
`label`:
begin
select a;
end
/*!*/;
SET TIMESTAMP=t/*!*/;
CREATE DEFINER=`root`@`localhost` FUNCTION `test`.`mysqltestbug36570_f1`() RETURNS int(11)
    DETERMINISTIC
begin
return 3;
end
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!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);
create table t2 (a int) 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
include/sync_slave_sql_with_master.inc
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);
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
include/sync_slave_sql_with_master.inc
select * from t1;
c1
7
8
9
10
call p1(-1);
select * from t1;
c1
include/sync_slave_sql_with_master.inc
select * from t1;
c1
# Cleanup
set @@session.binlog_format=@save_binlog_format;
drop table t1;
drop procedure p1;
# End of 5.5 tests.
include/sync_slave_sql_with_master.inc
include/rpl_end.inc

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ rpl/ r/
Name Type Size Permission Actions
rpl000001.a.result File 6 B 0644
rpl000001.b.result File 21 B 0644
rpl_000010.result File 676 B 0644
rpl_000011.result File 772 B 0644
rpl_000013.result File 893 B 0644
rpl_000017.result File 818 B 0644
rpl_4threads_deadlock.result File 2.41 KB 0644
rpl_DML_error.result File 2.03 KB 0644
rpl_EE_err.result File 602 B 0644
rpl_LD_INFILE.result File 1.7 KB 0644
rpl_alter.result File 899 B 0644
rpl_alter_db.result File 699 B 0644
rpl_alter_repository.result File 14.3 KB 0644
rpl_alter_user.result File 2.58 KB 0644
rpl_apply_binlog_with_anonymous_gtid.result File 972 B 0644
rpl_apply_binlog_with_anonymous_gtid_when_gtid_mode_on.result File 1002 B 0644
rpl_apply_binlog_with_gtid_when_gtid_mode_off.result File 1005 B 0644
rpl_auto_increment.result File 7.16 KB 0644
rpl_auto_increment_11932.result File 1.51 KB 0644
rpl_auto_increment_bug33029.result File 1.03 KB 0644
rpl_auto_increment_bug45679.result File 3.03 KB 0644
rpl_auto_increment_update_failure.result File 46.41 KB 0644
rpl_autogen_query_multi_byte_char.result File 1.41 KB 0644
rpl_autoinc_lock_style.result File 759 B 0644
rpl_avoid_temporal_upgrade.result File 8.91 KB 0644
rpl_begin_commit_rollback.result File 15.77 KB 0644
rpl_binlog_corruption.result File 1.42 KB 0644
rpl_binlog_errors.result File 8.94 KB 0644
rpl_binlog_failed_drop_table.result File 1.45 KB 0644
rpl_binlog_format_errors.result File 8.25 KB 0644
rpl_binlog_gcommit_options.result File 721 B 0644
rpl_binlog_grant.result File 1.78 KB 0644
rpl_binlog_index.result File 1.7 KB 0644
rpl_bit.result File 2.92 KB 0644
rpl_bit_npk.result File 3.72 KB 0644
rpl_blackhole.result File 2.86 KB 0644
rpl_bug26395.result File 1.12 KB 0644
rpl_bug31076.result File 4.07 KB 0644
rpl_bug33931.result File 1.27 KB 0644
rpl_bug37426.result File 786 B 0644
rpl_bug38694.result File 443 B 0644
rpl_bug41902.result File 1.38 KB 0644
rpl_change_master.result File 5.58 KB 0644
rpl_change_master_crash_safe.result File 3.87 KB 0644
rpl_change_master_dbug.result File 672 B 0644
rpl_charset.result File 4.31 KB 0644
rpl_charset_sjis.result File 979 B 0644
rpl_check_gtid.result File 14.28 KB 0644
rpl_checksum.result File 6.03 KB 0644
rpl_checksum_cache.result File 4.51 KB 0644
rpl_checksum_undef.result File 760 B 0644
rpl_circular_for_4_hosts.result File 9.09 KB 0644
rpl_colSize.result File 5.48 KB 0644
rpl_commit_after_flush.result File 660 B 0644
rpl_concurrency_error.result File 6.39 KB 0644
rpl_conditional_comments.result File 3.72 KB 0644
rpl_connection.result File 1.51 KB 0644
rpl_corruption.result File 2.55 KB 0644
rpl_crash_safe_master.result File 5.85 KB 0644
rpl_crc_check.result File 704 B 0644
rpl_create_database.result File 1.97 KB 0644
rpl_create_drop_temp_table.result File 720 B 0644
rpl_create_if_not_exists.result File 4.22 KB 0644
rpl_create_tmp_table_if_not_exists.result File 1.49 KB 0644
rpl_critical_errors.result File 33 B 0644
rpl_critical_errors.result.txt File 1.31 KB 0644
rpl_cross_version.result File 939 B 0644
rpl_current_user.result File 7.25 KB 0644
rpl_db_stmts_ignored.result File 4.12 KB 0644
rpl_ddl.result File 30.17 KB 0644
rpl_deadlock_innodb.result File 3.22 KB 0644
rpl_delayed_slave.result File 7.57 KB 0644
rpl_delete_no_where.result File 713 B 0644
rpl_do_db_filter.result File 1.31 KB 0644
rpl_do_grant.result File 12.78 KB 0644
rpl_do_table_filter_insensitive.result File 1.66 KB 0644
rpl_do_table_filter_sensitive.result File 1.65 KB 0644
rpl_double_free_bug.result File 1.71 KB 0644
rpl_drop.result File 563 B 0644
rpl_drop_db.result File 1.2 KB 0644
rpl_drop_db_fail.result File 1.07 KB 0644
rpl_drop_temp.result File 1.72 KB 0644
rpl_drop_temp_gtid.result File 1.21 KB 0644
rpl_drop_temp_tbl_with_rewrite_db.result File 1.69 KB 0644
rpl_drop_view.result File 1.21 KB 0644
rpl_dual_pos_advance.result File 2.43 KB 0644
rpl_dump_thread_kill.result File 936 B 0644
rpl_empty_master_host.result File 882 B 0644
rpl_empty_multi_update.result File 1.31 KB 0644
rpl_err_ignoredtable.result File 1.31 KB 0644
rpl_events.result File 8.24 KB 0644
rpl_extra_col_master_innodb.result File 26.37 KB 0644
rpl_extra_col_master_myisam.result File 26.37 KB 0644
rpl_extra_col_slave_innodb.result File 18.53 KB 0644
rpl_extra_col_slave_myisam.result File 18.53 KB 0644
rpl_extra_row_data.result File 2 KB 0644
rpl_failed_optimize.result File 743 B 0644
rpl_filter_database.result File 560 B 0644
rpl_filter_tables_not_exist.result File 7.36 KB 0644
rpl_filter_warnings.result File 1.63 KB 0644
rpl_flush_logs.result File 2.99 KB 0644
rpl_flushlog_loop.result File 1.36 KB 0644
rpl_foreign_key_innodb.result File 1.68 KB 0644
rpl_free_items.result File 601 B 0644
rpl_function_defaults.result File 4.18 KB 0644
rpl_gap_in_retrieved_gtid_set.result File 1.99 KB 0644
rpl_general_log.result File 936 B 0644
rpl_geometry.result File 802 B 0644
rpl_get_lock.result File 1.45 KB 0644
rpl_get_master_version_and_clock.result File 3.05 KB 0644
rpl_grant.result File 9.79 KB 0644
rpl_grant_plugin.result File 803 B 0644
rpl_group_commit_deadlock.result File 1.14 KB 0644
rpl_gtid_binary_log_as_relay_log.result File 1.1 KB 0644
rpl_gtid_binlog_errors.result File 8.94 KB 0644
rpl_gtid_delete_memory_table_after_start_server.result File 3.74 KB 0644
rpl_gtid_deleted_binlog_fail_to_connect.result File 2.36 KB 0644
rpl_gtid_do_table_filter_insensitive.result File 1.79 KB 0644
rpl_gtid_do_table_filter_sensitive.result File 1.79 KB 0644
rpl_gtid_drop_mem_table.result File 5.43 KB 0644
rpl_gtid_drop_table.result File 12.4 KB 0644
rpl_gtid_empty_transaction.result File 4.2 KB 0644
rpl_gtid_execution.result File 78.69 KB 0644
rpl_gtid_failover.result File 1.61 KB 0644
rpl_gtid_heartbeat_2slave.result File 2.31 KB 0644
rpl_gtid_ignore_table_filter_insensitive.result File 1.8 KB 0644
rpl_gtid_ignore_table_filter_sensitive.result File 1.8 KB 0644
rpl_gtid_loaddata_s.result File 938 B 0644
rpl_gtid_mode.result File 5.9 KB 0644
rpl_gtid_mode_off_new_master.result File 1.27 KB 0644
rpl_gtid_mode_on_new_master.result File 1.26 KB 0644
rpl_gtid_mts_relay_log_recovery_auto_pos_on_off.result File 5.1 KB 0644
rpl_gtid_parallel.result File 1.61 KB 0644
rpl_gtid_purged_fail_to_connect.result File 2.91 KB 0644
rpl_gtid_purged_maintained.result File 6.99 KB 0644
rpl_gtid_replay_relaylog.result File 1.13 KB 0644
rpl_gtid_row_event_max_size.result File 3.48 KB 0644
rpl_gtid_row_show_relaylog_events.result File 9.86 KB 0644
rpl_gtid_server_sighup.result File 1.88 KB 0644
rpl_gtid_sql_until_before_after.result File 5.04 KB 0644
rpl_gtid_stm_insert_delayed.result File 2.49 KB 0644
rpl_gtid_stm_mix_show_relaylog_events.result File 8.76 KB 0644
rpl_gtid_temp_table.result File 45.55 KB 0644
rpl_gtid_transaction_split_across_relay_logs.result File 1.51 KB 0644
rpl_gtid_validate_slave_gtids.result File 2.39 KB 0644
rpl_gtids_restart_slave_io_lost_trx.result File 2.36 KB 0644
rpl_heartbeat.result File 5.9 KB 0644
rpl_heartbeat_2slaves.result File 2.31 KB 0644
rpl_heartbeat_basic.result File 19.9 KB 0644
rpl_heartbeat_ssl.result File 1.39 KB 0644
rpl_idempotency.result File 2.18 KB 0644
rpl_ignore_db_filter.result File 1.31 KB 0644
rpl_ignore_grant.result File 1.77 KB 0644
rpl_ignore_revoke.result File 1.45 KB 0644
rpl_ignore_table.result File 6.53 KB 0644
rpl_ignore_table_filter_insensitive.result File 1.66 KB 0644
rpl_ignore_table_filter_sensitive.result File 1.66 KB 0644
rpl_ignore_table_update.result File 988 B 0644
rpl_incident.result File 1.02 KB 0644
rpl_init_slave.result File 1.2 KB 0644
rpl_init_slave_errors.result File 1.08 KB 0644
rpl_innodb_bug28430.result File 5.27 KB 0644
rpl_innodb_bug30888.result File 1.35 KB 0644
rpl_innodb_mixed_ddl.result File 5.8 KB 0644
rpl_innodb_mixed_dml.result File 34.88 KB 0644
rpl_insert.result File 831 B 0644
rpl_insert_id.result File 11.51 KB 0644
rpl_insert_id_pk.result File 2.12 KB 0644
rpl_insert_ignore.result File 3.68 KB 0644
rpl_insert_on_update.result File 741 B 0644
rpl_invoked_features.result File 7.21 KB 0644
rpl_ip_mix.result File 2.72 KB 0644
rpl_ip_mix2.result File 2.72 KB 0644
rpl_ipv4_as_ipv6.result File 4.51 KB 0644
rpl_ipv6.result File 2.66 KB 0644
rpl_kill_query.result File 4.2 KB 0644
rpl_killed_ddl.result File 4.88 KB 0644
rpl_known_bugs_detection.result File 4 KB 0644
rpl_lcase_tblnames_rewrite_db.result File 1.21 KB 0644
rpl_loaddata.result File 5.89 KB 0644
rpl_loaddata_charset.result File 2.41 KB 0644
rpl_loaddata_fatal.result File 939 B 0644
rpl_loaddata_m.result File 1.18 KB 0644
rpl_loaddata_map.result File 1.68 KB 0644
rpl_loaddata_s.result File 745 B 0644
rpl_loaddata_simple.result File 1.83 KB 0644
rpl_loaddata_symlink.result File 738 B 0644
rpl_loaddatalocal.result File 4.88 KB 0644
rpl_loadfile.result File 3.18 KB 0644
rpl_locale.result File 805 B 0644
rpl_log_pos.result File 1.66 KB 0644
rpl_lost_events_on_rotate.result File 818 B 0644
rpl_low_slave_net_time_out.result File 1.26 KB 0644
rpl_manual_change_index_file.result File 2.64 KB 0644
rpl_many_optimize.result File 608 B 0644
rpl_master_connection.result File 17.91 KB 0644
rpl_master_pos_wait.result File 2.15 KB 0644
rpl_migration_crash_safe.result File 1.14 KB 0644
rpl_misc_functions.result File 2.55 KB 0644
rpl_mix_found_rows.result File 3.61 KB 0644
rpl_mix_insert_delayed.result File 2.28 KB 0644
rpl_mix_missing_data_on_slave.result File 725 B 0644
rpl_mixed_binlog_max_cache_size.result File 7.72 KB 0644
rpl_mixed_bit_pk.result File 1.86 KB 0644
rpl_mixed_ddl_dml.result File 1.63 KB 0644
rpl_mixed_drop_create_temp_table.result File 95.87 KB 0644
rpl_mixed_implicit_commit_binlog.result File 28.06 KB 0644
rpl_mixed_mixing_engines.result File 618.62 KB 0644
rpl_mixed_row_innodb.result File 3.08 KB 0644
rpl_mts_debug.result File 4.52 KB 0644
rpl_mts_execute_partial_trx_with_auto_pos_off.result File 1007 B 0644
rpl_mts_execute_partial_trx_with_auto_pos_on.result File 1007 B 0644
rpl_mts_gtids_restart_slave_io_lost_trx.result File 2.36 KB 0644
rpl_mts_pending_max.result File 6.42 KB 0644
rpl_mts_relay_log_post_crash_recovery.result File 3.32 KB 0644
rpl_mts_relay_log_recovery_on_error.result File 2.81 KB 0644
rpl_mts_slave_hang_with_partial_trx.result File 1 KB 0644
rpl_mts_stop_slave.result File 2.22 KB 0644
rpl_mts_stop_slave_report_pos.result File 3.59 KB 0644
rpl_multi_delete.result File 743 B 0644
rpl_multi_delete2.result File 1.27 KB 0644
rpl_multi_engine.result File 17.78 KB 0644
rpl_multi_update.result File 1.05 KB 0644
rpl_multi_update2.result File 1.5 KB 0644
rpl_multi_update3.result File 3.96 KB 0644
rpl_multi_update4.result File 971 B 0644
rpl_mysql_upgrade.result File 929 B 0644
rpl_mysqlbinlog_gtid_on.result File 1.46 KB 0644
rpl_name_const.result File 976 B 0644
rpl_no_gtid_delete_memory_table_after_start_server.result File 1.59 KB 0644
rpl_non_direct_mixed_mixing_engines.result File 631.89 KB 0644
rpl_non_direct_row_mixing_engines.result File 697.54 KB 0644
rpl_non_direct_stm_mixing_engines.result File 627.2 KB 0644
rpl_nondeterministic_functions.result File 1.05 KB 0644
rpl_not_null_innodb.result File 6.81 KB 0644
rpl_not_null_myisam.result File 6.81 KB 0644
rpl_optimize.result File 1.27 KB 0644
rpl_packet.result File 6.65 KB 0644
rpl_parallel.result File 5.81 KB 0644
rpl_parallel_change_master.result File 4.74 KB 0644
rpl_parallel_conf_limits.result File 1.6 KB 0644
rpl_parallel_conflicts.result File 2.23 KB 0644
rpl_parallel_ddl.result File 19.47 KB 0644
rpl_parallel_fallback.result File 868 B 0644
rpl_parallel_innodb.result File 4.03 KB 0644
rpl_parallel_load_data.result File 1.08 KB 0644
rpl_parallel_multi_db.result File 13.54 KB 0644
rpl_parallel_seconds_behind_master.result File 1.82 KB 0644
rpl_parallel_show_binlog_events_purge_logs.result File 757 B 0644
rpl_parallel_start_stop.result File 5.91 KB 0644
rpl_parallel_switch_sequential.result File 2.88 KB 0644
rpl_parallel_temp_query.result File 3.37 KB 0644
rpl_parallel_worker_error.result File 2.37 KB 0644
rpl_partition_archive.result File 6.47 KB 0644
rpl_partition_innodb.result File 6.46 KB 0644
rpl_partition_memory.result File 6.46 KB 0644
rpl_partition_myisam.result File 6.46 KB 0644
rpl_plugin_load.result File 1.74 KB 0644
rpl_ps.result File 1.78 KB 0644
rpl_rbr_to_sbr.result File 1.61 KB 0644
rpl_read_old_relay_log_info.result File 868 B 0644
rpl_read_only.result File 2.78 KB 0644
rpl_recovery_empty_sqlthd_pos.result File 1.43 KB 0644
rpl_recovery_replicate_same_server_id.result File 1.49 KB 0644
rpl_relay_log_recovery_positions.result File 1.54 KB 0644
rpl_relay_log_space_synchronization.result File 1016 B 0644
rpl_relay_space_innodb.result File 1.02 KB 0644
rpl_relay_space_myisam.result File 1.02 KB 0644
rpl_relayrotate.result File 815 B 0644
rpl_relayspace.result File 781 B 0644
rpl_replicate_do.result File 2.49 KB 0644
rpl_replicate_event_after_sync_stage.result File 1.17 KB 0644
rpl_replicate_ignore_db.result File 985 B 0644
rpl_replicate_rewrite_db.result File 506 B 0644
rpl_report.result File 1.43 KB 0644
rpl_report_port.result File 1.12 KB 0644
rpl_reset_slave_fail.result File 1.74 KB 0644
rpl_rewrite_db_filter.result File 1.94 KB 0644
rpl_rewrt_db.result File 6.73 KB 0644
rpl_rotate_gtid.result File 1.48 KB 0644
rpl_rotate_logs.result File 4.74 KB 0644
rpl_rotate_purge_deadlock.result File 1.29 KB 0644
rpl_rotate_row_trans.result File 1.52 KB 0644
rpl_row_001.result File 1.27 KB 0644
rpl_row_4_bytes.result File 933 B 0644
rpl_row_NOW.result File 1.21 KB 0644
rpl_row_USER.result File 2.34 KB 0644
rpl_row_UUID.result File 1.38 KB 0644
rpl_row_basic_11bugs.result File 7 KB 0644
rpl_row_basic_2myisam.result File 20.02 KB 0644
rpl_row_basic_3innodb.result File 20.37 KB 0644
rpl_row_basic_8partition.result File 31.82 KB 0644
rpl_row_basic_allow_batching.result File 20.31 KB 0644
rpl_row_binlog_max_cache_size.result File 7.68 KB 0644
rpl_row_blob_innodb.result File 5.22 KB 0644
rpl_row_blob_myisam.result File 5.22 KB 0644
rpl_row_colSize.result File 6.44 KB 0644
rpl_row_conflicts.result File 3.89 KB 0644
rpl_row_corrupt.result File 706 B 0644
rpl_row_corruption.result File 2.68 KB 0644
rpl_row_crash_safe.result File 94.51 KB 0644
rpl_row_create_select.result File 1.2 KB 0644
rpl_row_create_table.result File 12.21 KB 0644
rpl_row_delayed_ins.result File 1.05 KB 0644
rpl_row_drop.result File 1.69 KB 0644
rpl_row_drop_create_temp_table.result File 99.54 KB 0644
rpl_row_err_ignoredtable.result File 1.85 KB 0644
rpl_row_event_max_size.result File 3.36 KB 0644
rpl_row_find_row.result File 1.78 KB 0644
rpl_row_flsh_tbls.result File 1.21 KB 0644
rpl_row_func001.result File 881 B 0644
rpl_row_func002.result File 1.25 KB 0644
rpl_row_func003.result File 1.21 KB 0644
rpl_row_hash_scan.result File 4.54 KB 0644
rpl_row_hash_scan_sanity.result File 7.02 KB 0644
rpl_row_idempotency.result File 11.29 KB 0644
rpl_row_ignorable_event.result File 37.15 KB 0644
rpl_row_image_check_for_insert_select.result File 2.32 KB 0644
rpl_row_img_blobs.result File 168.72 KB 0644
rpl_row_img_eng_full.result File 139.69 KB 0644
rpl_row_img_eng_min.result File 131.41 KB 0644
rpl_row_img_eng_noblob.result File 131.39 KB 0644
rpl_row_img_idx_full.result File 121.06 KB 0644
rpl_row_img_idx_min.result File 121.84 KB 0644
rpl_row_img_idx_noblob.result File 121.82 KB 0644
rpl_row_img_misc.result File 1000 B 0644
rpl_row_img_sanity.result File 26.09 KB 0644
rpl_row_implicit_commit_binlog.result File 29.69 KB 0644
rpl_row_inexist_tbl.result File 1.06 KB 0644
rpl_row_insert_delayed.result File 2.25 KB 0644
rpl_row_lcase_tblnames.result File 1.53 KB 0644
rpl_row_loaddata_concurrent.result File 4.99 KB 0644
rpl_row_loaddata_m.result File 621 B 0644
rpl_row_log.result File 7.15 KB 0644
rpl_row_log_innodb.result File 7.22 KB 0644
rpl_row_max_relay_size.result File 1.97 KB 0644
rpl_row_merge_engine.result File 1.15 KB 0644
rpl_row_mixing_engines.result File 697.54 KB 0644
rpl_row_mts_crash_safe.result File 283.73 KB 0644
rpl_row_mts_rec_crash_safe.result File 283.73 KB 0644
rpl_row_mts_show_relaylog_events.result File 9.98 KB 0644
rpl_row_multi_query.result File 1.01 KB 0644
rpl_row_mysqlbinlog.result File 10.16 KB 0644
rpl_row_rec_comp_innodb.result File 1.99 KB 0644
rpl_row_rec_comp_myisam.result File 2.45 KB 0644
rpl_row_record_find_myisam.result File 870 B 0644
rpl_row_reset_slave.result File 4.45 KB 0644
rpl_row_rollback_to_savepoint.result File 15.42 KB 0644
rpl_row_show_relaylog_events.result File 10.02 KB 0644
rpl_row_slave_skip_error_all.result File 2.22 KB 0644
rpl_row_sp001.result File 1.9 KB 0644
rpl_row_sp002_innodb.result File 4.29 KB 0644
rpl_row_sp003.result File 1.5 KB 0644
rpl_row_sp005.result File 2.46 KB 0644
rpl_row_sp006_InnoDB.result File 1.52 KB 0644
rpl_row_sp007_innodb.result File 1.23 KB 0644
rpl_row_sp008.result File 1.09 KB 0644
rpl_row_sp009.result File 1.86 KB 0644
rpl_row_sp010.result File 1.57 KB 0644
rpl_row_sp011.result File 2.23 KB 0644
rpl_row_sp012.result File 1.92 KB 0644
rpl_row_tabledefs_2myisam.result File 5.52 KB 0644
rpl_row_tabledefs_3innodb.result File 5.52 KB 0644
rpl_row_tbl_metadata.result File 7.99 KB 0644
rpl_row_trig001.result File 1.45 KB 0644
rpl_row_trig002.result File 2.75 KB 0644
rpl_row_trig003.result File 3.93 KB 0644
rpl_row_trig004.result File 1.17 KB 0644
rpl_row_trunc_temp.result File 832 B 0644
rpl_row_unsafe_funcs.result File 846 B 0644
rpl_row_until.result File 3.21 KB 0644
rpl_row_utf16.result File 860 B 0644
rpl_row_utf32.result File 1.19 KB 0644
rpl_row_view01.result File 3.27 KB 0644
rpl_row_wide_table.result File 3.53 KB 0644
rpl_savepoint.result File 1.06 KB 0644
rpl_sbm_fake_rotate_event.result File 1.03 KB 0644
rpl_sbm_previous_gtid_event.result File 2.71 KB 0644
rpl_seconds_behind_master.result File 1.5 KB 0644
rpl_semi_sync.result File 14.49 KB 0644
rpl_semi_sync_deadlock.result File 1.05 KB 0644
rpl_semi_sync_event.result File 2.41 KB 0644
rpl_semi_sync_future_logpos.result File 1.3 KB 0644
rpl_semi_sync_group_commit_deadlock.result File 1.79 KB 0644
rpl_semi_sync_non_group_commit_deadlock.result File 1.87 KB 0644
rpl_semi_sync_shutdown_hang.result File 1.02 KB 0644
rpl_semi_sync_uninstall_plugin.result File 1.97 KB 0644
rpl_sequential.result File 5.9 KB 0644
rpl_server_id1.result File 844 B 0644
rpl_server_id2.result File 1.16 KB 0644
rpl_server_id_ignore.result File 2.42 KB 0644
rpl_server_uuid.result File 6.4 KB 0644
rpl_session_var.result File 1.76 KB 0644
rpl_set_charset.result File 1.72 KB 0644
rpl_set_null_innodb.result File 1.22 KB 0644
rpl_set_null_myisam.result File 1.22 KB 0644
rpl_show_errors.result File 1.89 KB 0644
rpl_show_master_info_file.result File 576 B 0644
rpl_show_slave_hosts.result File 1.18 KB 0644
rpl_show_slave_running.result File 1.67 KB 0644
rpl_show_slave_status_deadlock.result File 1.39 KB 0644
rpl_skip_ddl_errors_cli.result File 711 B 0644
rpl_skip_error.result File 3.5 KB 0644
rpl_skip_incident.result File 843 B 0644
rpl_skip_slave_err_warnings.result File 668 B 0644
rpl_slave_grp_exec.result File 3.21 KB 0644
rpl_slave_load_in.result File 1.06 KB 0644
rpl_slave_load_remove_tmpfile.result File 1.56 KB 0644
rpl_slave_load_tmpdir_not_exist.result File 681 B 0644
rpl_slave_skip.result File 7.64 KB 0644
rpl_slave_start.result File 1.45 KB 0644
rpl_slave_status.result File 2.2 KB 0644
rpl_slow_query_log.result File 3.99 KB 0644
rpl_sp.result File 36.94 KB 0644
rpl_sp004.result File 1.98 KB 0644
rpl_sp_effects.result File 4.77 KB 0644
rpl_sp_privileges.result File 2.35 KB 0644
rpl_spec_variables.result File 8.04 KB 0644
rpl_special_charset.result File 568 B 0644
rpl_sporadic_master.result File 979 B 0644
rpl_sql_thread_error.result File 767 B 0644
rpl_sql_thread_killed_waiting_commit_lock.result File 1.81 KB 0644
rpl_ssl.result File 3.31 KB 0644
rpl_ssl1.result File 3.51 KB 0644
rpl_stm_000001.result File 3.01 KB 0644
rpl_stm_EE_err2.result File 1.06 KB 0644
rpl_stm_auto_increment_bug33029.result File 6.16 KB 0644
rpl_stm_binlog_max_cache_size.result File 7.72 KB 0644
rpl_stm_conflicts.result File 2.03 KB 0644
rpl_stm_drop_create_temp_table.result File 100.14 KB 0644
rpl_stm_flsh_tbls.result File 1.21 KB 0644
rpl_stm_found_rows.result File 3.07 KB 0644
rpl_stm_ignore.result File 2.18 KB 0644
rpl_stm_implicit_commit_binlog.result File 28.09 KB 0644
rpl_stm_innodb.result File 3.6 KB 0644
rpl_stm_insert_delayed.result File 2.59 KB 0644
rpl_stm_lcase_tblnames.result File 1.45 KB 0644
rpl_stm_loaddata_concurrent.result File 7.08 KB 0644
rpl_stm_loadfile.result File 3.17 KB 0644
rpl_stm_log.result File 7.66 KB 0644
rpl_stm_max_relay_size.result File 1.97 KB 0644
rpl_stm_mix_mts_show_relaylog_events.result File 8.86 KB 0644
rpl_stm_mix_rollback_to_savepoint.result File 11.75 KB 0644
rpl_stm_mix_show_relaylog_events.result File 8.89 KB 0644
rpl_stm_mixed_crash_safe.result File 79.39 KB 0644
rpl_stm_mixed_mts_crash_safe.result File 270.29 KB 0644
rpl_stm_mixed_mts_rec_crash_safe.result File 270.29 KB 0644
rpl_stm_mixed_mts_rec_crash_safe_checksum.result File 270.29 KB 0644
rpl_stm_mixed_mts_rec_crash_safe_small.result File 66.49 KB 0644
rpl_stm_mixing_engines.result File 615.14 KB 0644
rpl_stm_multi_query.result File 1.71 KB 0644
rpl_stm_no_op.result File 1.75 KB 0644
rpl_stm_relay_ign_space.result File 14.77 KB 0644
rpl_stm_reset_slave.result File 4.45 KB 0644
rpl_stm_sql_mode.result File 1 KB 0644
rpl_stm_start_stop_slave.result File 3.56 KB 0644
rpl_stm_stop_middle_group.result File 3.57 KB 0644
rpl_stm_until.result File 4.04 KB 0644
rpl_stm_until_pos_middle_gtid.result File 1.25 KB 0644
rpl_stm_user_variables.result File 7.46 KB 0644
rpl_stop_slave.result File 4.33 KB 0644
rpl_stop_slave_threads_error.result File 871 B 0644
rpl_switch_stm_row_mixed.result File 13.44 KB 0644
rpl_sync.result File 1.97 KB 0644
rpl_temp_table.result File 1.25 KB 0644
rpl_temp_table_mix_row.result File 5.1 KB 0644
rpl_temporal_fractional.result File 4.95 KB 0644
rpl_temporary.result File 5.17 KB 0644
rpl_temporary_error_table_repository.result File 1.9 KB 0644
rpl_temporary_errors.result File 1.34 KB 0644
rpl_test_framework.result File 29.49 KB 0644
rpl_timestamp_upgrage_55.result File 1.02 KB 0644
rpl_timezone.result File 4.68 KB 0644
rpl_tmp_table_and_DDL.result File 9.04 KB 0644
rpl_trigger.result File 21.02 KB 0644
rpl_trunc_temp.result File 1002 B 0644
rpl_truncate_2myisam.result File 1.83 KB 0644
rpl_truncate_3innodb.result File 1.83 KB 0644
rpl_typeconv.result File 37.54 KB 0644
rpl_typeconv_innodb.result File 867 B 0644
rpl_udf.result File 5.12 KB 0644
rpl_unknown_ignorable_event.result File 1.28 KB 0644
rpl_unsafe_statements.result File 2.01 KB 0644
rpl_user.result File 4.49 KB 0644
rpl_user_variables.result File 5.76 KB 0644
rpl_variables.result File 23.22 KB 0644
rpl_variables_stm.result File 22.02 KB 0644
rpl_view.result File 3.74 KB 0644
rpl_view_multi.result File 3.08 KB 0644
rpl_zombie_dump_threads.result File 720 B 0644