Gecko [ 122.154.134.11 ]

Name	Size	Permission
binlog_base64_flag.result	3.74 KB	-rw-r--r--
binlog_bug23533.result	486 B	-rw-r--r--
binlog_bug36391.result	129 B	-rw-r--r--
binlog_database.result	5.28 KB	-rw-r--r--
binlog_delete_and_flush_index....	1.75 KB	-rw-r--r--
binlog_drop_if_exists.result	5.26 KB	-rw-r--r--
binlog_grant.result	1.18 KB	-rw-r--r--
binlog_incident.result	181 B	-rw-r--r--
binlog_index.result	5.2 KB	-rw-r--r--
binlog_innodb.result	6.05 KB	-rw-r--r--
binlog_innodb_row.result	2.47 KB	-rw-r--r--
binlog_killed.result	3.43 KB	-rw-r--r--
binlog_killed_simulate.result	1.25 KB	-rw-r--r--
binlog_mix_innodb_stat.result	610 B	-rw-r--r--
binlog_mixed_failure_mixing_en...	16.79 KB	-rw-r--r--
binlog_mixed_load_data.result	429 B	-rw-r--r--
binlog_multi_engine.result	4.59 KB	-rw-r--r--
binlog_mysqlbinlog-cp932.resul...	344 B	-rw-r--r--
binlog_mysqlbinlog2.result	36.63 KB	-rw-r--r--
binlog_mysqlbinlog_base64.resu...	1.69 KB	-rw-r--r--
binlog_mysqlbinlog_row.result	150.85 KB	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	239.94 KB	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	241.25 KB	-rw-r--r--
binlog_mysqlbinlog_row_trans.r...	16.1 KB	-rw-r--r--
binlog_old_versions.result	1.3 KB	-rw-r--r--
binlog_query_filter_rules.resu...	173 B	-rw-r--r--
binlog_reset_master.result	14 B	-rw-r--r--
binlog_row_binlog.result	76.4 KB	-rw-r--r--
binlog_row_ctype_cp932.result	87.42 KB	-rw-r--r--
binlog_row_ctype_ucs.result	1.27 KB	-rw-r--r--
binlog_row_drop_tmp_tbl.result	1.17 KB	-rw-r--r--
binlog_row_failure_mixing_engi...	18.09 KB	-rw-r--r--
binlog_row_innodb_stat.result	610 B	-rw-r--r--
binlog_row_insert_select.resul...	829 B	-rw-r--r--
binlog_row_mix_innodb_myisam.r...	32.72 KB	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	1.5 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	2.68 KB	-rw-r--r--
binlog_server_id.result	1.2 KB	-rw-r--r--
binlog_sf.result	1.67 KB	-rw-r--r--
binlog_sql_mode.result	3.51 KB	-rw-r--r--
binlog_start_comment.result	357 B	-rw-r--r--
binlog_statement_insert_delaye...	949 B	-rw-r--r--
binlog_stm_binlog.result	51.51 KB	-rw-r--r--
binlog_stm_blackhole.result	7.29 KB	-rw-r--r--
binlog_stm_ctype_cp932.result	87.42 KB	-rw-r--r--
binlog_stm_ctype_ucs.result	1.29 KB	-rw-r--r--
binlog_stm_do_db.result	2.08 KB	-rw-r--r--
binlog_stm_drop_tmp_tbl.result	2.3 KB	-rw-r--r--
binlog_stm_innodb_stat.result	610 B	-rw-r--r--
binlog_stm_insert_select.resul...	707 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.r...	30.23 KB	-rw-r--r--
binlog_stm_ps.result	811 B	-rw-r--r--
binlog_stm_row.result	2.48 KB	-rw-r--r--
binlog_stm_unsafe_warning.resu...	1.71 KB	-rw-r--r--
binlog_tmp_table.result	877 B	-rw-r--r--
binlog_truncate_innodb.result	2.45 KB	-rw-r--r--
binlog_truncate_myisam.result	439 B	-rw-r--r--
binlog_unsafe.result	13.81 KB	-rw-r--r--
binlog_write_error.result	3.58 KB	-rw-r--r--

Code Editor : binlog_drop_if_exists.result

RESET MASTER;
DROP PROCEDURE IF EXISTS db_bug_13684.p;
DROP FUNCTION IF EXISTS db_bug_13684.f;
DROP TRIGGER IF EXISTS db_bug_13684.tr;
DROP VIEW IF EXISTS db_bug_13684.v;
DROP EVENT IF EXISTS db_bug_13684.e;
DROP TABLE IF EXISTS db_bug_13684.t;
DROP DATABASE IF EXISTS db_bug_13684;
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
master-bin.000001	#	Query	#	#	use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
master-bin.000001	#	Query	#	#	use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
master-bin.000001	#	Query	#	#	use `test`; DROP VIEW IF EXISTS db_bug_13684.v
master-bin.000001	#	Query	#	#	use `test`; DROP EVENT IF EXISTS db_bug_13684.e
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS db_bug_13684.t
master-bin.000001	#	Query	#	#	DROP DATABASE IF EXISTS db_bug_13684
CREATE DATABASE db_bug_13684;
CREATE TABLE db_bug_13684.t (a int);
CREATE EVENT db_bug_13684.e
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
DO
UPDATE db_bug_13684.t SET a = a + 1;
CREATE VIEW db_bug_13684.v 
AS SELECT * FROM db_bug_13684.t;
CREATE TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
FOR EACH ROW BEGIN
END;
CREATE PROCEDURE db_bug_13684.p (OUT p1 INT)
BEGIN
END;
CREATE FUNCTION db_bug_13684.f (s CHAR(20))
RETURNS CHAR(50) DETERMINISTIC
RETURN s;
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
master-bin.000001	#	Query	#	#	use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
master-bin.000001	#	Query	#	#	use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
master-bin.000001	#	Query	#	#	use `test`; DROP VIEW IF EXISTS db_bug_13684.v
master-bin.000001	#	Query	#	#	use `test`; DROP EVENT IF EXISTS db_bug_13684.e
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS db_bug_13684.t
master-bin.000001	#	Query	#	#	DROP DATABASE IF EXISTS db_bug_13684
master-bin.000001	#	Query	#	#	CREATE DATABASE db_bug_13684
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE db_bug_13684.t (a int)
master-bin.000001	#	Query	#	#	use `test`; CREATE DEFINER=`root`@`localhost` EVENT db_bug_13684.e
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
DO
UPDATE db_bug_13684.t SET a = a + 1
master-bin.000001	#	Query	#	#	use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `db_bug_13684`.`v` AS SELECT * FROM db_bug_13684.t
master-bin.000001	#	Query	#	#	use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
FOR EACH ROW BEGIN
END
master-bin.000001	#	Query	#	#	use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `db_bug_13684`.`p`(OUT p1 INT)
BEGIN
END
master-bin.000001	#	Query	#	#	use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `db_bug_13684`.`f`(s CHAR(20)) RETURNS char(50) CHARSET latin1
    DETERMINISTIC
RETURN s
DROP PROCEDURE IF EXISTS db_bug_13684.p;
DROP FUNCTION IF EXISTS db_bug_13684.f;
DROP TRIGGER IF EXISTS db_bug_13684.tr;
DROP VIEW IF EXISTS db_bug_13684.v;
DROP EVENT IF EXISTS db_bug_13684.e;
DROP TABLE IF EXISTS db_bug_13684.t;
DROP DATABASE IF EXISTS db_bug_13684;
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
master-bin.000001	#	Query	#	#	use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
master-bin.000001	#	Query	#	#	use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
master-bin.000001	#	Query	#	#	use `test`; DROP VIEW IF EXISTS db_bug_13684.v
master-bin.000001	#	Query	#	#	use `test`; DROP EVENT IF EXISTS db_bug_13684.e
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS db_bug_13684.t
master-bin.000001	#	Query	#	#	DROP DATABASE IF EXISTS db_bug_13684
master-bin.000001	#	Query	#	#	CREATE DATABASE db_bug_13684
master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE db_bug_13684.t (a int)
master-bin.000001	#	Query	#	#	use `test`; CREATE DEFINER=`root`@`localhost` EVENT db_bug_13684.e
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
DO
UPDATE db_bug_13684.t SET a = a + 1
master-bin.000001	#	Query	#	#	use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `db_bug_13684`.`v` AS SELECT * FROM db_bug_13684.t
master-bin.000001	#	Query	#	#	use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER db_bug_13684.tr BEFORE INSERT ON db_bug_13684.t
FOR EACH ROW BEGIN
END
master-bin.000001	#	Query	#	#	use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `db_bug_13684`.`p`(OUT p1 INT)
BEGIN
END
master-bin.000001	#	Query	#	#	use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `db_bug_13684`.`f`(s CHAR(20)) RETURNS char(50) CHARSET latin1
    DETERMINISTIC
RETURN s
master-bin.000001	#	Query	#	#	use `test`; DROP PROCEDURE IF EXISTS db_bug_13684.p
master-bin.000001	#	Query	#	#	use `test`; DROP FUNCTION IF EXISTS db_bug_13684.f
master-bin.000001	#	Query	#	#	use `test`; DROP TRIGGER IF EXISTS db_bug_13684.tr
master-bin.000001	#	Query	#	#	use `test`; DROP VIEW IF EXISTS db_bug_13684.v
master-bin.000001	#	Query	#	#	use `test`; DROP EVENT IF EXISTS db_bug_13684.e
master-bin.000001	#	Query	#	#	use `test`; DROP TABLE IF EXISTS db_bug_13684.t
master-bin.000001	#	Query	#	#	DROP DATABASE IF EXISTS db_bug_13684

${this.title}

Code Editor : binlog_drop_if_exists.result