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] Commented: (DERBY-4399) Syntax description for TableViewOrFunctionExpression lack subquery option
Date Fri, 20 Nov 2009 00:24:39 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12780345#action_12780345
] 

Dag H. Wanvik commented on DERBY-4399:
--------------------------------------

Thanks!
The TableViewOrFunctionExpression should use the same term as the renamed topic (reference
from  TableViewOrFunctionExpression still uses plain "Correlation").

If you don't like the Correlation clause topic having no introductory text, maybe you can
just add the "Correlation clause" production to the topic for TableViewOrFunctionExpression
and retain the separate topic for correlation-name? I'm OK with either solution.

Perhaps we should also put "Correlation clause" into camel case: "CorrelationClause".


> 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
>         Attachments: DERBY-4399.diff, rrefcorrelationname.html, rrefsqlj33215.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.


Mime
View raw message