diff options
| author | acurtis@xiphis.org <> | 2005-04-21 13:22:47 +0100 |
|---|---|---|
| committer | acurtis@xiphis.org <> | 2005-04-21 13:22:47 +0100 |
| commit | f67507588fc58b86a05ea494f669e2909b08bc72 (patch) | |
| tree | 8df8337ce1a9874bfb77d66f673ac6c9b35efc30 /mysql-test/r/sp.result | |
| parent | 8689083aca0c97457701551b776b1a9c9743c10d (diff) | |
| download | mariadb-git-f67507588fc58b86a05ea494f669e2909b08bc72.tar.gz | |
Bug#8861 - If Return is a YEAR data type, value is not shown in year format
Bug partially fixed by 9775/9102 work on SP function return.
Diffstat (limited to 'mysql-test/r/sp.result')
| -rw-r--r-- | mysql-test/r/sp.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 5d93f252716..23c3548b9bf 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -2991,4 +2991,14 @@ select bug9775(1),bug9775(2),bug9775(3),bug9775(4)| bug9775(1) bug9775(2) bug9775(3) bug9775(4) a b a,b drop function bug9775| +drop function if exists bug8861| +create function bug8861(v1 int) returns year return v1| +select bug8861(05)| +bug8861(05) +2005 +set @x = bug8861(05)| +select @x| +@x +2005 +drop function bug8861| drop table t1,t2; |