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;
(works)

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.


Mime
View raw message