[
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
derby4208b.diff
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: 10.5.1.1
> 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.
