Hi. I agree this is not a bug per se but the message is confusing as presented, but again triggered by an upstream problem.
That said I´d like to see this shown differently to make it much clearer what the problem is and where it comes from.
So I´d suggest the following:
(1) make this report the different error messages on different lines, this makes the huge “blob of an error message” easier to read.
(2) if you don’t know the text on the master say so more clearly: showing printf formatting is just silly.
An example below (reformatted) but with the SQL munged somewhat to protect the innocent looks much easier to understand:
140917 21:30:04 [ERROR] Slave SQL: Query caused different errors on master and slave.
140917 21:30:04 [ERROR] => Error on master[error code=1813]: 'Tablespace for table '<VALUE_FROM_MASTER_UNKNOWN>' exists. Please DISCARD the tablespace before IMPORT.'
140917 21:30:04 [ERROR] => Error on slave[error code=0] (no error)
140917 21:30:04 [ERROR] => Default database: 'xxxxxx'. Query: 'CREATE TABLE `xxxxxxx_YYYYMMDD` (
`xxxxxxxxx_id` mediumint(8) unsigned NOT NULL,
`xxxxx_id` int(11) NOT NULL DEFAULT '0',
`xxxxx` varchar(255) DEFAULT NULL,
`xxxxxxxxx_id` smallint(5) unsigned DEFAULT NULL,
`xxxx_id` int(11) DEFAULT NULL,
`xxxxxxxx` int(10) unsigned DEFAULT NULL,
`xxxxxxxxxxxxxxxx` int(10) unsigned DEFAULT NULL,
`xxxxxxxxxxx` int(10) unsigned DEFAULT NULL,
`xxxxxxxxxx` mediumint(8) unsigned DEFAULT NULL,
`xxxxxxxxxxxxxxxxxxxxxx` decimal(10,2) DEFAULT NULL,
`xxxxxxxx` decimal(10,2) DEFAULT NULL,
`xxx` decimal(12,4) NOT NULL DEFAULT '0.0000',
`xxxxxxxxx` double NOT NULL DEFAULT '1',
`xxxxxxxxxx
...
Replace any format values with something like VALUE_FROM_MASTER_UNKNOWN.
Trying to merge an error of this type into a single long line just gives me a headache.
It was an intentional change in MySQL, the key word here is "(format)".
See http://bugs.mysql.com/bug.php?id=46697: