db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3610) Confusing error message when granting execute privilege
Date Wed, 09 Apr 2008 12:29:24 GMT
Confusing error message when granting execute privilege

                 Key: DERBY-3610
                 URL: https://issues.apache.org/jira/browse/DERBY-3610
             Project: Derby
          Issue Type: Improvement
            Reporter: Dag H. Wanvik
            Priority: Trivial

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;

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

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message