[MDEV-10320] NO-OP ALTER TABLE on temporary tables getting logged under row binlog format Created: 2016-07-01  Updated: 2016-08-09  Resolved: 2016-08-09

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Temporary, Replication
Affects Version/s: 10.1
Fix Version/s: 10.2.2

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

Temporary table operations should never get replicated under row-based replication.

How to repeat:

--source include/master-slave.inc
 
--source include/have_binlog_format_row.inc
 
connection master;
 
CREATE TEMPORARY TABLE t1(i INT PRIMARY KEY) ENGINE=MYISAM;
 
ALTER TABLE t1;
 
ALTER TABLE t1 ADD COLUMN IF NOT EXISTS I INT;
 
DROP TABLE t1;
 
--source include/rpl_end.inc

Error on slave:

2016-07-01 13:10:50 140508493802240 [ERROR] Slave SQL: Error 'Table 'test.t1' doesn't exist' on query. Default database: 'test'. Query: 'ALTER TABLE t1', Gtid 0-1-1, Internal MariaDB error code: 1146
 
2016-07-01 13:10:50 140508493802240 [Warning] Slave: Table 'test.t1' doesn't exist Error_code: 1146


Generated at Thu Feb 08 07:41:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.