Return-Path:
X-Original-To: apmail-db-derby-commits-archive@www.apache.org
Delivered-To: apmail-db-derby-commits-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
by minotaur.apache.org (Postfix) with SMTP id 88CE89938
for ;
Thu, 29 Mar 2012 17:19:06 +0000 (UTC)
Received: (qmail 5587 invoked by uid 500); 29 Mar 2012 17:19:06 -0000
Delivered-To: apmail-db-derby-commits-archive@db.apache.org
Received: (qmail 5518 invoked by uid 500); 29 Mar 2012 17:19:05 -0000
Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help:
list-unsubscribe:
List-Post:
Reply-To: "Derby Development"
List-Id:
Delivered-To: mailing list derby-commits@db.apache.org
Received: (qmail 5511 invoked by uid 99); 29 Mar 2012 17:19:05 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Mar 2012 17:19:05 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4)
by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Mar 2012 17:19:04 +0000
Received: from eris.apache.org (localhost [127.0.0.1])
by eris.apache.org (Postfix) with ESMTP id 3F0502388860;
Thu, 29 Mar 2012 17:18:44 +0000 (UTC)
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r1307003 - in /db/derby/docs/trunk/src/ref:
refderby.ditamap
rrefjdbc1020262.dita rrefjdbclimit.dita
Date: Thu, 29 Mar 2012 17:18:44 -0000
To: derby-commits@db.apache.org
From: chaase3@apache.org
X-Mailer: svnmailer-1.0.8-patched
Message-Id: <20120329171844.3F0502388860@eris.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org
Author: chaase3
Date: Thu Mar 29 17:18:43 2012
New Revision: 1307003
URL: http://svn.apache.org/viewvc?rev=1307003&view=rev
Log:
DERBY-5499 Document the new JDBC limit/offset escape syntax
Added new Reference Manual topic, modified another.
Patch: DERBY-5499-2.diff
Added:
db/derby/docs/trunk/src/ref/rrefjdbclimit.dita (with props)
Modified:
db/derby/docs/trunk/src/ref/refderby.ditamap
db/derby/docs/trunk/src/ref/rrefjdbc1020262.dita
Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=1307003&r1=1307002&r2=1307003&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Thu Mar 29 17:18:43 2012
@@ -632,6 +632,8 @@ URL syntax">
+
+
Modified: db/derby/docs/trunk/src/ref/rrefjdbc1020262.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbc1020262.dita?rev=1307003&r1=1307002&r2=1307003&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc1020262.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc1020262.dita Thu Mar 29 17:18:43 2012
@@ -39,6 +39,8 @@ the following JDBC escape keywords, whic
for use in CallableStatements.
The keyword
for specifying escape characters for LIKE clauses.
+ The
+escape keywords for specifying limit/offset clauses.
The escape keyword
for scalar functions.
The escape keyword
Added: db/derby/docs/trunk/src/ref/rrefjdbclimit.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefjdbclimit.dita?rev=1307003&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbclimit.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefjdbclimit.dita Thu Mar 29 17:18:43 2012
@@ -0,0 +1,57 @@
+
+
+
+
+
+JDBC escape syntax for limit/offset clauses
+
+LIMIT (JDBC escape keyword)
+OFFSET (JDBC escape keyword)
+
+
+
+
+The LIMIT escape clause can occur in a query at the point where an
+OFFSET/FETCH FIRST clause can appear. See
+ for more
+information.
+
+Syntax
+{ LIMIT rowCount [ OFFSET startRow ] }
+The rowCount is a non-negative integer that specifies the
+number of rows to return. If rowCount is 0, all rows from startRow
+forward are returned.
+The startRow is a non-negative number that specifies the number of
+rows to skip before returning results.
+
+Equivalent to
+OFFSET startRow FETCH NEXT rowCount ROWS ONLY
+
+Examples
+-- return the first two rows of sorted table t
+SELECT * FROM t
+ORDER BY a
+{ LIMIT 2 }
+-- return two rows of sorted table t, starting with the eleventh row
+SELECT * FROM t
+ORDER BY a
+{ LIMIT 2 OFFSET 10 }
+
+
+
Propchange: db/derby/docs/trunk/src/ref/rrefjdbclimit.dita
------------------------------------------------------------------------------
svn:eol-style = native