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 "Dag H. Wanvik (JIRA)" <ji...@apache.org> on 2011/08/16 22:02:27 UTC
[jira] [Created] (DERBY-5385) Improve documentation for
OFFSET/FETCH NEXT
Improve documentation for OFFSET/FETCH NEXT
-------------------------------------------
Key: DERBY-5385
URL: https://issues.apache.org/jira/browse/DERBY-5385
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.8.1.2
Reporter: Dag H. Wanvik
cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5385) Improve documentation for
OFFSET/FETCH NEXT
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-5385:
-----------------------------
Attachment: rrefsqljoffsetfetch.html
DERBY-5385.diff
Attaching DERBY-5385.diff and rrefsqljoffsetfetch.html. The patch clarifies the meaning of "dynamic parameter" and adds an example of using one of the clauses in a subquery (the same example that is in the Query topic).
Please let me know if changes are needed or if more information would be useful.
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
> Key: DERBY-5385
> URL: https://issues.apache.org/jira/browse/DERBY-5385
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Attachments: DERBY-5385.diff, rrefsqljoffsetfetch.html
>
>
> cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Closed] (DERBY-5385) Improve documentation for OFFSET/FETCH
NEXT
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik closed DERBY-5385.
--------------------------------
Thanks, Kim, closing.
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
> Key: DERBY-5385
> URL: https://issues.apache.org/jira/browse/DERBY-5385
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Fix For: 10.8.1.6, 10.9.0.0
>
> Attachments: DERBY-5385.diff, rrefsqljoffsetfetch.html
>
>
> cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Issue Comment Edited] (DERBY-5385) Improve documentation
for OFFSET/FETCH NEXT
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13087780#comment-13087780 ]
Dag H. Wanvik edited comment on DERBY-5385 at 8/19/11 4:07 PM:
---------------------------------------------------------------
Thanks, Kim. Changes look good to me. But this observation by Tiago was the reason we kept DERBY-4518 open, I believe:
"I couldn't find an example under "The result offset and fetch first clauses" that demonstrates the use of OFFSET within sub-queries. There is an example under "Duplicates in UNION, INTERSECT, and EXCEPT ALL results" but at least to me, that wouldn't be the first logical place I'd visit to find examples of OFFSET usage on sub-queries."
Perhaps it might be good to to point to the example of use in sub-queries from "The result offset and fetch first clauses" section's examples, or make another one there?
was (Author: dagw):
Thanks, Kim. Thanges look good to me. But this observatiob by Tiago was the reason we kept DERBY-4518 open, I believe:
"I couldn't find an example under "The result offset and fetch first clauses" that demonstrates the use of OFFSET within sub-queries. There is an example under "Duplicates in UNION, INTERSECT, and EXCEPT ALL results" but at least to me, that wouldn't be the first logical place I'd visit to find examples of OFFSET usage on sub-queries."
Perhaps it might be good to to point to the example of use in sub-queries from "The result offset and fetch first clauses" section's examples, or make another one there?
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
> Key: DERBY-5385
> URL: https://issues.apache.org/jira/browse/DERBY-5385
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Attachments: DERBY-5385.diff, rrefsqljoffsetfetch.html
>
>
> cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5385) Improve documentation for
OFFSET/FETCH NEXT
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13087827#comment-13087827 ]
Kim Haase commented on DERBY-5385:
----------------------------------
I thought I took that example from "Duplicates in UNION, INTERSECT, and EXCEPT ALL results" and put it right into this topic. Isn't it there? The comment says "Use of ORDER BY and FETCH FIRST in a subquery".
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
> Key: DERBY-5385
> URL: https://issues.apache.org/jira/browse/DERBY-5385
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Attachments: DERBY-5385.diff, rrefsqljoffsetfetch.html
>
>
> cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (DERBY-5385) Improve documentation for
OFFSET/FETCH NEXT
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase reassigned DERBY-5385:
--------------------------------
Assignee: Kim Haase
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
> Key: DERBY-5385
> URL: https://issues.apache.org/jira/browse/DERBY-5385
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
>
> cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5385) Improve documentation for
OFFSET/FETCH NEXT
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13087780#comment-13087780 ]
Dag H. Wanvik commented on DERBY-5385:
--------------------------------------
Thanks, Kim. Thanges look good to me. But this observatiob by Tiago was the reason we kept DERBY-4518 open, I believe:
"I couldn't find an example under "The result offset and fetch first clauses" that demonstrates the use of OFFSET within sub-queries. There is an example under "Duplicates in UNION, INTERSECT, and EXCEPT ALL results" but at least to me, that wouldn't be the first logical place I'd visit to find examples of OFFSET usage on sub-queries."
Perhaps it might be good to to point to the example of use in sub-queries from "The result offset and fetch first clauses" section's examples, or make another one there?
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
> Key: DERBY-5385
> URL: https://issues.apache.org/jira/browse/DERBY-5385
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Attachments: DERBY-5385.diff, rrefsqljoffsetfetch.html
>
>
> cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5385) Improve documentation for
OFFSET/FETCH NEXT
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-5385:
-----------------------------
Issue & fix info: [Patch Available]
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
> Key: DERBY-5385
> URL: https://issues.apache.org/jira/browse/DERBY-5385
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Attachments: DERBY-5385.diff, rrefsqljoffsetfetch.html
>
>
> cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5385) Improve documentation for
OFFSET/FETCH NEXT
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13088025#comment-13088025 ]
Dag H. Wanvik commented on DERBY-5385:
--------------------------------------
Sure it's there. I must have looked at this before my morning coffee.. Sorry ;-) +1
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
> Key: DERBY-5385
> URL: https://issues.apache.org/jira/browse/DERBY-5385
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Attachments: DERBY-5385.diff, rrefsqljoffsetfetch.html
>
>
> cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5385) Improve documentation for
OFFSET/FETCH NEXT
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik updated DERBY-5385:
---------------------------------
Affects Version/s: 10.6.1.0
10.6.2.1
10.7.1.1
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
> Key: DERBY-5385
> URL: https://issues.apache.org/jira/browse/DERBY-5385
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
> Reporter: Dag H. Wanvik
>
> cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (DERBY-5385) Improve documentation for
OFFSET/FETCH NEXT
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase resolved DERBY-5385.
------------------------------
Resolution: Fixed
Fix Version/s: 10.9.0.0
10.8.1.6
Issue & fix info: (was: [Patch Available])
Thanks very much, Dag!
Committed patch DERBY-5385.diff to documentation trunk at revision 1160250.
Merged to 10.8 doc branch at revision 1160256.
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
> Key: DERBY-5385
> URL: https://issues.apache.org/jira/browse/DERBY-5385
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Fix For: 10.8.1.6, 10.9.0.0
>
> Attachments: DERBY-5385.diff, rrefsqljoffsetfetch.html
>
>
> cf the suggestion in DERBY-4518.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira