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 2009/11/19 17:31:39 UTC
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12780134#action_12780134 ]
Kim Haase commented on DERBY-4399:
----------------------------------
I've been meaning to pick this up for weeks, so I thought I'd better start on it.
I'm wondering if I should retitle the correlation-Name topic Correlation and rewrite it, or whether we need a new Correlation topic in between the TableViewOrFunctionExpression topic and the correlation-Name topic. Rewriting the correlation-Name topic might be simpler.
TableViewOrFunctionExpression: http://db.apache.org/derby/docs/dev/ref/rrefsqlj33215.html
correlation-Name: http://db.apache.org/derby/docs/dev/ref/rrefcorrelationname.html
In either case I need a definition of the term "Correlation" -- can you help me out, Dag or Knut? Thanks!
> 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
> Reporter: Dag H. Wanvik
>
> 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.