Bug #8923 Functions: Function with DateTime as return type cannot be dropped
Submitted: 3 Mar 2005 14:53 Modified: 3 Mar 2005 15:41
Reporter: Disha Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.2 OS:Linux (Red Hat Linux 9.0)
Assigned to: CPU Architecture:Any

[3 Mar 2005 14:53] Disha 
Description:
A function which accepts DateTime as a function parameter and return type cannot be dropped with the DROP FUNCTION statement.

How to repeat:
Repro Steps:

Run the following SQL queries:

1. DROP FUNCTION IF EXISTS FN1//
2. Create Function FN1(F1 datetime) returns datetime Return F1//
3. DROP FUNCTION FN1//

Expected Result: The DROP FUNCTION FN1 should execute successfully without any errors

Actual Results:

    mysql>  DROP FUNCTION IF EXISTS FN1//
    Query OK, 0 rows affected, 1 warning (0.00 sec)

    mysql> Create Function FN1(F1 datetime) returns datetime
        ->          Return f1//
    Query OK, 0 rows affected (0.00 sec)

    mysql>  DROP FUNCTION FN1//
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'returns Return f1' at line 1

Additional Information: The same behavior is observerd with mediumblob.
[3 Mar 2005 15:17] Jorge del Conde 
Verified using 5.0.3 from bk
[3 Mar 2005 15:41] Per-Erik Martin 
A duplicate of BUG#3788: Stored procedure packet error if returns binary
it seems.