MySQL Bugs: #5905: Error calling functions which return DATETIME

Bug #5905	Error calling functions which return DATETIME
Submitted:	5 Oct 2004 18:05	Modified:	3 Apr 2005 9:06
Reporter:	Dean Ellis	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.2 (1.1629)	OS:
Assigned to:	Dmitry Lenev	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Cannot call a function which returns DATETIME.

How to repeat:
CREATE FUNCTION f1 () RETURNS DATETIME RETURN NOW();
SELECT f1();
DROP FUNCTION f1;

Suggested fix:
n/a

Hi, Dean!

I can't repeat this bug with current 5.0 tree. Since similar problems were fixed recently by Antony (particularly bugs #3788 and #2773), I assume that this bug is fixed too. So I am closing this bug-report. Feel free to reopen it if you still can repeat it...