db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4208) Parameters ? with OFFSET and/or FETCH
Date Tue, 07 Jul 2009 19:56:14 GMT

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

Rick Hillegas commented on DERBY-4208:

Hi Dag,

Thanks for tackling this important usability issue. I agree that the handling of dynamic parameters
looks a little complicated. We use dynamic parameters all across the language, practically
anywhere that a ValueNode can appear. It's hard to believe that special generated methods
are added to the factory signatures of the ResultSets for all of these instances. I would
recommend tracking down how we handle ? in a statement like "select * from t where a = ?".

> 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:
>            Reporter: Steve Radman
>         Attachments: derby4208a.diff, derby4208a.stat, derby4208b.diff, derby4208b.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.

View raw message