Return-Path: 
 <derby-dev-return-78121-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 6976 invoked from network); 12 May 2010 20:35:06 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 12 May 2010 20:35:06 -0000
Received: (qmail 56686 invoked by uid 500); 12 May 2010 20:35:05 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 56662 invoked by uid 500); 12 May 2010 20:35:05 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 56655 invoked by uid 99); 12 May 2010 20:35:05 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 May 2010 20:35:05 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 May 2010 20:35:03 +0000
Received: from thor (localhost [127.0.0.1])
	by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o4CKYgPF023261
	for <derby-dev@db.apache.org>; Wed, 12 May 2010 20:34:42 GMT
Message-ID: <6228144.4921273696482246.JavaMail.jira@thor>
Date: Wed, 12 May 2010 16:34:42 -0400 (EDT)
From: "Tiago R. Espinha (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4518) Document ORDER BY and OFFSET/FETCH
 in subqueries
In-Reply-To: <2095889641.337801263909834551.JavaMail.jira@brutus.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


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