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 Wed, 12 May 2010 20:34:42 GMT

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


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

View raw message