db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Radman (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4208) Parameters ? with OFFSET and/or FETCH
Date Sun, 03 May 2009 12:13:30 GMT
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.


Mime
View raw message