include/master-slave.inc
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[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");
call mtr.add_suppression("The slave coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
DROP TABLE t1;
include/sync_slave_sql_with_master.inc
set global slave_type_conversions = @saved_slave_type_conversions;
include/rpl_end.inc
