summaryrefslogtreecommitdiff
path: root/mysql-test/t/cast.test
diff options
context:
space:
mode:
authorunknown <evgen@moonbone.local>2007-05-04 12:27:21 +0400
committerunknown <evgen@moonbone.local>2007-05-04 12:27:21 +0400
commit74c794d0e4a14b6deddc90e74ed718c2f00653df (patch)
tree7c4be5e68bcddc6fe24f6fc58b15a3470c9db8a7 /mysql-test/t/cast.test
parent8e8ece72eb0530bee9b200d92ba14a143cd1dec9 (diff)
parent1a0e3a285818f0a71cdc7f387a63f7cc72c72972 (diff)
downloadmariadb-git-74c794d0e4a14b6deddc90e74ed718c2f00653df.tar.gz
Merge moonbone.local:/mnt/gentoo64/work/23656-bug-4.1-opt-mysql
into moonbone.local:/mnt/gentoo64/work/23656-bug-5.0-opt-mysql mysql-test/r/cast.result: Auto merged mysql-test/t/cast.test: Auto merged sql/item_func.cc: Manual merge
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 502c5781f1f..004ef69182d 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