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-6467) Document context-aware table functions.
Date Tue, 20 May 2014 12:30:39 GMT

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

Rick Hillegas commented on DERBY-6467:

Thanks, Kim. Looks good to me. +1

> Document context-aware table functions.
> ---------------------------------------
>                 Key: DERBY-6467
>                 URL: https://issues.apache.org/jira/browse/DERBY-6467
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions:
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
>         Attachments: DERBY-6467-2.diff, DERBY-6467-2.stat, DERBY-6467-2.zip, DERBY-6467.diff,
DERBY-6467.stat, cdevspecialtfcontext.html
> Now that we have added AwareVTI and VTIContext to the public api, it would be good to
document how to use them. Perhaps we could add a "Writing a context-aware table function"
subtopic under the "Programming Derby-style table functions" topic in the Developer's Guide.
> As an example, the new subsection could use ArchiveVTI together with the script which
is part of the 2014-02-02 comment on DERBY-6117.
> Context-aware table functions are useful when you need to describe a family of results
which have the following properties:
> 1) Each result in the family has a shape which is determined by a different table.
> 2) There may be several results associated with a given table. In addition to having
the same shape, the sub-family of results differ from one another based on some variables
which cannot be represented as ? parameters in a SELECT statement.

This message was sent by Atlassian JIRA

View raw message