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_row_mysqlbinlog_db_filter.test

# BUG#42941: --database parameter to mysqlbinlog fails with RBR
#
# WHAT
# ====
#
#  This test aims at checking whether a rows log event is printed or
#  not when --database parameter is used to filter events from one
#  given database.
#
# HOW
# ===
#
#  The test is implemented as follows: 
#
#    i) Some operations are done in two different databases:
#       'test' and 'b42941';
#   ii) mysqlbinlog is used to dump the contents of the binlog file
#       filtering only events from 'b42941'. The result of the dump is
#       stored in a temporary file. (This is done with and without
#       --verbose/hexdump flag);
#  iii) The contents of the dump are loaded into a session variable;
#   iv) The variable contents are searched for 'test' and 'b42941';
#    v) Should 'test' be found, an ERROR is reported. Should 'b42941' be
#       absent, an ERROR is reported.

-- source include/have_log_bin.inc
-- source include/have_binlog_format_row.inc
-- source include/have_innodb.inc

RESET MASTER;
-- let $MYSQLD_DATADIR= `select @@datadir`

CREATE TABLE t1 (id int);
CREATE TABLE t2 (id int);
CREATE TABLE t3 (txt TEXT);
CREATE TABLE t4 (a int) ENGINE= InnoDB;
INSERT INTO t1 VALUES (1);
INSERT INTO t1 VALUES (2);
INSERT INTO t2 VALUES (1);
INSERT INTO t2 VALUES (2);
INSERT INTO t1 VALUES (3);
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
-- eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/std_data/words.dat' INTO TABLE t3
INSERT INTO t1 VALUES (4);

CREATE DATABASE b42941;
use b42941;
CREATE TABLE t1 (id int);
CREATE TABLE t2 (id int);
CREATE TABLE t3 (txt TEXT);
CREATE TABLE t4 (a int) ENGINE= InnoDB;
INSERT INTO t1 VALUES (1);
INSERT INTO t1 VALUES (2);
INSERT INTO t2 VALUES (1);
INSERT INTO t2 VALUES (2);
INSERT INTO t1 VALUES (3);
-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
-- eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/std_data/words.dat' INTO TABLE t3
INSERT INTO t1 VALUES (4);

INSERT INTO test.t1 VALUES (5);

FLUSH LOGS;

UPDATE test.t1 t11, b42941.t1 t12 SET t11.id=10, t12.id=100;

BEGIN;
INSERT INTO test.t4 VALUES (1);
INSERT INTO b42941.t4 VALUES (1);
UPDATE test.t4 tn4, b42941.t4 tt4 SET tn4.a= 10, tt4.a= 100;
COMMIT;

FLUSH LOGS;

-- let $log_file1= $MYSQLD_DATADIR/master-bin.000001
-- let $log_file2= $MYSQLD_DATADIR/master-bin.000002
-- let $outfile= $MYSQLTEST_VARDIR/tmp/b42941-mysqlbinlog
-- let $cmd= $MYSQL_BINLOG

let $i= 3;
while($i)
{
  -- let $flags=--database=b42941

# construct CLI for mysqlbinlog
  if(`SELECT $i=3`)
  {
    -- let $flags= $flags --verbose --hexdump
  }

if(`SELECT $i=2`)
  {
    -- let $flags= $flags --verbose
  }

#  if(`SELECT $i=1`)
#  {
    # do nothing $flags is already set as it should be
#  }

# execute mysqlbinlog on the two available master binlog files
  -- exec $cmd $flags $log_file1 > $outfile.1
  -- exec $cmd $flags $log_file2 > $outfile.2

# load outputs into a variable
  -- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
  -- eval SET @b42941_output.1= LOAD_FILE('$outfile.1')

-- replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
  -- eval SET @b42941_output.2= LOAD_FILE('$outfile.2')

# remove unecessary files
  -- remove_file $outfile.1
  -- remove_file $outfile.2
  
  #
  # The two tests are canceled since we introduced the patch of bug#46998,  
  # which will make mydsqlbinlog output the 'BEGIN', 'COMMIT' and 'ROLLBACK' 
  # in regardless of database filtering
  #
  # assertion: events for database test are filtered
  #if (`SELECT INSTR(@b42941_output.1, 'test')`)
  #{
    #-- echo **** ERROR **** Database name 'test' FOUND in mysqlbinlog output ($flags $outfile.1).
  #}

#if (`SELECT INSTR(@b42941_output.2, 'test')`)
  #{
    #-- echo **** ERROR **** Database name 'test' FOUND in mysqlbinlog output ($flags $outfile.2).
  #}

# assertion: events for database b42941 are not filtered
  if (!`SELECT INSTR(@b42941_output.1, 'b42941')`)
  {
    -- echo **** ERROR **** Database name 'b42941' NOT FOUND in mysqlbinlog output ($flags $outfile.1).
  }

if (!`SELECT INSTR(@b42941_output.2, 'b42941')`)
  {
    -- echo **** ERROR **** Database name 'b42941' NOT FOUND in mysqlbinlog output ($flags $outfile.2).
  }

dec $i;
}

DROP DATABASE b42941;
use test;
DROP TABLE t1, t2, t3, t4;

${this.title}

Code Editor : binlog_row_mysqlbinlog_db_filter.test