Fix for bug #8935 CAST(time AS DECIMAL) crashes

mysql-test/r/cast.result:
  test result
mysql-test/r/func_group.result:
  test result
mysql-test/t/cast.test:
  test case
sql/field.cc:
  this assert isn't correct actually

1 files changed, 5 insertions, 0 deletions

diff --git a/mysql-test/t/cast.test b/mysql-test/t/cast.test
index 5866431e687..94d9590dd5f 100644
--- a/mysql-test/t/cast.test
+++ b/mysql-test/t/cast.test
@@ -126,3 +126,8 @@ select cast(cast('1.2' as decimal(3,2)) as signed);
 set @v1=1e18;
 select cast(@v1 as decimal(22, 2));
 select cast(-1e18 as decimal(22,2));
+
+create table t1(s1 time);
+insert into t1 values ('11:11:11');
+select cast(s1 as decimal(7,2)) from t1;
+drop table t1;