Bug #81527 wrong result

• Submitted: 20 May 2016 20:09
• Modified: 20 May 2016 21:15
• Reporter: Tomislav Hampl
• Status: Closed
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.7.12
• OS: Any
• CPU Architecture: Any

[20 May 2016 20:09] Tomislav Hampl

Description:
try exec this SQL

DROP TEMPORARY TABLE IF EXISTS tmpMain2;
CREATE TEMPORARY TABLE IF NOT EXISTS tmpMain2 AS (
	SELECT net_return
	FROM (
		SELECT -7037963.173961635 AS net_return	
	) AS af2
);
SELECT net_return FROM tmpMain2;
SELECT CAST(net_return AS DECIMAL(18,12)) FROM tmpMain2;

->there are results 
#-7037963.173961635 
#-999999.999999999999

How to repeat:
DROP TEMPORARY TABLE IF EXISTS tmpMain2;
CREATE TEMPORARY TABLE IF NOT EXISTS tmpMain2 AS (
	SELECT net_return
	FROM (
		SELECT -7037963.173961635 AS net_return	
	) AS af2
);
SELECT net_return FROM tmpMain2;
SELECT CAST(net_return AS DECIMAL(18,12)) FROM tmpMain2;

[20 May 2016 21:15] MySQL Verification Team

Thank you for the feedback. Closing according your last private comment.