[#MDEV-5589] Discrepancy in binlog on half-failed CREATE OR REPLACE

If CREATE OR REPLACE fails on CREATE stage, the table is still dropped, but nothing is written to the binlog. Obviously, it will cause further inconsistencies between master and slave, or upon restoring from binlog.

MariaDB [test]> create table t1 (i int);

Query OK, 0 rows affected (1.17 sec)

MariaDB [test]> create or replace table t1;

ERROR 1113 (42000): A table must have at least 1 column

MariaDB [test]> show binlog events;

+----------------------+-----+-------------------+-----------+-------------+-----------------------------------------------------+

| Log_name             | Pos | Event_type        | Server_id | End_log_pos | Info                                                |

+----------------------+-----+-------------------+-----------+-------------+-----------------------------------------------------+

| wheezy-64-bin.000001 |   4 | Format_desc       |         1 |         248 | Server ver: 10.0.7-MariaDB-debug-log, Binlog ver: 4 |

| wheezy-64-bin.000001 | 248 | Gtid_list         |         1 |         273 | []                                                  |

| wheezy-64-bin.000001 | 273 | Binlog_checkpoint |         1 |         316 | wheezy-64-bin.000001                                |

| wheezy-64-bin.000001 | 316 | Gtid              |         1 |         354 | GTID 0-1-1                                          |

| wheezy-64-bin.000001 | 354 | Query             |         1 |         440 | use `test`; create table t1 (i int)                 |

+----------------------+-----+-------------------+-----------+-------------+-----------------------------------------------------+

5 rows in set (0.00 sec)

MariaDB [test]> show tables;

Empty set (0.00 sec)

--source include/master-slave.inc

create table t1 (i int);

--error ER_TABLE_MUST_HAVE_COLUMNS

create or replace table t1;

show binlog events;

show tables;

create table t1 (j int);

--sync_slave_with_master

CREATE OR REPLACE TABLE (MDEV-5491) [MDEV-5589] Discrepancy in binlog on half-failed CREATE OR REPLACE Created: 2014-01-29 Updated: 2019-07-25 Resolved: 2014-03-20
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	None
Fix Version/s:	10.0.10

[MDEV-5589] Discrepancy in binlog on half-failed CREATE OR REPLACE Created: 2014-01-29 Updated: 2019-07-25 Resolved: 2014-03-20