Gecko [ 122.154.134.11 ]

Name	Size	Permission
binlog_base64_flag.test	5.38 KB	-rw-r--r--
binlog_bug23533.test	1.45 KB	-rw-r--r--
binlog_bug36391-master.opt	32 B	-rw-r--r--
binlog_bug36391.test	1023 B	-rw-r--r--
binlog_database.test	369 B	-rw-r--r--
binlog_delete_and_flush_index....	3.49 KB	-rw-r--r--
binlog_drop_if_exists.test	3.47 KB	-rw-r--r--
binlog_grant.test	1.82 KB	-rw-r--r--
binlog_incident-master.opt	52 B	-rw-r--r--
binlog_incident.test	939 B	-rw-r--r--
binlog_index-master.opt	16 B	-rw-r--r--
binlog_index.test	7.34 KB	-rw-r--r--
binlog_innodb.test	3.97 KB	-rw-r--r--
binlog_innodb_row.test	2.19 KB	-rw-r--r--
binlog_killed.test	8.21 KB	-rw-r--r--
binlog_killed_simulate-master....	39 B	-rw-r--r--
binlog_killed_simulate.test	2.54 KB	-rw-r--r--
binlog_mix_innodb_stat.test	230 B	-rw-r--r--
binlog_mixed_failure_mixing_en...	143 B	-rw-r--r--
binlog_mixed_load_data.test	501 B	-rw-r--r--
binlog_multi_engine.test	2.78 KB	-rw-r--r--
binlog_mysqlbinlog-cp932-maste...	23 B	-rw-r--r--
binlog_mysqlbinlog-cp932.test	975 B	-rw-r--r--
binlog_mysqlbinlog2.test	7.07 KB	-rw-r--r--
binlog_mysqlbinlog_base64.test	2.45 KB	-rw-r--r--
binlog_mysqlbinlog_row.test	10.67 KB	-rw-r--r--
binlog_mysqlbinlog_row_innodb....	638 B	-rw-r--r--
binlog_mysqlbinlog_row_myisam....	631 B	-rw-r--r--
binlog_mysqlbinlog_row_trans.t...	3.71 KB	-rw-r--r--
binlog_old_versions.test	4.99 KB	-rw-r--r--
binlog_query_filter_rules-mast...	40 B	-rw-r--r--
binlog_query_filter_rules.test	808 B	-rw-r--r--
binlog_reset_master.test	998 B	-rw-r--r--
binlog_row_binlog-master.opt	24 B	-rw-r--r--
binlog_row_binlog.test	223 B	-rw-r--r--
binlog_row_ctype_cp932.test	228 B	-rw-r--r--
binlog_row_ctype_ucs.test	234 B	-rw-r--r--
binlog_row_drop_tmp_tbl.test	232 B	-rw-r--r--
binlog_row_failure_mixing_engi...	141 B	-rw-r--r--
binlog_row_innodb_stat-master....	26 B	-rw-r--r--
binlog_row_innodb_stat.test	228 B	-rw-r--r--
binlog_row_insert_select.test	471 B	-rw-r--r--
binlog_row_mix_innodb_myisam-m...	29 B	-rw-r--r--
binlog_row_mix_innodb_myisam.t...	545 B	-rw-r--r--
binlog_row_mysqlbinlog_db_filt...	4.12 KB	-rw-r--r--
binlog_row_mysqlbinlog_verbose...	3.76 KB	-rw-r--r--
binlog_server_id.test	663 B	-rw-r--r--
binlog_sf.test	2.67 KB	-rw-r--r--
binlog_sql_mode.test	4.58 KB	-rw-r--r--
binlog_start_comment.test	900 B	-rw-r--r--
binlog_statement_insert_delaye...	336 B	-rw-r--r--
binlog_stm_binlog-master.opt	40 B	-rw-r--r--
binlog_stm_binlog.test	483 B	-rw-r--r--
binlog_stm_blackhole.test	267 B	-rw-r--r--
binlog_stm_ctype_cp932.test	278 B	-rw-r--r--
binlog_stm_ctype_ucs.test	249 B	-rw-r--r--
binlog_stm_do_db-master.opt	38 B	-rw-r--r--
binlog_stm_do_db.test	2.78 KB	-rw-r--r--
binlog_stm_drop_tmp_tbl.test	247 B	-rw-r--r--
binlog_stm_innodb_stat-master....	26 B	-rw-r--r--
binlog_stm_innodb_stat.test	234 B	-rw-r--r--
binlog_stm_insert_select.test	252 B	-rw-r--r--
binlog_stm_mix_innodb_myisam-m...	29 B	-rw-r--r--
binlog_stm_mix_innodb_myisam.t...	512 B	-rw-r--r--
binlog_stm_ps.test	701 B	-rw-r--r--
binlog_stm_row.test	3.06 KB	-rw-r--r--
binlog_stm_unsafe_warning-mast...	38 B	-rw-r--r--
binlog_stm_unsafe_warning.test	3.7 KB	-rw-r--r--
binlog_tmp_table.test	3.94 KB	-rw-r--r--
binlog_truncate_innodb-master....	14 B	-rw-r--r--
binlog_truncate_innodb.test	1.07 KB	-rw-r--r--
binlog_truncate_myisam.test	352 B	-rw-r--r--
binlog_unsafe.test	13.34 KB	-rw-r--r--
binlog_write_error.test	2.31 KB	-rw-r--r--
disabled.def	634 B	-rw-r--r--

Code Editor : binlog_drop_if_exists.test

# BUG#13684: 
#   SP: DROP PROCEDURE|FUNCTION IF EXISTS not binlogged if routine 
#   does not exist
#   
#   There is an inconsistency with DROP DATABASE IF EXISTS, DROP
#   TABLE IF EXISTS and DROP VIEW IF EXISTS: those are binlogged even
#   if the DB or TABLE does not exist, whereas DROP PROCEDURE IF
#   EXISTS does not. It would be nice or at least consistent if DROP
#   PROCEDURE/STATEMENT worked the same too.
#
# Description: 
#   DROP PROCEDURE|FUNCTION IF EXISTS does not get binlogged whereas DROP
#   DATABASE|TABLE|TRIGGER|... IF EXISTS do.
#
#   Fixed DROP PROCEDURE|FUNCTION IF EXISTS by adding a call to
#   write_bin_log in mysql_execute_command. Checked also if all
#   documented "DROP (...) IF EXISTS" get binlogged. Left out DROP
#   SERVER IF EXISTS because it seems that it only gets binlogged when
#   using row event (see BUG#25705).
#
#   TODO: add DROP SERVER IF EXISTS to the test case when its
#   binlogging procedure gets fixed (BUG#25705). Furthermore, when
#   logging in RBR format the events that get logged are effectively in
#   RBR format and not in STATEMENT format meaning that one must needs
#   to be extra careful when writing a test for it, or change the CREATE
#   SERVER logging to always log as STATEMENT. You can quickly check this
#   by enabling the flag below $fixed_bug_25705=1 and watch the diff on
#   the STDOUT. More detail may be found on the generated reject file.
#   
#   Test is implemented as follows:
#
#       i) test each "drop if exists" (DDL), found in MySQL 5.1 manual, 
#          on inexistent objects (except for DROP SERVER);
#      ii) show binlog events;
#     iii) create an object for each drop if exists statement;
#      iv) issue "drop if exists" in existent objects.
#       v) show binlog events;
#
# References:
#  http://dev.mysql.com/doc/refman/5.1/en/sql-syntax-data-definition.html
#
--source include/have_log_bin.inc
RESET MASTER;

disable_warnings;

# test all "drop if exists" in manual with inexistent objects
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;

let $fixed_bug_25705 = 0;

if($fixed_bug_25705)
{
  DROP SERVER IF EXISTS s_bug_13684;
}
--source include/show_binlog_events.inc

# test drop with existing values

# create 
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;

if($fixed_bug_25705)
{
  CREATE SERVER s_bug_13684
    FOREIGN DATA WRAPPER mysql
    OPTIONS (USER 'Remote', HOST '192.168.1.106', DATABASE 'test');
}

--source include/show_binlog_events.inc

# drop existing 
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;
if($fixed_bug_25705)
{
  DROP SERVER IF EXISTS s_bug_13684;
}

--source include/show_binlog_events.inc

enable_warnings;

${this.title}

Code Editor : binlog_drop_if_exists.test