[jira] Commented: (DERBY-4208) Parameters ? with OFFSET and/or FETCH

["Dag H. Wanvik (JIRA)" <ji...@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.