Return-Path: 
 <derby-dev-return-68560-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 49664 invoked from network); 4 May 2009 12:55:54 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 4 May 2009 12:55:54 -0000
Received: (qmail 80256 invoked by uid 500); 4 May 2009 12:55:53 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 80193 invoked by uid 500); 4 May 2009 12:55:53 -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 80184 invoked by uid 99); 4 May 2009 12:55:53 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 May 2009 12:55:53 +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, 04 May 2009 12:55:51 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 53850234C003
	for <derby-dev@db.apache.org>; Mon,  4 May 2009 05:55:30 -0700 (PDT)
Message-ID: <635740178.1241441730334.JavaMail.jira@brutus>
Date: Mon, 4 May 2009 05:55:30 -0700 (PDT)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4208) Parameters ? with OFFSET and/or
 FETCH
In-Reply-To: <934110193.1241352810323.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-4208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12705580#action_12705580 ] 

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

Right, since this feature is not included by the SQL standard (offset
is a <simple value specification>, not a <general value specification>
in the syntax), we didn't implement it in the first version, but I
definitely see the utility of this extension. Feel free to vote for
this issue is you want it, folks.


> Parameters ? with OFFSET and/or FETCH
> -------------------------------------
>
>                 Key: DERBY-4208
>                 URL: https://issues.apache.org/jira/browse/DERBY-4208
>             Project: Derby
>          Issue Type: New Feature
>    Affects Versions: 10.5.1.1
>            Reporter: Steve Radman
>
> The new OFFSET/FETCH syntax does not support Parameters. 
> From ij against the toursdb I would like to do the following:
>     ij> prepare foo as 'select * from cities offset ? rows fetch first 10 rows only';
> but results in the following syntax error: 
>     ERROR 42X01: Syntax error: Encountered "?" at line 1, column 29.
> Parameterized OFFSET/FETCH is important for performance (can be prepared) and security (SQL strings not created on the fly).

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