| Server IP : 104.21.38.3 / Your IP : 172.69.165.78 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/binlog/t/ |
Upload File : |
# 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_STMT_MODE_AND_ROW_ENGINE INSERT INTO t2 VALUES (1,2), (1,3), (1,4); -- error ER_BINLOG_STMT_MODE_AND_ROW_ENGINE -- eval UPDATE $filtered.t1 ft1, $not_filtered.t1 nft1 SET ft1.x=1, nft1.x=2 -- error ER_BINLOG_STMT_MODE_AND_ROW_ENGINE 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;