Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.20, 11.2.2
-
None
-
Linux, n.a.
Description
When I have a table test on the Slave which does NOT exist on the Master and later I create the table on the Master the table is dropped and recreated on the Slave!!!
This is not expected behaviour. We expect that replication stops with an error.
This is also not the behaviour from a competitive product.
- Reproduce:
On Slave:
create table test (id int, data varchar(255));
insert into test values (1, 'Some data'), (2, 'Some more data');
select * from test;
2 rows in set (0.000 sec)
On Master:
create table test (id int);
On Slave;
select * from test;
|
Empty set (0.001 sec)
|
show create table test\G
|
*************************** 1. row ***************************
|
Table: test
|
Create Table: CREATE TABLE `test` (
|
`id` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|
 |
show slave status\G
|
Slave_IO_Running: Yes
|
Slave_SQL_Running: Yes
|
Last_SQL_Errno: 0
|
Last_SQL_Error:
|
Really bad...