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 17:46: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: derby4208b.stat

Uploading a fairly complete version of this patch, I did some simplifications, removed cruft
and added NULL handling (supplying a NULL argument will give an error now),
and added more tests.

A note: ParameterNode.setType always make the type nullable, no matter if the passed in DVD
is not nullable, not sure why. This makes the parameter metadata for ? always nullable, which
doesn't seem right here.. Since dynamic arguments in OFFSET/FETCH is outside the standard,
we don't have any guidance here...

> 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