[
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)
