1set @saved_slave_type_conversions = @@global.slave_type_conversions; 2SELECT @@global.slave_type_conversions; 3@@global.slave_type_conversions 4 5SET GLOBAL SLAVE_TYPE_CONVERSIONS=''; 6SELECT @@global.slave_type_conversions; 7@@global.slave_type_conversions 8 9SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY'; 10SELECT @@global.slave_type_conversions; 11@@global.slave_type_conversions 12ALL_NON_LOSSY 13SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY'; 14SELECT @@global.slave_type_conversions; 15@@global.slave_type_conversions 16ALL_LOSSY 17SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY'; 18SELECT @@global.slave_type_conversions; 19@@global.slave_type_conversions 20ALL_LOSSY,ALL_NON_LOSSY 21SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY,NONEXISTING_BIT'; 22ERROR 42000: Variable 'slave_type_conversions' can't be set to the value of 'NONEXISTING_BIT' 23SELECT @@global.slave_type_conversions; 24@@global.slave_type_conversions 25ALL_LOSSY,ALL_NON_LOSSY 26set global slave_type_conversions = @saved_slave_type_conversions; 27