You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Kim Haase (JIRA)" <ji...@apache.org> on 2010/01/22 23:56:21 UTC

[jira] Updated: (DERBY-4518) Document ORDER BY and OFFSET/FETCH in subqueries

     [ https://issues.apache.org/jira/browse/DERBY-4518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase updated DERBY-4518:
-----------------------------

    Attachment: DERBY-4518.zip
                DERBY-4518.stat
                DERBY-4518.diff

Thanks for straightening me out on the offset syntax, Dag.

Attaching DERBY-4518.diff, DERBY-4518.stat, and DERBY-4518.zip, a preliminary patch, with changes to the following 11 topics:

Reference Manual:

CREATE VIEW statement: rrefsqlj15446.dita
INSERT statement: rrefsqlj40774.dita
ORDER BY clause: rrefsqlj13658.dita
SelectExpression: rrefselectexpression.dita
VALUES expression: rrefsqlj11277.dita
Query: rrefsqlj21571.dita
ScalarSubquery: rrefscalarsubquery.dita
TableSubquery: rreftablesubquery.dita

I took advantage of the opportunity for some formatting cleanup in some of the topics. I added examples for some. I believe some topics need more information, particularly SelectExpression, since it describes what all the clauses do. I'd like to know if what I've done so far is on the right track, though. Thanks!

Tuning Guide:

View flattening: ctuntransform22576.dita
Flattening a subquery into a normal join: ctuntransform36368.dita
Flattening a subquery into an EXISTS join: ctuntransform25868.dita



> 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
>         Attachments: DERBY-4518.diff, DERBY-4518.stat, DERBY-4518.zip
>
>
> 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.