include/master-slave.inc [connection master] connection slave; 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 LONGTEXT, On_Slave LONGTEXT, Expected LONGTEXT, 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 connection slave; SET GLOBAL SLAVE_TYPE_CONVERSIONS=''; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = '' **** # # MDEV-15821 Row format replication from LONGBLOB COMPRESSED to LONGBLOB does not work # # End of MDEV-15821 # # MDEV-15833 Row format replication between LONGBLOB and MEDIUMBLOB does not work for long values # # End of MDEV-15833 # # MDEV-17098 DATE <-> DATETIME # # End of MDEV-17098 include/rpl_reset.inc connection slave; SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY' **** # # MDEV-15821 Row format replication from LONGBLOB COMPRESSED to LONGBLOB does not work # # End of MDEV-15821 # # MDEV-15833 Row format replication between LONGBLOB and MEDIUMBLOB does not work for long values # # End of MDEV-15833 # # MDEV-17098 DATE <-> DATETIME # # End of MDEV-17098 include/rpl_reset.inc connection slave; SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY' **** # # MDEV-15821 Row format replication from LONGBLOB COMPRESSED to LONGBLOB does not work # # End of MDEV-15821 # # MDEV-15833 Row format replication between LONGBLOB and MEDIUMBLOB does not work for long values # # End of MDEV-15833 # # MDEV-17098 DATE <-> DATETIME # # End of MDEV-17098 include/rpl_reset.inc connection slave; SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY,ALL_NON_LOSSY' **** # # MDEV-15821 Row format replication from LONGBLOB COMPRESSED to LONGBLOB does not work # # End of MDEV-15821 # # MDEV-15833 Row format replication between LONGBLOB and MEDIUMBLOB does not work for long values # # End of MDEV-15833 # # MDEV-17098 DATE <-> DATETIME # # End of MDEV-17098 include/rpl_reset.inc connection slave; **** Result of conversions **** Source_Type Target_Type All_Type_Conversion_Flags Value_On_Slave TINYBLOB TINYBLOB TINYBLOB BLOB TINYBLOB MEDIUMBLOB TINYBLOB LONGBLOB BLOB TINYBLOB BLOB BLOB BLOB MEDIUMBLOB BLOB LONGBLOB MEDIUMBLOB TINYBLOB MEDIUMBLOB BLOB MEDIUMBLOB MEDIUMBLOB MEDIUMBLOB LONGBLOB LONGBLOB TINYBLOB LONGBLOB BLOB LONGBLOB MEDIUMBLOB LONGBLOB LONGBLOB GEOMETRY BLOB BLOB GEOMETRY GEOMETRY GEOMETRY BIT(1) BIT(1) DATE DATE ENUM('master',' ENUM('master',' CHAR(10) ENUM('master',' CHAR(10) SET('master','s ENUM('master',' CHAR(10) SET('master','s CHAR(10) SET('master','s SET('master','s SET('master','s SET('master','s SET('0','1','2' SET('0','1','2' SET('0','1','2' SET('0','1','2' SET('0','1','2' SET('0','1','2' SET('0','1','2' SET('0','1','2' TINYINT TINYINT TINYINT SMALLINT TINYINT MEDIUMINT TINYINT INT TINYINT BIGINT SMALLINT TINYINT SMALLINT TINYINT SMALLINT TINYINT UNSIGNE SMALLINT SMALLINT SMALLINT MEDIUMINT SMALLINT INT SMALLINT BIGINT MEDIUMINT TINYINT MEDIUMINT TINYINT MEDIUMINT TINYINT UNSIGNE MEDIUMINT SMALLINT MEDIUMINT MEDIUMINT MEDIUMINT INT MEDIUMINT BIGINT INT TINYINT INT TINYINT INT TINYINT UNSIGNE INT SMALLINT INT MEDIUMINT INT INT INT BIGINT BIGINT TINYINT BIGINT SMALLINT BIGINT MEDIUMINT BIGINT INT BIGINT BIGINT CHAR(20) CHAR(20) CHAR(20) CHAR(30) CHAR(20) CHAR(10) CHAR(20) VARCHAR(20) CHAR(20) VARCHAR(30) CHAR(20) VARCHAR(10) CHAR(20) TINYTEXT CHAR(20) TEXT CHAR(20) MEDIUMTEXT CHAR(20) LONGTEXT VARCHAR(20) VARCHAR(20) VARCHAR(20) VARCHAR(30) VARCHAR(20) VARCHAR(10) VARCHAR(20) CHAR(30) VARCHAR(20) CHAR(10) VARCHAR(20) TINYTEXT VARCHAR(20) TEXT VARCHAR(20) MEDIUMTEXT VARCHAR(20) LONGTEXT VARCHAR(500) VARCHAR(500) VARCHAR(500) VARCHAR(510) VARCHAR(500) VARCHAR(255) VARCHAR(500) TINYTEXT VARCHAR(500) TEXT VARCHAR(500) MEDIUMTEXT VARCHAR(500) LONGTEXT TINYTEXT VARCHAR(500) TEXT VARCHAR(500) MEDIUMTEXT VARCHAR(500) LONGTEXT VARCHAR(500) TINYTEXT CHAR(255) TINYTEXT CHAR(250) TEXT CHAR(255) MEDIUMTEXT CHAR(255) LONGTEXT CHAR(255) TINYTEXT TINYTEXT TINYTEXT TEXT TEXT TINYTEXT DECIMAL(10,5) DECIMAL(10,5) DECIMAL(10,5) DECIMAL(10,6) DECIMAL(10,5) DECIMAL(11,5) DECIMAL(10,5) DECIMAL(11,6) DECIMAL(10,5) DECIMAL(10,4) DECIMAL(10,5) DECIMAL(9,5) DECIMAL(10,5) DECIMAL(9,4) FLOAT DECIMAL(10,5) DOUBLE DECIMAL(10,5) DECIMAL(10,5) FLOAT DECIMAL(10,5) DOUBLE FLOAT FLOAT DOUBLE DOUBLE FLOAT DOUBLE DOUBLE FLOAT BIT(5) BIT(5) BIT(5) BIT(6) BIT(6) BIT(5) BIT(5) BIT(12) BIT(12) BIT(5) TINYBLOB COMPRE TINYBLOB TINYBLOB COMPRE BLOB TINYBLOB COMPRE MEDIUMBLOB TINYBLOB COMPRE LONGBLOB TINYBLOB COMPRE VARBINARY(255) BLOB COMPRESSED TINYBLOB BLOB COMPRESSED BLOB BLOB COMPRESSED MEDIUMBLOB BLOB COMPRESSED LONGBLOB BLOB COMPRESSED VARBINARY(65500 MEDIUMBLOB COMP TINYBLOB MEDIUMBLOB COMP BLOB MEDIUMBLOB COMP MEDIUMBLOB MEDIUMBLOB COMP LONGBLOB MEDIUMBLOB COMP VARBINARY(65500 LONGBLOB COMPRE TINYBLOB LONGBLOB COMPRE BLOB LONGBLOB COMPRE MEDIUMBLOB LONGBLOB COMPRE LONGBLOB LONGBLOB COMPRE VARBINARY(65500 TINYBLOB BLOB TINYBLOB MEDIUMBLOB TINYBLOB LONGBLOB TINYBLOB VARBINARY(255) BLOB TINYBLOB BLOB MEDIUMBLOB BLOB LONGBLOB BLOB VARBINARY(65500 MEDIUMBLOB TINYBLOB MEDIUMBLOB BLOB MEDIUMBLOB LONGBLOB MEDIUMBLOB VARBINARY(65500 LONGBLOB TINYBLOB LONGBLOB BLOB LONGBLOB MEDIUMBLOB LONGBLOB VARBINARY(65500 DATE DATETIME(6) DATE DATETIME(6) DATE DATETIME(6) DATE DATETIME(0) DATETIME(6) DATE DATETIME(6) DATE DATETIME(0) DATE TINYBLOB TINYBLOB ALL_NON_LOSSY TINYBLOB BLOB ALL_NON_LOSSY TINYBLOB MEDIUMBLOB ALL_NON_LOSSY TINYBLOB LONGBLOB ALL_NON_LOSSY BLOB TINYBLOB ALL_NON_LOSSY BLOB BLOB ALL_NON_LOSSY BLOB MEDIUMBLOB ALL_NON_LOSSY BLOB LONGBLOB ALL_NON_LOSSY MEDIUMBLOB TINYBLOB ALL_NON_LOSSY MEDIUMBLOB BLOB ALL_NON_LOSSY MEDIUMBLOB MEDIUMBLOB ALL_NON_LOSSY MEDIUMBLOB LONGBLOB ALL_NON_LOSSY LONGBLOB TINYBLOB ALL_NON_LOSSY LONGBLOB BLOB ALL_NON_LOSSY LONGBLOB MEDIUMBLOB ALL_NON_LOSSY LONGBLOB LONGBLOB ALL_NON_LOSSY GEOMETRY BLOB ALL_NON_LOSSY BLOB GEOMETRY ALL_NON_LOSSY GEOMETRY GEOMETRY ALL_NON_LOSSY BIT(1) BIT(1) ALL_NON_LOSSY DATE DATE ALL_NON_LOSSY ENUM('master',' ENUM('master',' ALL_NON_LOSSY CHAR(10) ENUM('master',' ALL_NON_LOSSY CHAR(10) SET('master','s ALL_NON_LOSSY ENUM('master',' CHAR(10) ALL_NON_LOSSY SET('master','s CHAR(10) ALL_NON_LOSSY SET('master','s SET('master','s ALL_NON_LOSSY SET('master','s SET('master','s ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY SET('0','1','2' SET('0','1','2' ALL_NON_LOSSY TINYINT TINYINT ALL_NON_LOSSY TINYINT SMALLINT ALL_NON_LOSSY TINYINT MEDIUMINT ALL_NON_LOSSY TINYINT INT ALL_NON_LOSSY TINYINT BIGINT ALL_NON_LOSSY SMALLINT TINYINT ALL_NON_LOSSY SMALLINT TINYINT ALL_NON_LOSSY SMALLINT TINYINT UNSIGNE ALL_NON_LOSSY SMALLINT SMALLINT ALL_NON_LOSSY SMALLINT MEDIUMINT ALL_NON_LOSSY SMALLINT INT ALL_NON_LOSSY SMALLINT BIGINT ALL_NON_LOSSY MEDIUMINT TINYINT ALL_NON_LOSSY MEDIUMINT TINYINT ALL_NON_LOSSY MEDIUMINT TINYINT UNSIGNE ALL_NON_LOSSY MEDIUMINT SMALLINT ALL_NON_LOSSY MEDIUMINT MEDIUMINT ALL_NON_LOSSY MEDIUMINT INT ALL_NON_LOSSY MEDIUMINT BIGINT ALL_NON_LOSSY INT TINYINT ALL_NON_LOSSY INT TINYINT ALL_NON_LOSSY INT TINYINT UNSIGNE ALL_NON_LOSSY INT SMALLINT ALL_NON_LOSSY INT MEDIUMINT ALL_NON_LOSSY INT INT ALL_NON_LOSSY INT BIGINT ALL_NON_LOSSY BIGINT TINYINT ALL_NON_LOSSY BIGINT SMALLINT ALL_NON_LOSSY BIGINT MEDIUMINT ALL_NON_LOSSY BIGINT INT ALL_NON_LOSSY BIGINT BIGINT ALL_NON_LOSSY CHAR(20) CHAR(20) ALL_NON_LOSSY CHAR(20) CHAR(30) ALL_NON_LOSSY CHAR(20) CHAR(10) ALL_NON_LOSSY CHAR(20) VARCHAR(20) ALL_NON_LOSSY CHAR(20) VARCHAR(30) ALL_NON_LOSSY CHAR(20) VARCHAR(10) ALL_NON_LOSSY CHAR(20) TINYTEXT ALL_NON_LOSSY CHAR(20) TEXT ALL_NON_LOSSY CHAR(20) MEDIUMTEXT ALL_NON_LOSSY CHAR(20) LONGTEXT ALL_NON_LOSSY VARCHAR(20) VARCHAR(20) ALL_NON_LOSSY VARCHAR(20) VARCHAR(30) ALL_NON_LOSSY VARCHAR(20) VARCHAR(10) ALL_NON_LOSSY VARCHAR(20) CHAR(30) ALL_NON_LOSSY VARCHAR(20) CHAR(10) ALL_NON_LOSSY VARCHAR(20) TINYTEXT ALL_NON_LOSSY VARCHAR(20) TEXT ALL_NON_LOSSY VARCHAR(20) MEDIUMTEXT ALL_NON_LOSSY VARCHAR(20) LONGTEXT ALL_NON_LOSSY VARCHAR(500) VARCHAR(500) ALL_NON_LOSSY VARCHAR(500) VARCHAR(510) ALL_NON_LOSSY VARCHAR(500) VARCHAR(255) ALL_NON_LOSSY VARCHAR(500) TINYTEXT ALL_NON_LOSSY VARCHAR(500) TEXT ALL_NON_LOSSY VARCHAR(500) MEDIUMTEXT ALL_NON_LOSSY VARCHAR(500) LONGTEXT ALL_NON_LOSSY TINYTEXT VARCHAR(500) ALL_NON_LOSSY TEXT VARCHAR(500) ALL_NON_LOSSY MEDIUMTEXT VARCHAR(500) ALL_NON_LOSSY LONGTEXT VARCHAR(500) ALL_NON_LOSSY TINYTEXT CHAR(255) ALL_NON_LOSSY TINYTEXT CHAR(250) ALL_NON_LOSSY TEXT CHAR(255) ALL_NON_LOSSY MEDIUMTEXT CHAR(255) ALL_NON_LOSSY LONGTEXT CHAR(255) ALL_NON_LOSSY TINYTEXT TINYTEXT ALL_NON_LOSSY TINYTEXT TEXT ALL_NON_LOSSY TEXT TINYTEXT ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(10,5) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(10,6) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(11,5) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(11,6) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(10,4) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(9,5) ALL_NON_LOSSY DECIMAL(10,5) DECIMAL(9,4) ALL_NON_LOSSY FLOAT DECIMAL(10,5) ALL_NON_LOSSY DOUBLE DECIMAL(10,5) ALL_NON_LOSSY DECIMAL(10,5) FLOAT ALL_NON_LOSSY DECIMAL(10,5) DOUBLE ALL_NON_LOSSY FLOAT FLOAT ALL_NON_LOSSY DOUBLE DOUBLE ALL_NON_LOSSY FLOAT DOUBLE ALL_NON_LOSSY DOUBLE FLOAT ALL_NON_LOSSY BIT(5) BIT(5) ALL_NON_LOSSY BIT(5) BIT(6) ALL_NON_LOSSY BIT(6) BIT(5) ALL_NON_LOSSY BIT(5) BIT(12) ALL_NON_LOSSY BIT(12) BIT(5) ALL_NON_LOSSY TINYBLOB COMPRE TINYBLOB ALL_NON_LOSSY TINYBLOB COMPRE BLOB ALL_NON_LOSSY TINYBLOB COMPRE MEDIUMBLOB ALL_NON_LOSSY TINYBLOB COMPRE LONGBLOB ALL_NON_LOSSY TINYBLOB COMPRE VARBINARY(255) ALL_NON_LOSSY BLOB COMPRESSED TINYBLOB ALL_NON_LOSSY BLOB COMPRESSED BLOB ALL_NON_LOSSY BLOB COMPRESSED MEDIUMBLOB ALL_NON_LOSSY BLOB COMPRESSED LONGBLOB ALL_NON_LOSSY BLOB COMPRESSED VARBINARY(65500 ALL_NON_LOSSY MEDIUMBLOB COMP TINYBLOB ALL_NON_LOSSY MEDIUMBLOB COMP BLOB ALL_NON_LOSSY MEDIUMBLOB COMP MEDIUMBLOB ALL_NON_LOSSY MEDIUMBLOB COMP LONGBLOB ALL_NON_LOSSY MEDIUMBLOB COMP VARBINARY(65500 ALL_NON_LOSSY LONGBLOB COMPRE TINYBLOB ALL_NON_LOSSY LONGBLOB COMPRE BLOB ALL_NON_LOSSY LONGBLOB COMPRE MEDIUMBLOB ALL_NON_LOSSY LONGBLOB COMPRE LONGBLOB ALL_NON_LOSSY LONGBLOB COMPRE VARBINARY(65500 ALL_NON_LOSSY TINYBLOB BLOB ALL_NON_LOSSY TINYBLOB MEDIUMBLOB ALL_NON_LOSSY TINYBLOB LONGBLOB ALL_NON_LOSSY TINYBLOB VARBINARY(255) ALL_NON_LOSSY BLOB TINYBLOB ALL_NON_LOSSY BLOB MEDIUMBLOB ALL_NON_LOSSY BLOB LONGBLOB ALL_NON_LOSSY BLOB VARBINARY(65500 ALL_NON_LOSSY MEDIUMBLOB TINYBLOB ALL_NON_LOSSY MEDIUMBLOB BLOB ALL_NON_LOSSY MEDIUMBLOB LONGBLOB ALL_NON_LOSSY MEDIUMBLOB VARBINARY(65500 ALL_NON_LOSSY LONGBLOB TINYBLOB ALL_NON_LOSSY LONGBLOB BLOB ALL_NON_LOSSY LONGBLOB MEDIUMBLOB ALL_NON_LOSSY LONGBLOB VARBINARY(65500 ALL_NON_LOSSY DATE DATETIME(6) ALL_NON_LOSSY DATE DATETIME(6) ALL_NON_LOSSY DATE DATETIME(6) ALL_NON_LOSSY DATE DATETIME(0) ALL_NON_LOSSY DATETIME(6) DATE ALL_NON_LOSSY DATETIME(6) DATE ALL_NON_LOSSY DATETIME(0) DATE ALL_NON_LOSSY TINYBLOB TINYBLOB ALL_LOSSY TINYBLOB BLOB ALL_LOSSY TINYBLOB MEDIUMBLOB ALL_LOSSY TINYBLOB LONGBLOB ALL_LOSSY BLOB TINYBLOB ALL_LOSSY BLOB BLOB ALL_LOSSY BLOB MEDIUMBLOB ALL_LOSSY BLOB LONGBLOB ALL_LOSSY MEDIUMBLOB TINYBLOB ALL_LOSSY MEDIUMBLOB BLOB ALL_LOSSY MEDIUMBLOB MEDIUMBLOB ALL_LOSSY MEDIUMBLOB LONGBLOB ALL_LOSSY LONGBLOB TINYBLOB ALL_LOSSY LONGBLOB BLOB ALL_LOSSY LONGBLOB MEDIUMBLOB ALL_LOSSY LONGBLOB LONGBLOB ALL_LOSSY GEOMETRY BLOB ALL_LOSSY BLOB GEOMETRY ALL_LOSSY GEOMETRY GEOMETRY ALL_LOSSY BIT(1) BIT(1) ALL_LOSSY DATE DATE ALL_LOSSY ENUM('master',' ENUM('master',' ALL_LOSSY CHAR(10) ENUM('master',' ALL_LOSSY CHAR(10) SET('master','s ALL_LOSSY ENUM('master',' CHAR(10) ALL_LOSSY SET('master','s CHAR(10) ALL_LOSSY SET('master','s SET('master','s ALL_LOSSY SET('master','s SET('master','s ALL_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY SET('0','1','2' SET('0','1','2' ALL_LOSSY TINYINT TINYINT ALL_LOSSY TINYINT SMALLINT ALL_LOSSY TINYINT MEDIUMINT ALL_LOSSY TINYINT INT ALL_LOSSY TINYINT BIGINT ALL_LOSSY SMALLINT TINYINT ALL_LOSSY SMALLINT TINYINT ALL_LOSSY SMALLINT TINYINT UNSIGNE ALL_LOSSY SMALLINT SMALLINT ALL_LOSSY SMALLINT MEDIUMINT ALL_LOSSY SMALLINT INT ALL_LOSSY SMALLINT BIGINT ALL_LOSSY MEDIUMINT TINYINT ALL_LOSSY MEDIUMINT TINYINT ALL_LOSSY MEDIUMINT TINYINT UNSIGNE ALL_LOSSY MEDIUMINT SMALLINT ALL_LOSSY MEDIUMINT MEDIUMINT ALL_LOSSY MEDIUMINT INT ALL_LOSSY MEDIUMINT BIGINT ALL_LOSSY INT TINYINT ALL_LOSSY INT TINYINT ALL_LOSSY INT TINYINT UNSIGNE ALL_LOSSY INT SMALLINT ALL_LOSSY INT MEDIUMINT ALL_LOSSY INT INT ALL_LOSSY INT BIGINT ALL_LOSSY BIGINT TINYINT ALL_LOSSY BIGINT SMALLINT ALL_LOSSY BIGINT MEDIUMINT ALL_LOSSY BIGINT INT ALL_LOSSY BIGINT BIGINT ALL_LOSSY CHAR(20) CHAR(20) ALL_LOSSY CHAR(20) CHAR(30) ALL_LOSSY CHAR(20) CHAR(10) ALL_LOSSY CHAR(20) VARCHAR(20) ALL_LOSSY CHAR(20) VARCHAR(30) ALL_LOSSY CHAR(20) VARCHAR(10) ALL_LOSSY CHAR(20) TINYTEXT ALL_LOSSY CHAR(20) TEXT ALL_LOSSY CHAR(20) MEDIUMTEXT ALL_LOSSY CHAR(20) LONGTEXT ALL_LOSSY