MySQL Bugs: #30476: Extra master columns: Partition test fails in Mixed and Statement, passes RBR

Bug #30476	Extra master columns: Partition test fails in Mixed and Statement, passes RBR
Submitted:	17 Aug 2007 14:33	Modified:	25 Sep 2008 10:01
Reporter:	Jonathan Miller	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S3 (Non-critical)
Version:		OS:	Linux
Assigned to:	Mats Kindahl	CPU Architecture:	Any

Description:
070817 17:25:07 [ERROR] Slave: Error 'Column count doesn't match value count at row 1' on query. Default database: 'test'. Query: 'INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ',
'Must make it bug free for the customer',
654321.4321,15.21,0,1965,"1905-11-14")', Error_code: 1136
070817 17:25:07 [Warning] Slave: Column count doesn't match value count at row 1 Error_code: 1136
070817 17:25:07 [Warning] Slave: Unknown error Error_code: 1105

Note: This test has no issues when using RBR

How to repeat:
connection slave;
STOP SLAVE;
RESET SLAVE;

eval CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc VARCHAR(255),
                 bc CHAR(255), d DECIMAL(10,4) DEFAULT 0,
                 f FLOAT DEFAULT 0, total BIGINT UNSIGNED)ENGINE=$engine_type;

connection master;

eval CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc VARCHAR(255),
                 bc CHAR(255), d DECIMAL(10,4) DEFAULT 0,
                 f FLOAT DEFAULT 0, total BIGINT UNSIGNED,
                 y YEAR, t DATE)ENGINE=$engine_type
                 PARTITION BY RANGE (YEAR(t))
                (PARTITION p0 VALUES LESS THAN (1901),
                 PARTITION p1 VALUES LESS THAN (1946),
                 PARTITION p2 VALUES LESS THAN (1966),
                 PARTITION p3 VALUES LESS THAN (1986),
                 PARTITION p4 VALUES LESS THAN (2005),
                 PARTITION p5 VALUES LESS THAN MAXVALUE);
RESET MASTER;

START SLAVE;

connection master;
--source include/rpl_multi_engine4.inc

Test files

Attachment: rpl_multi_engine4.inc (application/octet-stream, text), 2.15 KiB.

Test files

Attachment: rpl_extraColMasterPartition.test (application/octet-stream, text), 4.37 KiB.

Test files

Attachment: rpl_extraColMasterPart_innodb.test (application/octet-stream, text), 469 bytes.

Test files

Attachment: rpl_extraColMasterPart_innodb-master.opt (application/octet-stream, text), 9 bytes.

Test files

Attachment: rpl_extraColMasterPart_innodb-slave.opt (application/octet-stream, text), 9 bytes.

Still an issue.

This is a deliberate design in order to be able to upgrade schemata in circular replication topologies. This was implemented as WL#3915 for 5.1.