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-4507) Write user documentation for restricted table functions.
Date Thu, 25 Feb 2010 16:42:27 GMT

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

Rick Hillegas commented on DERBY-4507:

Thanks for this documentation, Kim. I have a couple comments:



I would reword the changes slightly so that they apply to general table functions and not
just to table functions which select from a table in a foreign database:

"With a normal table function, you must select its entire contents. You can, however, write
a restricted table function that lets you limit the rows and columns you select. A restricted
table function can improve performance greatly."



I would reword the following sentence so that it doesn't refer to the newness of this feature.
I don't think we'll remember to update this manual when the feature no longer seems new:

"You must write a class which implements both java.sql.ResultSet and the Derby-specific interface

Also, the signature of the ColumnQualifier constructor changed. I apologize for not updating
the functional spec. The example should be changed to:

    new Restriction.ColumnQualifier(
        "LASTNAME", ORDER_OP_EQUALS, "Stone" ) )



This page looks ok. Just a heads-up that we need to update this table as part of the UDT documentation
because UDTs are now allowed as the types of columns returned by table functions.



This pages looks ok, too. However, it made me realize that it would be useful to have a brief
section in the Tuning Guide on how to optimize the performance of table functions by implementing
the interface for restricted table functions. This section could just point to the extensive
write-up in the Developer Guide.

> Write user documentation for restricted table functions.
> --------------------------------------------------------
>                 Key: DERBY-4507
>                 URL: https://issues.apache.org/jira/browse/DERBY-4507
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions:
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
>         Attachments: DERBY-4507.diff, DERBY-4507.stat, DERBY-4507.zip
> We need to document this 10.6 feature: DERBY-4357.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message