db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6121) Regularize how we refer to object names in the Reference Manual
Date Thu, 03 Oct 2013 14:46:44 GMT

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

Rick Hillegas commented on DERBY-6121:
--------------------------------------

Hi Kim,

Looks nice. +1 to this increment. A couple comments follow:

o I wonder if "JOIN operations" should be "joinOperation" in rrefjdbc37244.

Some responses to your questions:

> 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.

I can't find any reference to a DECIMAL scalar function in the current Reference Manual or
in the Reference Manuals for Cloudscape 3.5 or 5.1. However, I see that DB2 supports such
a function: https://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.admin.doc%2Fdoc%2Fr0000791.htm
Maybe this is left over from a Cloudscape version produced after 5.1 but before Derby was
open-sourced. I would recommend striking this confusing sentence.

> 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?

It is puzzling that this is only done regularly for DOUBLE PRECISION. Note that rreffuncrand
hot-links to both DOUBLE PRECISION and INTEGER. My question would be: where do we draw the
line? Do we want to go through the whole Reference Manual and regularize this? I can see that
these hotlinks are convenient but I'm not sure this is worth doing if it's a big rototill.

Thanks,
-Rick


> 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