[
https://issues.apache.org/jira/browse/DERBY-6121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13764721#comment-13764721
]
Kim Haase commented on DERBY-6121:
----------------------------------
This issue affects more than the GRANT and REVOKE statements, and could lead to
quite a few consistency fixes.
Several CREATE statement topics specify the syntax for the created object in
the topic itself rather than in a separate topic under "SQL identifiers." These
include
CREATE DERBY AGGREGATE statement
CREATE FUNCTION statement
CREATE PROCEDURE statement
CREATE SEQUENCE statement
CREATE TYPE statement
I can create separate object-Name topics for each of these. Most of the
existing topics have hyphens but some don't -- table-Name vs. schemaName,
RoleName, etc. I may as well hyphenate the new ones.
It would probably be helpful to alphabetize the topics under "SQL identifiers."
The current order seems semi-random.
Some of the syntax for other statement topics can then be regularized as well,
in addition to that for GRANT and REVOKE.
> Regularize how we refer to object names in the Reference Manual sections on
> GRANT/REVOKE
> ----------------------------------------------------------------------------------------
>
> Key: DERBY-6121
> URL: https://issues.apache.org/jira/browse/DERBY-6121
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.10.1.1
> Reporter: Rick Hillegas
> Assignee: Kim Haase
>
> This issue came up during the buddy testing of user-defined aggregates.
> Here's what Dag discovered:
> identifiers (seen when looking at GRANT USAGE of aggregates):
> "table-Name" occurences are linked to a section explainig them
> (rreftablename.html), but UDA names are defined in-lined as
> GRANT USAGE ON DERBY AGGREGATE [ schemaName. ] SQL92Identifier TO
> grantees
> In a third variant,
> GRANT EXECUTE ON { FUNCTION | PROCEDURE } routine-designator TO grantees
> routine-designator is defined locally as
> routine-designator { function-name | procedure-name }
> without links to what "function-name" or "procedure-name" might look
> like. It would be good to harmonize the latter two forms to a central
> definition as for "table-Name".
> Finally, I noted that the definition page for SchemaName doesn't link to
> the SQL92Identifier page...
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
