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] Created: (DERBY-4398) Allow OFFSET/FETCH in subqueries
Date Tue, 06 Oct 2009 00:05:31 GMT
Allow OFFSET/FETCH in subqueries

                 Key: DERBY-4398
                 URL: https://issues.apache.org/jira/browse/DERBY-4398
             Project: Derby
          Issue Type: Improvement
          Components: SQL
            Reporter: Dag H. Wanvik

SQL 2008 specifies that OFFSET/FETCH (<result offset clause>, <fetch first clause>)
may be used in subqueries.
Currently, Derby only allows this at the outer (cursor) level. Cf. also DERBY-4397 on allowing
ORDER BY in subqueries
for this extension to be portable and useful.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message