db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6121) Regularize how we refer to object names in the Reference Manual sections on GRANT/REVOKE
Date Wed, 11 Sep 2013 20:28:52 GMT

    [ 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

Mime
View raw message