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

View raw message