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] Updated: (DERBY-4399) Syntax description for TableViewOrFunctionExpression lack subquery option
Date Tue, 06 Oct 2009 01:31:31 GMT

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

Dag H. Wanvik updated DERBY-4399:
---------------------------------

    Description: 
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.

  was:
In the reference manual, we find these syntax description (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.


> 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.


Mime
View raw message