You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2010/01/07 18:11:54 UTC
[jira] Created: (DERBY-4507) Write user documentation for
restricted table functions.
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: 10.6.0.0
Reporter: Rick Hillegas
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.
[jira] Commented: (DERBY-4507) Write user documentation for
restricted table functions.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12838570#action_12838570 ]
Rick Hillegas commented on DERBY-4507:
--------------------------------------
Hi Kim,
Thanks for the revised patch. I'll take a look at it later when I pop off my interrupt stack. The JIRA for UDTs is DERBY-651. That JIRA uses the term "Abstract Data Types" in its early comments. Later comments use the term "User Defined Types". Cheers-Rick
> 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: 10.6.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-4507-2.diff, DERBY-4507-2.stat, DERBY-4507-2.zip, 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.
[jira] Updated: (DERBY-4507) Write user documentation for
restricted table functions.
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4507:
-----------------------------
Issue & fix info: [Patch Available]
> 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: 10.6.0.0
> 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.
[jira] Commented: (DERBY-4507) Write user documentation for
restricted table functions.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12838906#action_12838906 ]
Rick Hillegas commented on DERBY-4507:
--------------------------------------
Thanks Kim. The revised patch looks great. +1
> 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: 10.6.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-4507-2.diff, DERBY-4507-2.stat, DERBY-4507-2.zip, 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.
[jira] Commented: (DERBY-4507) Write user documentation for
restricted table functions.
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12838573#action_12838573 ]
Kim Haase commented on DERBY-4507:
----------------------------------
Thanks, Rick. I'll file an issue for the UDT documentation so we can track it.
> 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: 10.6.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-4507-2.diff, DERBY-4507-2.stat, DERBY-4507-2.zip, 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.
[jira] Commented: (DERBY-4507) Write user documentation for
restricted table functions.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ 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:
--------------
cdevspecialtfbasic.html:
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."
--------------
cdevspecialtfrestr.html:
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 org.apache.derby.vti.RestrictedVTI."
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" ) )
--------------
cdevspecialtfgetxxx.html:
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.
--------------
cdevspecialtfopttune.html:
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: 10.6.0.0
> 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.
[jira] Closed: (DERBY-4507) Write user documentation for restricted
table functions.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-4507.
--------------------------------
> 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: 10.6.1.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Fix For: 10.6.1.0
>
> Attachments: DERBY-4507-2.diff, DERBY-4507-2.stat, DERBY-4507-2.zip, 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.
[jira] Updated: (DERBY-4507) Write user documentation for
restricted table functions.
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4507:
-----------------------------
Attachment: DERBY-4507.zip
DERBY-4507.stat
DERBY-4507.diff
Attaching DERBY-4507.diff, DERBY-4507.stat, and DERBY-4507.zip.
Added topic for restricted table functions in Developer's Guide. Also changed hard-coded "Derby" in other topics to the conrefs phrase, and redid line breaks in examples so they look okay in both PDF and HTML frames.
I didn't make any change to the CREATE FUNCTION statement in the Ref Manual because the current paragraph on table functions seemed general enough not to need any change. If you have any thoughts on needed changes here, please let me know.
> 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: 10.6.0.0
> 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.
[jira] Updated: (DERBY-4507) Write user documentation for
restricted table functions.
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4507:
-----------------------------
Attachment: DERBY-4507-2.zip
DERBY-4507-2.stat
DERBY-4507-2.diff
Thanks, Rick, for the helpful suggestions. I'm attaching DERBY-4507-2.diff, DERBY-4507-2.stat, and DERBY-4507-2.zip, which make the suggested changes to the Dev Guide topics and also modify the tuning guide topic -- I retitled it to make it a bit more general and added a sentence on restricted table functions.
Let me know if any more changes are needed.
I will keep the UDT item in mind. BTW, what is the base JIRA issue for UDTs? I can't seem to find it.
> 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: 10.6.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-4507-2.diff, DERBY-4507-2.stat, DERBY-4507-2.zip, 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.
[jira] Resolved: (DERBY-4507) Write user documentation for
restricted table functions.
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase resolved DERBY-4507.
------------------------------
Resolution: Fixed
Fix Version/s: 10.6.0.0
Issue & fix info: (was: [Patch Available])
Thank you, Rick!
Committed patch DERBY-4507-2.diff to documentation trunk at revision 916743.
> 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: 10.6.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Fix For: 10.6.0.0
>
> Attachments: DERBY-4507-2.diff, DERBY-4507-2.stat, DERBY-4507-2.zip, 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.
[jira] Assigned: (DERBY-4507) Write user documentation for
restricted table functions.
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase reassigned DERBY-4507:
--------------------------------
Assignee: Kim Haase
> 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: 10.6.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
>
> 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.