db-derby-dev mailing list archives

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

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

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

    Attachment: derby4208a.stat
                derby4208a.diff

Here is a first cut at a patch for this functionality. What do people think,
should let Derby have this functionality in spite of the standard not catering for it?

The code is currently a little clumsy since it more or less lets the current code
in peace, and just extends with treatment for dynamic parameters. Not for commit yet,
I'd just like some feedback on the desirability and general approach for now.

I added some tests for it as well.


> 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
>
>
> 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.


Mime
View raw message