Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Fri, 19 Aug 2011 16:08:27 +0000 (UTC)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <879045169.53245.1313770107413.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <461415714.42387.1313524947174.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Issue Comment Edited] (DERBY-5385) Improve documentation
 for OFFSET/FETCH NEXT
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-5385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13087780#comment-13087780 ] 

Dag H. Wanvik edited comment on DERBY-5385 at 8/19/11 4:07 PM:
---------------------------------------------------------------

Thanks, Kim. Changes look good to me. But this observation by Tiago was the reason we kept DERBY-4518 open, I believe:

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

Perhaps it might be good to to point to the example of use in sub-queries from "The result offset and fetch first clauses" section's examples, or make another one there?

      was (Author: dagw):
    Thanks, Kim. Thanges look good to me. But this observatiob by Tiago was the reason we kept DERBY-4518 open, I believe:

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

Perhaps it might be good to to point to the example of use in sub-queries from "The result offset and fetch first clauses" section's examples, or make another one there?
  
> Improve documentation for OFFSET/FETCH NEXT
> -------------------------------------------
>
>                 Key: DERBY-5385
>                 URL: https://issues.apache.org/jira/browse/DERBY-5385
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2
>            Reporter: Dag H. Wanvik
>            Assignee: Kim Haase
>         Attachments: DERBY-5385.diff, rrefsqljoffsetfetch.html
>
>
> cf the suggestion in DERBY-4518.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira