[
https://issues.apache.org/jira/browse/DERBY-4518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12866719#action_12866719
]
Tiago R. Espinha commented on DERBY-4518:
-----------------------------------------
I seem to have run into another problem with my buddy testing. On DERBY-4398
the following is mentioned:
"F860 dynamic <fetch first row count> in <fetch first clause> (already present
in 10.5) "
How does this dynamic fetching work? I've tried:
select * from t1 order by f1 desc fetch first count(*) only;
and
select f1, count(*) as cnt from t1 fetch first cnt only;
But I always got an error. Am I misunderstanding that feature?
> 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
> 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.
