db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tiago R. Espinha (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4518) Document ORDER BY and OFFSET/FETCH in subqueries
Date Mon, 03 May 2010 17:23:56 GMT

    [ 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.


Mime
View raw message