From 9daa6c6e722233f6af51a6590d25f730fa17ac06 Mon Sep 17 00:00:00 2001
From: Sergei Golubchik <sergii@pisem.net>
Date: Sat, 19 Mar 2011 15:19:05 +0100
Subject: lp:738091  cast(timestamp() AS time returns NULL for 0000-00-00
 00:00:00 in 5.1-micro

---
 mysql-test/t/func_time.test | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'mysql-test/t/func_time.test')

diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test
index 70451e98763..cf725893505 100644
--- a/mysql-test/t/func_time.test
+++ b/mysql-test/t/func_time.test
@@ -977,3 +977,12 @@ select day(coalesce(null));
 # lp:738067 Crash in get_datetime_value() in 5.1-micro
 #
 select timestamp(greatest('2002-08-20', '0000-00-00 00:00:00'));
+
+#
+# lp:738091  cast(timestamp() AS time returns NULL for 0000-00-00 00:00:00 in 5.1-micro
+#
+create table t1 (f1 datetime);
+insert into t1 values ('0000-00-00 00:00:00');
+select cast(f1 AS time) from t1;
+drop table t1;
+
-- 
cgit v1.2.1