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] [Created] (DERBY-6467) Document context-aware table functions.
Date Sun, 02 Feb 2014 21:54:08 GMT
Rick Hillegas created DERBY-6467:
------------------------------------

             Summary: 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: 10.11.0.0
            Reporter: Rick Hillegas


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
(v6.1.5#6160)

Mime
View raw message