Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Wed, 28 Mar 2012 19:15:28 +0000 (UTC)
From: "Rick Hillegas (Commented) (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <2035075915.29694.1332962128420.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <640679144.15101.1320865191792.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (DERBY-5499) Document the new JDBC limit/offset
 escape syntax
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Rick Hillegas commented on DERBY-5499:
--------------------------------------

Hi Kim,

Thanks for catching that blooper. The limit/offset escape clause can appear wherever the OFFSET and FETCH FIRST clauses can appear. You are right, those clauses do not appear in the WHERE clause. Instead, they appear after the WHERE clause and after the ORDER BY clause. Sorry for the confusion. Thanks.
                
> Document the new JDBC limit/offset escape syntax
> ------------------------------------------------
>
>                 Key: DERBY-5499
>                 URL: https://issues.apache.org/jira/browse/DERBY-5499
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.9.0.0
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
>
> The work on DERBY-5488 adds new JDBC escape syntax for the limit/offset clauses. These should be documented, probably in the Reference Guide as a subsection of JDBC escape syntax.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira