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] [Updated] (DERBY-6121) Regularize how we refer to object names in the Reference Manual
Date Wed, 02 Oct 2013 19:17:43 GMT

     [ https://issues.apache.org/jira/browse/DERBY-6121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kim Haase updated DERBY-6121:
-----------------------------

    Attachment: DERBY-6121-2.zip
                DERBY-6121-2.stat
                DERBY-6121-2.diff

Here's the second stage of these fixes. The attached patch, DERBY-6121-2.diff, DERBY-6121-2.stat,
and DERBY-6121-2.zip, makes the object names and formatting more consistent in the built-in
functions section of the Reference Manual, in the JDBC escape syntax topics, and in two other
JDBC topics.

I also made the fix Knut suggested to the tableFunctionInvocation topic (rrefsqljtfinvoke.html).

A couple of additional notes: 

1) I took the liberty of changing "cotangens" to "cotangent" in the topic on the COT function
(rreffunccot.html). I think "cotangens" is the term in some languages -- not English, though.

2) The topic on the CHAR function (rrefbuiltchar.html) mentions using the "DECIMAL scalar
function". I can't find any reference to this function. Do you have any idea what is being
referred to here? There's a long list of scalar functions in "JDBC escape syntax for fn keyword"
(rrefjdbc88908.html), but "decimal" is not among them.

3) I notice that for all the functions that take a DOUBLE argument, there is a link to the
topic on that data type. Topics that take other kinds of arguments often don't link to the
topics on those data types (see the DATE function topic, rrefdatefunc.html, or the LTRIM function
topic, rrefsqlj97870.html, for example). Would it be useful to add these links? Or should
we not bother?

4) The bullet lists in two of the JDBC topics, rrefpgc1.html and rrefcrsrgpc1.html should
arguably be tables. This could be a separate issue, though. (In the book they are subtopics
of the topic on the DatabaseMetaData interface.)

Thanks in advance for your feedback.

> Regularize how we refer to object names in the Reference Manual
> ---------------------------------------------------------------
>
>                 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
>         Attachments: DERBY-6121-2.diff, DERBY-6121-2.stat, DERBY-6121-2.zip, DERBY-6121.diff,
DERBY-6121.stat, DERBY-6121.zip, rrefsqlj32268.html
>
>
> 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 was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message