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