slave_type_conversions_error_on_truncate

This feature provides an extended version of wl5151. For ALL_LOSSY conversion mode you can specify behavior on truncate value - error (new behavior) or work normally (old behavior). Also, it provides a system variable to control that.

If you specify

set global slave_type_conversions_error_on_truncate=ON;
set global slave_type_conversions=ALL_LOSSY;

and then try to replicate value with truncate data you will get an error. For example: you have a column 'a' with type SMALLINT on master, and you have a column 'a' with type TINYINT on slave. When you run on master: INSERT INTO t VALUES(128); Slave will fail with Last_error:

Slave SQL: Column 0 of table 'test.t' cannot be converted from type 'smallint' to type 'tinyint(4)' without truncate
Error_code: 1643

This error would be wrote to mysqld-error log, and also available:

SHOW SLAVE STATUS;

• Replication of Columns Having Different Data Types
• Feature wl5151