1 --echo **** Checking result of conversions ****
3 # Create a temporary table containing all conversions
4 # that didn't work as expected, the table should
5 # normally not contain any rows
6 CREATE TEMPORARY
TABLE failed_type_conversions ENGINE =
'MyISAM' AS
7 SELECT RPAD(Source, 15,
' ') AS Source_Type,
8 RPAD(
Target, 15, ' ') AS Target_Type,
9 RPAD(Flags, 25, ' ') AS All_Type_Conversion_Flags,
10 IF(Compare IS NULL AND Error IS NOT NULL, '<Correct error>',
11 IF(Compare, '<Correct value>',
12 CONCAT("'", On_Slave, "' != '", Expected, "'")))
15 WHERE Compare != 1 OR (Compare IS NULL AND Error IS NULL);
18 if (`SELECT COUNT(*) FROM failed_type_conversions`)
20 echo Some
type conversions failed, see below:;
21 SELECT * FROM failed_type_conversions;
22 die Type conversion failure;