Return-Path: 
 <derby-dev-return-75159-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 14630 invoked from network); 11 Jan 2010 16:55:18 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 11 Jan 2010 16:55:18 -0000
Received: (qmail 63903 invoked by uid 500); 11 Jan 2010 16:55:17 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 63801 invoked by uid 500); 11 Jan 2010 16:55:17 -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 63778 invoked by uid 99); 11 Jan 2010 16:55:17 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jan 2010 16:55:17 +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.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jan 2010 16:55:15 +0000
Received: from brutus.apache.org (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 794B929A0011
	for <derby-dev@db.apache.org>; Mon, 11 Jan 2010 08:54:54 -0800 (PST)
Message-ID: <1489675038.155441263228894495.JavaMail.jira@brutus.apache.org>
Date: Mon, 11 Jan 2010 16:54:54 +0000 (UTC)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4398) Allow OFFSET/FETCH in subqueries
In-Reply-To: <897798140.1254787531466.JavaMail.jira@brutus>
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-4398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798721#action_12798721 ] 

Dag H. Wanvik commented on DERBY-4398:
--------------------------------------

Committed rev 3 as svn 897934, and a followup fix for a javadoc error svn 897937.

> Allow OFFSET/FETCH in subqueries
> --------------------------------
>
>                 Key: DERBY-4398
>                 URL: https://issues.apache.org/jira/browse/DERBY-4398
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Dag H. Wanvik
>            Assignee: Dag H. Wanvik
>             Fix For: 10.6.0.0
>
>         Attachments: derby-4398-2.diff, derby-4398-2.stat, derby-4398-3.diff, derby-4398-3.stat, derby-4398-insert.diff, derby-4398-insert.stat
>
>
> SQL 2008 specifies that OFFSET/FETCH (<result offset clause>, <fetch first clause>) may be used in subqueries.
> Currently, Derby only allows this at the outer (cursor) level. Cf. also DERBY-4397 on allowing ORDER BY in subqueries
> for this extension to be portable and useful.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.