File: //usr/share/mysql-test/suite/rpl/r/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