[CASSANDRA-7812] DROP FUNCTION drops all function with a given name

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.0 beta 1
• Assignee: Robert Stupp
• Reporter: Sylvain Lebresne

Authors

Robert Stupp

Reviewers

Tom Hobbs

• Created: 21/Aug/14 15:47
• Updated: 16/Apr/19 09:31
• Resolved: 03/Sep/14 15:27

Description

We support multiple overloads of a given function name, so that you can define:

CREATE FUNCTION div(int a, int b) RETURNS int 'myDivOnIntegerFct';
CREATE FUNCTION div(double a, double b) RETURNS double 'myDivOnDoubleFct';

In other words, a function is uniquely identified by it's name and it's argument types.

But the DROP FUNCTION syntax currently only take a function name and if there is multiple overload for that name, drop all of them without any way to drop one without the other.

So we should probably allow to optionally pass the type arguments to DROP to select a specific overloading, something like:

DROP FUNCTION div(double, double);

Also, and while that's probably debatable, I'd also suggest to change the behavior of:

DROP FUNCTION div;

to complain if the there is multiple overload of the div method instead of dropping all overload as it feels somewhat foot-shooting otherwise.