Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0.19, 5.1.73, 5.5(EOL), 10.0(EOL), 10.1(EOL)
-
5.5.48-0
Description
my.cnf (full file attached)
...
|
binlog-format = ROW
|
binlog-do-db = test_db1
|
binlog-do-db = test_db2
|
...
|
Test case:
Server version: 10.0.19-MariaDB-log MariaDB Server
|
|
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> create database test_db1;
|
Query OK, 1 row affected (0.00 sec)
|
|
MariaDB [(none)]> create database test_db2;
|
Query OK, 1 row affected (0.00 sec)
|
|
MariaDB [(none)]> create database test_db3;
|
Query OK, 1 row affected (0.00 sec)
|
|
MariaDB [(none)]> create table test_db1.t(i int);
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [(none)]> create table test_db2.t(i int);
|
Query OK, 0 rows affected (0.01 sec)
|
|
MariaDB [(none)]> create table test_db3.t(i int);
|
Query OK, 0 rows affected (0.01 sec)
|
|
MariaDB [(none)]> insert into test_db1.t values (1);
|
Query OK, 1 row affected (0.00 sec)
|
|
MariaDB [(none)]> insert into test_db2.t values (1);
|
Query OK, 1 row affected (0.00 sec)
|
|
MariaDB [(none)]> insert into test_db3.t values (1);
|
Query OK, 1 row affected (0.00 sec)
|
Relevant entries in binlog (full file attached)
create database test_db1
|
create database test_db2
|
create table test_db1.t(i int)
|
create table test_db2.t(i int)
|
create table test_db3.t(i int)
|
### INSERT INTO `test_db1`.`t`
|
### INSERT INTO `test_db2`.`t`
|
Even though test_db3 is not included in binlog-do-db options, 'create table test_db3.t(i int)' is logged.
TIA