Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
None
-
None
-
None
Description
CREATE TABLE IF NOT EXISTS on an existing table is not written to the binlog in MariaDB 10.11.14, meaning the statement never reaches replicas
This worked in MariaDB 5.5.68 and was explicitly tested and expected to work in MDEV-7817 (commit 90f2c82, 2015)
test scenario:
1. on master: CREATE TABLE IF NOT EXISTS aaa (b VARCHAR(5));
2. on slave: table appears via binglog, manually delete the table
3. on master: CREATE TABLE IF NOT EXISTS aaa (b VARCHAR(5));
4. on slave: table does not appear
Note it happens regardless of binlog_do_db — tested with and without
binlog_format=ROW, sql_log_bin=ON
Reference MDEV-7817 as the precedent fix for the same class of bug (ALTER TABLE IF NOT EXISTS), and note that the existing create_drop_binlog test expects this to work