diff options
Diffstat (limited to 'mysql-test/r/custom_aggregate_functions.result')
-rw-r--r-- | mysql-test/r/custom_aggregate_functions.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/custom_aggregate_functions.result b/mysql-test/r/custom_aggregate_functions.result index c2fdc271140..67be44c43f7 100644 --- a/mysql-test/r/custom_aggregate_functions.result +++ b/mysql-test/r/custom_aggregate_functions.result @@ -936,3 +936,14 @@ drop function f4; drop function f5; drop function f6; drop function f7; +create aggregate function f1(x date) returns date +begin +declare continue handler for not found return x; +loop +fetch group next row; +end loop; +end| +select f1('2001-01-01'),cast(f1('2001-01-01') as time); +f1('2001-01-01') cast(f1('2001-01-01') as time) +2001-01-01 00:00:00 +drop function f1; |