Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1654211641.1258744660712.JavaMail.jira@brutus>
Date: Fri, 20 Nov 2009 19:17:40 +0000 (UTC)
From: "Kim Haase (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Resolved: (DERBY-4399) Syntax description for
 TableViewOrFunctionExpression lack subquery option
In-Reply-To: <1114935702.1254792691266.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Kim Haase resolved DERBY-4399.
------------------------------

          Resolution: Fixed
       Fix Version/s: 10.6.0.0
    Issue & fix info:   (was: [Patch Available])

Thanks very much, Dag.

Committed patch DERBY-4399-2.diff to documentation trunk at revision 882686. 

> Syntax description for TableViewOrFunctionExpression lack subquery option
> -------------------------------------------------------------------------
>
>                 Key: DERBY-4399
>                 URL: https://issues.apache.org/jira/browse/DERBY-4399
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.5.3.0
>            Reporter: Dag H. Wanvik
>            Assignee: Kim Haase
>             Fix For: 10.6.0.0
>
>         Attachments: DERBY-4399-2.diff, DERBY-4399.diff, rrefsqlj33215.html, rrefsqlj33215.html, rreftableexpression.html, rreftableexpression.html
>
>
> In the reference manual, we find these syntax descriptions (start with http://db.apache.org/derby/docs/dev/ref/rrefsqlj21583.html):
> TableExpression:
> {
>   TableViewOrFunctionExpression | JOIN operation 
> }
> TableViewOrFunctionExpression:
> { table-Name | view-Name | TableFunctionInvocation}
>     [ [ AS ] correlation-Name
>         [ (Simple-column-Name [ , Simple-column-Name]* ) ] ] ]
> I cannot find a way from the "FROM clause" to the TableSubquery production, so I think the latter should read:
> { table-Name | TableSubquery | view-Name | TableFunctionInvocation }
>     [ [ AS ] correlation-Name
>         [ (Simple-column-Name [ , Simple-column-Name]* ) ] ] ]
> Also, the "JOIN operation" is not clickable.

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