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;