[
https://issues.apache.org/jira/browse/DERBY-4518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12803430#action_12803430
]
Kim Haase commented on DERBY-4518:
----------------------------------
The spec is very clear! I do have a couple of questions about the Documentation
section.
The "SELECT statement" topic already includes the ORDER BY clause. Are other
changes needed? I would guess that the "Requirements for updatable cursors and
updatable ResultSets" section would not change (that is, ORDER BY is still not
allowed).
What changes are needed for the "SelectExpression" topic? Can the FROM clause
now be followed by ORDER BY, result offset, and fetch first clauses?
The "INSERT statement" topic refers to both a "VALUES list" and a "multiple-row
VALUES expression". I think that after some discussion a few years ago it was
agreed to use the term "VALUES expression" generally rather than "VALUES
clause" or "VALUES list". Would it be okay to combine these into "a single-row
or multiple-row values expression"?
> Document ORDER BY and OFFSET/FETCH in subqueries
> ------------------------------------------------
>
> Key: DERBY-4518
> URL: https://issues.apache.org/jira/browse/DERBY-4518
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
>
> DERBY-4397 and DERBY-4398 extends the usability of ORDER BY and OFFSET/FETCH
> to subqueries and view. This should be documented.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
