Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1377082344.1247011634810.JavaMail.jira@brutus>
Date: Tue, 7 Jul 2009 17:07:14 -0700 (PDT)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (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


     [ https://issues.apache.org/jira/browse/DERBY-4208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dag H. Wanvik updated DERBY-4208:
---------------------------------

    Attachment: derby4208c.stat
                derby4208c.diff

Uploading a slightly simplified version, which removes the special casing of
literals (code is generated uniformly when a row count is provided). This makes for less clutter
(e.g. two fewer args to the result set class/factory methods, only one range check instance).


> Parameters ? with OFFSET and/or FETCH
> -------------------------------------
>
>                 Key: DERBY-4208
>                 URL: https://issues.apache.org/jira/browse/DERBY-4208
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.5.1.1
>            Reporter: Steve Radman
>         Attachments: derby4208a.diff, derby4208a.stat, derby4208b.diff, derby4208b.stat, derby4208c.diff, derby4208c.stat
>
>
> 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.