summaryrefslogtreecommitdiff
path: root/mysql-test/r/cast.result
diff options
context:
space:
mode:
authorunknown <bar@mysql.com>2006-03-31 17:38:00 +0500
committerunknown <bar@mysql.com>2006-03-31 17:38:00 +0500
commit201a1441568ab07317b012bb6f24d076d9948249 (patch)
treef1d3a5ddf744e1e7a411bda9ac386b4d4fa9b0bc /mysql-test/r/cast.result
parent659dfdfc077384cb9dbeb050e538d22476510685 (diff)
parentfa65771ed82e820822efeeb9678e8bca9a4bf095 (diff)
downloadmariadb-git-201a1441568ab07317b012bb6f24d076d9948249.tar.gz
Merge mysql.com:/usr/home/bar/mysql-5.0.1.2107.1.1
into mysql.com:/usr/home/bar/mysql-5.1-new mysql-test/r/cast.result: Auto merged sql/field.cc: Auto merged
Diffstat (limited to 'mysql-test/r/cast.result')
-rw-r--r--mysql-test/r/cast.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result
index 2f66b982d5a..3478353b0ec 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))