From 07e21be0fe707e4b147a5fdd796db5ce2f5d49c0 Mon Sep 17 00:00:00 2001
From: "bar@mysql.com" <>
Date: Wed, 29 Mar 2006 19:31:16 +0500
Subject: Additional 5.0 fix for Bug#15098: CAST(column double TO signed int),
 wrong result which was fixed originally in 4.1.

---
 mysql-test/r/cast.result | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'mysql-test')

diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result
index ae9e6748e65..d60efa083e0 100644
--- a/mysql-test/r/cast.result
+++ b/mysql-test/r/cast.result
@@ -344,6 +344,9 @@ SELECT f1 AS double_val, CAST(f1 AS SIGNED INT) AS cast_val FROM t1;
 double_val	cast_val
 -1e+30	-9223372036854775808
 1e+30	9223372036854775807
+Warnings:
+Warning	1292	Truncated incorrect INTEGER value: '-1e+30'
+Warning	1292	Truncated incorrect INTEGER value: '1e+30'
 DROP TABLE t1;
 select cast('1.2' as decimal(3,2));
 cast('1.2' as decimal(3,2))
-- 
cgit v1.2.1