Edit File: rpl_typeconv.result
include/master-slave.inc [connection master] set @saved_slave_type_conversions = @@global.slave_type_conversions; CREATE TABLE type_conversions ( TestNo INT AUTO_INCREMENT PRIMARY KEY, Source TEXT, Target TEXT, Flags TEXT, On_Master TEXT, On_Slave TEXT, Expected TEXT, Compare INT, Error TEXT); SELECT @@global.slave_type_conversions; @@global.slave_type_conversions SET GLOBAL SLAVE_TYPE_CONVERSIONS=''; SELECT @@global.slave_type_conversions; @@global.slave_type_conversions SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY'; SELECT @@global.slave_type_conversions; @@global.slave_type_conversions ALL_NON_LOSSY SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY'; SELECT @@global.slave_type_conversions; @@global.slave_type_conversions ALL_LOSSY SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY'; SELECT @@global.slave_type_conversions; @@global.slave_type_conversions ALL_LOSSY,ALL_NON_LOSSY SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY,NONEXISTING_BIT'; ERROR 42000: Variable 'slave_type_conversions' can't be set to the value of 'NONEXISTING_BIT' SELECT @@global.slave_type_conversions; @@global.slave_type_conversions ALL_LOSSY,ALL_NON_LOSSY SET GLOBAL SLAVE_TYPE_CONVERSIONS=''; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = '' **** include/rpl_reset.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY' **** include/rpl_reset.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY' **** include/rpl_reset.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY,ALL_NON_LOSSY' **** include/rpl_reset.inc **** Result of conversions **** Source_Type Target_Type All_Type_Conversion_Flags Value_On_Slave TINYBLOB TINYBLOB <Correct value> TINYBLOB BLOB <Correct error> TINYBLOB MEDIUMBLOB <Correct error> TINYBLOB LONGBLOB <Correct error> BLOB TINYBLOB <Correct error> BLOB BLOB <Correct value> BLOB MEDIUMBLOB <Correct error> BLOB LONGBLOB <Correct error> MEDIUMBLOB TINYBLOB <Correct error> MEDIUMBLOB BLOB <Correct error> MEDIUMBLOB MEDIUMBLOB <Correct value> MEDIUMBLOB LONGBLOB <Correct error> LONGBLOB TINYBLOB <Correct error> LONGBLOB BLOB <Correct error> LONGBLOB MEDIUMBLOB <Correct error> LONGBLOB LONGBLOB <Correct value> GEOMETRY BLOB <Correct error> BLOB GEOMETRY <Correct error> GEOMETRY GEOMETRY <Correct value> BIT(1) BIT(1) <Correct value> DATE DATE <Correct value> ENUM('master',' ENUM('master',' <Correct value> CHAR(10) ENUM('master',' <Correct error> CHAR(10) SET('master','s <Correct error> ENUM('master',' CHAR(10) <Correct error> SET('master','s CHAR(10) <Correct error> SET('master','s SET('master','s <Correct value> SET('master','s SET('master','s <Correct value> SET('0','1','2' SET('0','1','2' <Correct value> SET('0','1','2' SET('0','1','2' <Correct error> SET('0','1','2' SET('0','1','2' <Correct error> SET('0','1','2' SET('0','1','2' <Correct error> TINYINT TINYINT <Correct value> TINYINT SMALLINT <Correct error> TINYINT MEDIUMINT <Correct error> TINYINT INT <Correct error> TINYINT BIGINT <Correct error> SMALLINT TINYINT <Correct error> SMALLINT TINYINT <Correct error> SMALLINT TINYINT UNSIGNE <Correct error> SMALLINT SMALLINT <Correct value> SMALLINT MEDIUMINT <Correct error> SMALLINT INT <Correct error> SMALLINT BIGINT <Correct error> MEDIUMINT TINYINT <Correct error> MEDIUMINT TINYINT <Correct error> MEDIUMINT TINYINT UNSIGNE <Correct error> MEDIUMINT SMALLINT <Correct error> MEDIUMINT MEDIUMINT <Correct value> MEDIUMINT INT <Correct error> MEDIUMINT BIGINT <Correct error> INT TINYINT <Correct error> INT TINYINT <Correct error> INT TINYINT UNSIGNE <Correct error> INT SMALLINT <Correct error> INT MEDIUMINT <Correct error> INT INT <Correct value> INT BIGINT <Correct error> BIGINT TINYINT <Correct error> BIGINT SMALLINT <Correct error> BIGINT MEDIUMINT <Correct error> BIGINT INT <Correct error> BIGINT BIGINT <Correct value> CHAR(20) CHAR(20) <Correct value> CHAR(20) CHAR(30) <Correct error> CHAR(20) CHAR(10) <Correct error> CHAR(20) VARCHAR(20) <Correct error> CHAR(20) VARCHAR(30) <Correct error> CHAR(20) VARCHAR(10) <Correct error> CHAR(20) TINYTEXT <Correct error> CHAR(20) TEXT <Correct error> CHAR(20) MEDIUMTEXT <Correct error> CHAR(20) LONGTEXT <Correct error> VARCHAR(20) VARCHAR(20) <Correct value> VARCHAR(20) VARCHAR(30) <Correct error> VARCHAR(20) VARCHAR(10) <Correct error> VARCHAR(20) CHAR(30) <Correct error> VARCHAR(20) CHAR(10) <Correct error> VARCHAR(20) TINYTEXT <Correct error> VARCHAR(20) TEXT <Correct error> VARCHAR(20) MEDIUMTEXT <Correct error> VARCHAR(20) LONGTEXT <Correct error> VARCHAR(500) VARCHAR(500) <Correct value> VARCHAR(500) VARCHAR(510) <Correct error> VARCHAR(500) VARCHAR(255) <Correct error> VARCHAR(500) TINYTEXT <Correct error> VARCHAR(500) TEXT <Correct error> VARCHAR(500) MEDIUMTEXT <Correct error> VARCHAR(500) LONGTEXT <Correct error> TINYTEXT VARCHAR(500) <Correct error> TEXT VARCHAR(500) <Correct error> MEDIUMTEXT VARCHAR(500) <Correct error> LONGTEXT VARCHAR(500) <Correct error> TINYTEXT CHAR(255) <Correct error> TINYTEXT CHAR(250) <Correct error> TEXT CHAR(255) <Correct error> MEDIUMTEXT CHAR(255) <Correct error> LONGTEXT CHAR(255) <Correct error> TINYTEXT TINYTEXT <Correct value> TINYTEXT TEXT <Correct error> TEXT TINYTEXT <Correct error> DECIMAL(10,5) DECIMAL(10,5) <Correct value> DECIMAL(10,5) DECIMAL(10,6) <Correct error> DECIMAL(10,5) DECIMAL(11,5) <Correct error> DECIMAL(10,5) DECIMAL(11,6) <Correct error> DECIMAL(10,5) DECIMAL(10,4) <Correct error> DECIMAL(10,5) DECIMAL(9,5) <Correct error> DECIMAL(10,5) DECIMAL(9,4) <Correct error> FLOAT DECIMAL(10,5) <Correct error> DOUBLE DECIMAL(10,5) <Correct error> DECIMAL(10,5) FLOAT <Correct error> DECIMAL(10,5) DOUBLE <Correct error> FLOAT FLOAT <Correct value> DOUBLE DOUBLE <Correct value> FLOAT DOUBLE <Correct error> DOUBLE FLOAT <Correct error> BIT(5) BIT(5) <Correct value> BIT(5) BIT(6) <Correct error> BIT(6) BIT(5) <Correct error> BIT(5) BIT(12) <Correct error> BIT(12) BIT(5) <Correct error> TINYBLOB TINYBLOB ALL_NON_LOSSY <Correct value> TINYBLOB BLOB ALL_NON_LOSSY <Correct value> TINYBLOB MEDIUMBLOB ALL_NON_LOSSY <Correct value> TINYBLOB LONGBLOB ALL_NON_LOSSY <Correct value> BLOB TINYBLOB ALL_NON_LOSSY <Correct error> BLOB BLOB ALL_NON_LOSSY <Correct value> BLOB MEDIUMBLOB ALL_NON_LOSSY <Correct value> BLOB LONGBLOB ALL_NON_LOSSY <Correct value> MEDIUMBLOB TINYBLOB ALL_NON_LOSSY <Correct error> MEDIUMBLOB BLOB ALL_NON_LOSSY <Correct error> MEDIUMBLOB MEDIUMBLOB ALL_NON_LOSSY <Correct value> MEDIUMBLOB LONGBLOB ALL_NON_LOSSY <Correct value> LONGBLOB TINYBLOB ALL_NON_LOSSY <Correct error> LONGBLOB BLOB ALL_NON_LOSSY <Correct error> LONGBLOB MEDIUMBLOB ALL_NON_LOSSY <Correct error> LONGBLOB LONGBLOB ALL_NON_LOSSY <Correct value> GEOMETRY BLOB ALL_NON_LOSSY <Correct error> BLOB GEOMETRY ALL_NON_LOSSY <Correct error> GEOMETRY GEOMETRY ALL_NON_LOSSY <Correct value> BIT(1) BIT(1) ALL_NON_LOSSY <Correct value> DATE DATE ALL_NON_LOSSY <Correct value> ENUM('master',' ENUM('master',' ALL_NON_LOSSY <Correct value> CHAR(10) ENUM('master',' ALL_NON_LOSSY <Correct error> CHAR(10) SET('master','s ALL_NON_LOSSY <Correct error> ENUM('master',' CHAR(10) ALL_NON_LOSSY <Correct error> SET('master','s CHAR(10) ALL_NON_LOSSY <Correct error> SET('master','s SET('master','s ALL_NON_LOSSY <Correct value> SET('master','s SET('master','s ALL_NON_LOSSY <Correct value> SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY <Correct value> SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY <Correct value> SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY <Correct error> SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY <Correct error> TINYINT TINYINT ALL_NON_LOSSY <Correct value> TINYINT SMALLINT ALL_NON_LOSSY <Correct value> TINYINT MEDIUMINT ALL_NON_LOSSY <Correct value> TINYINT INT ALL_NON_LOSSY <Correct value> TINYINT BIGINT ALL_NON_LOSSY <Correct value> SMALLINT TINYINT ALL_NON_LOSSY <Correct error> SMALLINT TINYINT ALL_NON_LOSSY <Correct error> SMALLINT TINYINT UNSIGNE ALL_NON_LOSSY <Correct error> SMALLINT SMALLINT ALL_NON_LOSSY <Correct value> SMALLINT MEDIUMINT ALL_NON_LOSSY <Correct value> SMALLINT INT ALL_NON_LOSSY <Correct value> SMALLINT BIGINT ALL_NON_LOSSY <Correct value> MEDIUMINT TINYINT ALL_NON_LOSSY <Correct error> MEDIUMINT TINYINT ALL_NON_LOSSY <Correct error> MEDIUMINT TINYINT UNSIGNE ALL_NON_LOSSY <Correct error> MEDIUMINT SMALLINT ALL_NON_LOSSY <Correct error> MEDIUMINT MEDIUMINT ALL_NON_LOSSY <Correct value> MEDIUMINT INT ALL_NON_LOSSY <Correct value> MEDIUMINT BIGINT ALL_NON_LOSSY <Correct value> INT TINYINT ALL_NON_LOSSY <Correct error> INT TINYINT ALL_NON_LOSSY <Correct error> INT TINYINT UNSIGNE ALL_NON_LOSSY <Correct error> INT SMALLINT ALL_NON_LOSSY <Correct error> INT MEDIUMINT ALL_NON_LOSSY <Correct error> INT INT ALL_NON_LOSSY <Correct value> INT BIGINT ALL_NON_LOSSY <Correct value> BIGINT TINYINT ALL_NON_LOSSY <Correct error> BIGINT SMALLINT ALL_NON_LOSSY <Correct error> BIGINT MEDIUMINT ALL_NON_LOSSY <Correct error> BIGINT INT ALL_NON_LOSSY <Correct error> BIGINT BIGINT ALL_NON_LOSSY <Correct value> CHAR(20) CHAR(20) ALL_NON_LOSSY <Correct value> CHAR(20) CHAR(30) ALL_NON_LOSSY <Correct value> CHAR(20) CHAR(10) ALL_NON_LOSSY <Correct error> CHAR(20) VARCHAR(20) ALL_NON_LOSSY <Correct value> CHAR(20) VARCHAR(30) ALL_NON_LOSSY <Correct value> CHAR(20) VARCHAR(10) ALL_NON_LOSSY <Correct error> CHAR(20) TINYTEXT ALL_NON_LOSSY <Correct value> CHAR(20) TEXT ALL_NON_LOSSY <Correct value> CHAR(20) MEDIUMTEXT ALL_NON_LOSSY <Correct value> CHAR(20) LONGTEXT ALL_NON_LOSSY <Correct value> VARCHAR(20) VARCHAR(20) ALL_NON_LOSSY <Correct value> VARCHAR(20) VARCHAR(30) ALL_NON_LOSSY <Correct value> VARCHAR(20) VARCHAR(10) ALL_NON_LOSSY <Correct error> VARCHAR(20) CHAR(30) ALL_NON_LOSSY <Correct value> VARCHAR(20) CHAR(10) ALL_NON_LOSSY <Correct error> VARCHAR(20) TINYTEXT ALL_NON_LOSSY <Correct value> VARCHAR(20) TEXT ALL_NON_LOSSY <Correct value> VARCHAR(20) MEDIUMTEXT ALL_NON_LOSSY <Correct value> VARCHAR(20) LONGTEXT ALL_NON_LOSSY <Correct value> VARCHAR(500) VARCHAR(500) ALL_NON_LOSSY <Correct value> VARCHAR(500) VARCHAR(510) ALL_NON_LOSSY <Correct value> VARCHAR(500) VARCHAR(255) ALL_NON_LOSSY <Correct error> VARCHAR(500) TINYTEXT ALL_NON_LOSSY <Correct error> VARCHAR(500) TEXT ALL_NON_LOSSY <Correct value> VARCHAR(500) MEDIUMTEXT ALL_NON_LOSSY <Correct value> VARCHAR(500) LONGTEXT ALL_NON_LOSSY <Correct value> TINYTEXT VARCHAR(500) ALL_NON_LOSSY <Correct value> TEXT VARCHAR(500) ALL_NON_LOSSY <Correct error> MEDIUMTEXT VARCHAR(500) ALL_NON_LOSSY <Correct error> LONGTEXT VARCHAR(500) ALL_NON_LOSSY <Correct error> TINYTEXT CHAR(255) ALL_NON_LOSSY <Correct value> TINYTEXT CHAR(250) ALL_NON_LOSSY <Correct error> TEXT CHAR(255) ALL_NON_LOSSY <Correct error> MEDIUMTEXT CHAR(255) ALL_NON_LOSSY <Correct error> LONGTEXT CHAR(255) ALL_NON_LOSSY <Correct error> TINYTEXT TINYTEXT ALL_NON_LOSSY <Correct value> TINYTEXT TEXT ALL_NON_LOSSY <Correct value> TEXT TINYTEXT ALL_NON_LOSSY <Correct error> DECIMAL(10,5) DECIMAL(10,5) ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(10,6) ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(11,5) ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(11,6) ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(10,4) ALL_NON_LOSSY <Correct error> DECIMAL(10,5) DECIMAL(9,5) ALL_NON_LOSSY <Correct error> DECIMAL(10,5) DECIMAL(9,4) ALL_NON_LOSSY <Correct error> FLOAT DECIMAL(10,5) ALL_NON_LOSSY <Correct error> DOUBLE DECIMAL(10,5) ALL_NON_LOSSY <Correct error> DECIMAL(10,5) FLOAT ALL_NON_LOSSY <Correct error> DECIMAL(10,5) DOUBLE ALL_NON_LOSSY <Correct error> FLOAT FLOAT ALL_NON_LOSSY <Correct value> DOUBLE DOUBLE ALL_NON_LOSSY <Correct value> FLOAT DOUBLE ALL_NON_LOSSY <Correct value> DOUBLE FLOAT ALL_NON_LOSSY <Correct error> BIT(5) BIT(5) ALL_NON_LOSSY <Correct value> BIT(5) BIT(6) ALL_NON_LOSSY <Correct value> BIT(6) BIT(5) ALL_NON_LOSSY <Correct error> BIT(5) BIT(12) ALL_NON_LOSSY <Correct value> BIT(12) BIT(5) ALL_NON_LOSSY <Correct error> TINYBLOB TINYBLOB ALL_LOSSY <Correct value> TINYBLOB BLOB ALL_LOSSY <Correct error> TINYBLOB MEDIUMBLOB ALL_LOSSY <Correct error> TINYBLOB LONGBLOB ALL_LOSSY <Correct error> BLOB TINYBLOB ALL_LOSSY <Correct value> BLOB BLOB ALL_LOSSY <Correct value> BLOB MEDIUMBLOB ALL_LOSSY <Correct error> BLOB LONGBLOB ALL_LOSSY <Correct error> MEDIUMBLOB TINYBLOB ALL_LOSSY <Correct value> MEDIUMBLOB BLOB ALL_LOSSY <Correct value> MEDIUMBLOB MEDIUMBLOB ALL_LOSSY <Correct value> MEDIUMBLOB LONGBLOB ALL_LOSSY <Correct error> LONGBLOB TINYBLOB ALL_LOSSY <Correct value> LONGBLOB BLOB ALL_LOSSY <Correct value> LONGBLOB MEDIUMBLOB ALL_LOSSY <Correct value> LONGBLOB LONGBLOB ALL_LOSSY <Correct value> GEOMETRY BLOB ALL_LOSSY <Correct error> BLOB GEOMETRY ALL_LOSSY <Correct error> GEOMETRY GEOMETRY ALL_LOSSY <Correct value> BIT(1) BIT(1) ALL_LOSSY <Correct value> DATE DATE ALL_LOSSY <Correct value> ENUM('master',' ENUM('master',' ALL_LOSSY <Correct value> CHAR(10) ENUM('master',' ALL_LOSSY <Correct error> CHAR(10) SET('master','s ALL_LOSSY <Correct error> ENUM('master',' CHAR(10) ALL_LOSSY <Correct error> SET('master','s CHAR(10) ALL_LOSSY <Correct error> SET('master','s SET('master','s ALL_LOSSY <Correct value> SET('master','s SET('master','s ALL_LOSSY <Correct value> SET('0','1','2' SET('0','1','2' ALL_LOSSY <Correct value> SET('0','1','2' SET('0','1','2' ALL_LOSSY <Correct error> SET('0','1','2' SET('0','1','2' ALL_LOSSY <Correct value> SET('0','1','2' SET('0','1','2' ALL_LOSSY <Correct value> TINYINT TINYINT ALL_LOSSY <Correct value> TINYINT SMALLINT ALL_LOSSY <Correct error> TINYINT MEDIUMINT ALL_LOSSY <Correct error> TINYINT INT ALL_LOSSY <Correct error> TINYINT BIGINT ALL_LOSSY <Correct error> SMALLINT TINYINT ALL_LOSSY <Correct value> SMALLINT TINYINT ALL_LOSSY <Correct value> SMALLINT TINYINT UNSIGNE ALL_LOSSY <Correct value> SMALLINT SMALLINT ALL_LOSSY <Correct value> SMALLINT MEDIUMINT ALL_LOSSY <Correct error> SMALLINT INT ALL_LOSSY <Correct error> SMALLINT BIGINT ALL_LOSSY <Correct error> MEDIUMINT TINYINT ALL_LOSSY <Correct value> MEDIUMINT TINYINT ALL_LOSSY <Correct value> MEDIUMINT TINYINT UNSIGNE ALL_LOSSY <Correct value> MEDIUMINT SMALLINT ALL_LOSSY <Correct value> MEDIUMINT MEDIUMINT ALL_LOSSY <Correct value> MEDIUMINT INT ALL_LOSSY <Correct error> MEDIUMINT BIGINT ALL_LOSSY <Correct error> INT TINYINT ALL_LOSSY <Correct value> INT TINYINT ALL_LOSSY <Correct value> INT TINYINT UNSIGNE ALL_LOSSY <Correct value> INT SMALLINT ALL_LOSSY <Correct value> INT MEDIUMINT ALL_LOSSY <Correct value> INT INT ALL_LOSSY <Correct value> INT BIGINT ALL_LOSSY <Correct error> BIGINT TINYINT ALL_LOSSY <Correct value> BIGINT SMALLINT ALL_LOSSY <Correct value> BIGINT MEDIUMINT ALL_LOSSY <Correct value> BIGINT INT ALL_LOSSY <Correct value> BIGINT BIGINT ALL_LOSSY <Correct value> CHAR(20) CHAR(20) ALL_LOSSY <Correct value> CHAR(20) CHAR(30) ALL_LOSSY <Correct error> CHAR(20) CHAR(10) ALL_LOSSY <Correct value> CHAR(20) VARCHAR(20) ALL_LOSSY <Correct error> CHAR(20) VARCHAR(30) ALL_LOSSY <Correct error> CHAR(20) VARCHAR(10) ALL_LOSSY <Correct value> CHAR(20) TINYTEXT ALL_LOSSY <Correct error> CHAR(20) TEXT ALL_LOSSY <Correct error> CHAR(20) MEDIUMTEXT ALL_LOSSY <Correct error> CHAR(20) LONGTEXT ALL_LOSSY <Correct error> VARCHAR(20) VARCHAR(20) ALL_LOSSY <Correct value> VARCHAR(20) VARCHAR(30) ALL_LOSSY <Correct error> VARCHAR(20) VARCHAR(10) ALL_LOSSY <Correct value> VARCHAR(20) CHAR(30) ALL_LOSSY <Correct error> VARCHAR(20) CHAR(10) ALL_LOSSY <Correct value> VARCHAR(20) TINYTEXT ALL_LOSSY <Correct error> VARCHAR(20) TEXT ALL_LOSSY <Correct error> VARCHAR(20) MEDIUMTEXT ALL_LOSSY <Correct error> VARCHAR(20) LONGTEXT ALL_LOSSY <Correct error> VARCHAR(500) VARCHAR(500) ALL_LOSSY <Correct value> VARCHAR(500) VARCHAR(510) ALL_LOSSY <Correct error> VARCHAR(500) VARCHAR(255) ALL_LOSSY <Correct value> VARCHAR(500) TINYTEXT ALL_LOSSY <Correct value> VARCHAR(500) TEXT ALL_LOSSY <Correct error> VARCHAR(500) MEDIUMTEXT ALL_LOSSY <Correct error> VARCHAR(500) LONGTEXT ALL_LOSSY <Correct error> TINYTEXT VARCHAR(500) ALL_LOSSY <Correct error> TEXT VARCHAR(500) ALL_LOSSY <Correct value> MEDIUMTEXT VARCHAR(500) ALL_LOSSY <Correct value> LONGTEXT VARCHAR(500) ALL_LOSSY <Correct value> TINYTEXT CHAR(255) ALL_LOSSY <Correct error> TINYTEXT CHAR(250) ALL_LOSSY <Correct value> TEXT CHAR(255) ALL_LOSSY <Correct value> MEDIUMTEXT CHAR(255) ALL_LOSSY <Correct value> LONGTEXT CHAR(255) ALL_LOSSY <Correct value> TINYTEXT TINYTEXT ALL_LOSSY <Correct value> TINYTEXT TEXT ALL_LOSSY <Correct error> TEXT TINYTEXT ALL_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(10,5) ALL_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(10,6) ALL_LOSSY <Correct error> DECIMAL(10,5) DECIMAL(11,5) ALL_LOSSY <Correct error> DECIMAL(10,5) DECIMAL(11,6) ALL_LOSSY <Correct error> DECIMAL(10,5) DECIMAL(10,4) ALL_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(9,5) ALL_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(9,4) ALL_LOSSY <Correct value> FLOAT DECIMAL(10,5) ALL_LOSSY <Correct value> DOUBLE DECIMAL(10,5) ALL_LOSSY <Correct value> DECIMAL(10,5) FLOAT ALL_LOSSY <Correct value> DECIMAL(10,5) DOUBLE ALL_LOSSY <Correct value> FLOAT FLOAT ALL_LOSSY <Correct value> DOUBLE DOUBLE ALL_LOSSY <Correct value> FLOAT DOUBLE ALL_LOSSY <Correct error> DOUBLE FLOAT ALL_LOSSY <Correct value> BIT(5) BIT(5) ALL_LOSSY <Correct value> BIT(5) BIT(6) ALL_LOSSY <Correct error> BIT(6) BIT(5) ALL_LOSSY <Correct value> BIT(5) BIT(12) ALL_LOSSY <Correct error> BIT(12) BIT(5) ALL_LOSSY <Correct value> TINYBLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYBLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYBLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYBLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> BLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> BLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> BLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> BLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMBLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMBLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMBLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMBLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> LONGBLOB TINYBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> LONGBLOB BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> LONGBLOB MEDIUMBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> LONGBLOB LONGBLOB ALL_LOSSY,ALL_NON_LOSSY <Correct value> GEOMETRY BLOB ALL_LOSSY,ALL_NON_LOSSY <Correct error> BLOB GEOMETRY ALL_LOSSY,ALL_NON_LOSSY <Correct error> GEOMETRY GEOMETRY ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIT(1) BIT(1) ALL_LOSSY,ALL_NON_LOSSY <Correct value> DATE DATE ALL_LOSSY,ALL_NON_LOSSY <Correct value> ENUM('master',' ENUM('master',' ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(10) ENUM('master',' ALL_LOSSY,ALL_NON_LOSSY <Correct error> CHAR(10) SET('master','s ALL_LOSSY,ALL_NON_LOSSY <Correct error> ENUM('master',' CHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct error> SET('master','s CHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct error> SET('master','s SET('master','s ALL_LOSSY,ALL_NON_LOSSY <Correct value> SET('master','s SET('master','s ALL_LOSSY,ALL_NON_LOSSY <Correct value> SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY <Correct value> SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY <Correct value> SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY <Correct value> SET('0','1','2' SET('0','1','2' ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYINT INT ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYINT BIGINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> SMALLINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> SMALLINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> SMALLINT TINYINT UNSIGNE ALL_LOSSY,ALL_NON_LOSSY <Correct value> SMALLINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> SMALLINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> SMALLINT INT ALL_LOSSY,ALL_NON_LOSSY <Correct value> SMALLINT BIGINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMINT TINYINT UNSIGNE ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMINT INT ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMINT BIGINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> INT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> INT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> INT TINYINT UNSIGNE ALL_LOSSY,ALL_NON_LOSSY <Correct value> INT SMALLINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> INT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> INT INT ALL_LOSSY,ALL_NON_LOSSY <Correct value> INT BIGINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIGINT TINYINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIGINT SMALLINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIGINT MEDIUMINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIGINT INT ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIGINT BIGINT ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(20) CHAR(20) ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(20) CHAR(30) ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(20) CHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(20) VARCHAR(20) ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(20) VARCHAR(30) ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(20) VARCHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(20) TINYTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(20) TEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(20) MEDIUMTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> CHAR(20) LONGTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(20) VARCHAR(20) ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(20) VARCHAR(30) ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(20) VARCHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(20) CHAR(30) ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(20) CHAR(10) ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(20) TINYTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(20) TEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(20) MEDIUMTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(20) LONGTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(500) VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(500) VARCHAR(510) ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(500) VARCHAR(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(500) TINYTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(500) TEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(500) MEDIUMTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> VARCHAR(500) LONGTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYTEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY <Correct value> TEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMTEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY <Correct value> LONGTEXT VARCHAR(500) ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYTEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYTEXT CHAR(250) ALL_LOSSY,ALL_NON_LOSSY <Correct value> TEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value> MEDIUMTEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value> LONGTEXT CHAR(255) ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYTEXT TINYTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> TINYTEXT TEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> TEXT TINYTEXT ALL_LOSSY,ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(10,5) ALL_LOSSY,ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(10,6) ALL_LOSSY,ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(11,5) ALL_LOSSY,ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(11,6) ALL_LOSSY,ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(10,4) ALL_LOSSY,ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(9,5) ALL_LOSSY,ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DECIMAL(9,4) ALL_LOSSY,ALL_NON_LOSSY <Correct value> FLOAT DECIMAL(10,5) ALL_LOSSY,ALL_NON_LOSSY <Correct value> DOUBLE DECIMAL(10,5) ALL_LOSSY,ALL_NON_LOSSY <Correct value> DECIMAL(10,5) FLOAT ALL_LOSSY,ALL_NON_LOSSY <Correct value> DECIMAL(10,5) DOUBLE ALL_LOSSY,ALL_NON_LOSSY <Correct value> FLOAT FLOAT ALL_LOSSY,ALL_NON_LOSSY <Correct value> DOUBLE DOUBLE ALL_LOSSY,ALL_NON_LOSSY <Correct value> FLOAT DOUBLE ALL_LOSSY,ALL_NON_LOSSY <Correct value> DOUBLE FLOAT ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIT(5) BIT(5) ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIT(5) BIT(6) ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIT(6) BIT(5) ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIT(5) BIT(12) ALL_LOSSY,ALL_NON_LOSSY <Correct value> BIT(12) BIT(5) ALL_LOSSY,ALL_NON_LOSSY <Correct value> DROP TABLE type_conversions; call mtr.add_suppression("Slave SQL.*Column 1 of table .test.t1. cannot be converted from type.* Error_code: 1677"); DROP TABLE t1; set global slave_type_conversions = @saved_slave_type_conversions; include/rpl_end.inc
Back to File Manager