[jira] [Commented] (DERBY-6121) Regularize how we refer to object names in the Reference Manual sections on GRANT/REVOKE

["Kim Haase (JIRA)" <ji...@apache.org>]

    [ 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