[
https://issues.apache.org/jira/browse/DERBY-4518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12863412#action_12863412
]
Tiago R. Espinha commented on DERBY-4518:
-----------------------------------------
Sorry to be revisiting this issue but I was doing buddy-testing for this
feature and I was a bit stumped with the documentation. 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.
In my opinion this is something small and not worth a respin but maybe we can
refine it for further releases?
> Document ORDER BY and OFFSET/FETCH in subqueries
> ------------------------------------------------
>
> Key: DERBY-4518
> URL: https://issues.apache.org/jira/browse/DERBY-4518
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Fix For: 10.6.1.0
>
> Attachments: DERBY-4518-2.diff, DERBY-4518-2.zip, DERBY-4518-3.diff,
> DERBY-4518-3.zip, DERBY-4518.diff, DERBY-4518.stat, DERBY-4518.zip
>
>
> DERBY-4397 and DERBY-4398 extends the usability of ORDER BY and OFFSET/FETCH
> to subqueries and view. This should be documented.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
