[ 
https://issues.apache.org/jira/browse/DERBY-6121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13778736#comment-13778736
 ] 

Kim Haase commented on DERBY-6121:
----------------------------------

Thanks, Knut. I'll fix the ALTER TABLE syntax. I am also wondering about a 
couple other syntax sections, in SET SCHEMA 
(http://db.apache.org/derby/docs/10.10/ref/rrefsqlj32268.html) and SET 
ISOLATION (http://db.apache.org/derby/docs/10.10/ref/rrefsqlj41180.html). 

The syntax of SET SCHEMA is hard to untangle, and I am wondering if the way I 
straightened it out (I will attach the file) is correct. 

For SET ISOLATION, the description suggests that SERIALIZABLE is a synonym of 
RS, so it ought to be on the same line as RS, you might think? Also, you can 
only have one argument to SET ISOLATION, so I think there need to be vertical 
bars at the end of each line inside the curly braces?

These don't actually need to be changed as part of this issue, since there are 
no changes regarding argument names, so I can file a separate issue if these 
could use some changes.
                
> 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

Reply via email to