summaryrefslogtreecommitdiff
path: root/mysql-test/t/cast.test
diff options
context:
space:
mode:
authorgkodinov/kgeorge@magare.gmz <>2007-05-04 16:37:30 +0300
committergkodinov/kgeorge@magare.gmz <>2007-05-04 16:37:30 +0300
commitee624171ebcab64f40ca92b09f400d7ca5e3747a (patch)
tree6044b00f62117d52ebae6c52fa1ceae2ae7f2c4e /mysql-test/t/cast.test
parent9bdfe876a9a54040a24c6554a5045f12f166ab5c (diff)
parent287ebed161a18c8a648b70b440a2ef113df5d158 (diff)
downloadmariadb-git-ee624171ebcab64f40ca92b09f400d7ca5e3747a.tar.gz
Merge magare.gmz:/home/kgeorge/mysql/work/B27531-5.0-opt
into magare.gmz:/home/kgeorge/mysql/work/B27531-5.1-opt
Diffstat (limited to 'mysql-test/t/cast.test')
-rw-r--r--mysql-test/t/cast.test6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/cast.test b/mysql-test/t/cast.test
index bc50d484a5f..7217d00a1bb 100644
--- a/mysql-test/t/cast.test
+++ b/mysql-test/t/cast.test
@@ -182,6 +182,12 @@ DROP TABLE t1;
select isnull(date(NULL)), isnull(cast(NULL as DATE));
+#
+# Bug#23656: Wrong result of CAST from DATE to int
+#
+SELECT CAST(cast('01-01-01' as date) AS UNSIGNED);
+SELECT CAST(cast('01-01-01' as date) AS SIGNED);
+
--echo End of 4.1 tests