[DERBY-3610] Confusing error message when granting execute privilege

• Type: Improvement
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 10.6.1.0
• Component/s: SQL
• Assignee: Hiranya Kasub Jayathilaka
• Reporter: Dag H. Wanvik
• Created: 09/Apr/08 12:27
• Updated: 30/May/11 15:22
• Resolved: 15/Apr/09 08:50

Description

When the wrong keyword is used in a grant execute privilege statement, the error message
leads one the believe the identifier is neither a procedure or a function, when in deed it is one of the two.

> create function bc(i int) returns int language java parameter style java external name 'java.lang.Integer.bitCount' no sql;
> grant execute on procedure bc to foo;
ERROR 42Y03: 'BC' is not recognized as a function or procedure.

> grant execute on function bc to foo;
(works)

The reason is that the error message is generic. It would be better to have an error message for each case.

Issue Links

• relates to: DERBY-5252 make GrantRevokeTest pass in non-English locale