Bugs item #1910396, was opened at 2008-03-09 10:26
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1910396&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: drop function without arguments...
Initial Comment:
If I create the following function:
CREATE FUNCTION fGetDiagChecksum()
RETURNS BIGINT
BEGIN
RETURN (select sum(count)+count(*) from tables);
END;
and then I drop it:
DROP FUNCTION fGetDiagChecksum;
I get:
MAPI = [EMAIL PROTECTED]:50000
QUERY = DROP FUNCTION fGetDiagChecksum;
ERROR = !DROP FUNCTION: there are more than one function called
'fgetdiagchecksum', please use the full signature
This error message is not correct because there is only one function with this
name. The functions can be dropped using only the name if there is not more
functions with the same name, if there is, the full signature needs to be
given. To drop all the functions with the same name we need to do
drop all <function_name>;
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2008-03-14 13:05
Message:
Logged In: YES
user_id=43556
Originator: NO
this function is incorrect. I get
!SELECT: identifier 'count' unknown
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1910396&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
