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

# BUG#42829: binlogging enabled for all schemas regardless of
# binlog-db-db / binlog-ignore-db
#
# WHAT
# ====
#
#  We want to test whether filtered events from binlog will cause
#  raising an error mentioning that statement is unable to be logged or
#  not, when:
#
#   1. isolation level READ-COMMITTED; AND
#
#   2. using InnoDB engine; AND
#
#   3. using SBL (in which case InnoDB will only allow RBL).
#
# HOW
# ===
#
#  The test is implemented as follows:
#
#     i) set tx_isolation to read-committed.
#
#    ii) create two databases (one filtered other not - using
#        binlog-do-db)
#
#   iii) Create statements that are to be filtered on filtered db
#
#       - At this point, before fix, an error would be raised
#
#    iv) do the same thing for not the filtered database and check
#        that events throw an error:
#
#      - Error: ER_BINLOG_STMT_MODE_AND_ROW_ENGINE
#

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

SET @old_isolation_level= @@session.tx_isolation;
SET @@session.tx_isolation= 'READ-COMMITTED';

-- let $engine= InnoDB
-- let $filtered= b42829_filtered
-- let $not_filtered= b42829

-- eval CREATE DATABASE $not_filtered
-- eval use $not_filtered
-- eval CREATE TABLE t1 (x int, y int) engine=$engine
-- eval CREATE TABLE t2 (x int, y int) engine=$engine

-- eval CREATE DATABASE $filtered
-- eval use $filtered
-- eval CREATE TABLE t1 (x int, y int) engine=$engine
-- eval CREATE TABLE t2 (x int, y int) engine=$engine

SET @@session.sql_log_bin= 0;
-- eval INSERT INTO $filtered.t1 VALUES (100,100)
-- eval INSERT INTO $not_filtered.t1 VALUES (100,100)
SET @@session.sql_log_bin= 1;

-- echo ### assertion: the inserts will not raise log error because
-- echo ###            binlog-do-db is filtering used database
INSERT INTO t2 VALUES (1,2), (1,3), (1,4);
INSERT INTO t1 SELECT * FROM t2;

-- echo ### assertion: assert that despite updating a not filtered
-- echo ###            database this wont trigger an error as the
-- echo ###            used database is the filtered one.
-- eval UPDATE $filtered.t1 ft1, $not_filtered.t1 nft1 SET ft1.x=1, nft1.x=2

-- eval use $not_filtered
-- echo ### assertion: the statements *will* raise log error because
-- echo ###            binlog-do-db is not filtering  used database 
BEGIN;
-- error ER_BINLOG_LOGGING_IMPOSSIBLE
INSERT INTO t2 VALUES (1,2), (1,3), (1,4);
-- error ER_BINLOG_LOGGING_IMPOSSIBLE
-- eval UPDATE $filtered.t1 ft1, $not_filtered.t1 nft1 SET ft1.x=1, nft1.x=2
-- error ER_BINLOG_LOGGING_IMPOSSIBLE
INSERT INTO t1 SELECT * FROM t2;
COMMIT;

-- echo ### assertion: filtered events did not make into the binlog
source include/show_binlog_events.inc;

-- eval DROP DATABASE $not_filtered
-- eval DROP DATABASE $filtered
SET @@session.tx_isolation= @old_isolation_level;

${this.title}

Code Editor : binlog_stm_do_db.test