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 "Dag H. Wanvik (JIRA)" <ji...@apache.org> on 2009/10/06 03:31:31 UTC
[jira] Created: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
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 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762664#action_12762664 ]
Dag H. Wanvik commented on DERBY-4399:
--------------------------------------
Good catch. Actually, this applies for TableFunctionInvocation and the undocumented "new <diagnotics VTI classname>()" syntax, too.
> 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.
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12780686#action_12780686 ]
Kim Haase commented on DERBY-4399:
----------------------------------
The new patch is DERBY-4399-2.diff. To avoid confusion, I removed the correlation-name topic that was modified for the first patch.
> 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-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.
[jira] Assigned: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase reassigned DERBY-4399:
--------------------------------
Assignee: Kim Haase
> 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
> Assignee: Kim Haase
>
> 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.
[jira] Closed: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase closed DERBY-4399.
----------------------------
Fix appeared in online docs long ago, so closing.
> 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.1.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.
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12780699#action_12780699 ]
Dag H. Wanvik commented on DERBY-4399:
--------------------------------------
+1 to commit.
> 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-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.
[jira] Updated: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4399:
-----------------------------
Attachment: rrefsqlj33215.html
rrefcorrelationname.html
DERBY-4399.diff
Uploading patch, and 2 HTML files (one more to come).
M src/ref/rrefcorrelationname.dita
M src/ref/rreftableexpression.dita
M src/ref/rrefsqlj33215.dita
Made some formatting fixes too. Hope they are not too much clutter.
> 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
> 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.
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12780179#action_12780179 ]
Dag H. Wanvik commented on DERBY-4399:
--------------------------------------
Thanks for picking this one up, Kim. I think it's ok to use the existing topic.
I suggest renaming "correlation" to "correlation clause", and present the syntax in the (renamed) topic, but not give any specific definition to that term (a clause is a grammar entity); just keep the current explanation for correlation-name.
> 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
> Assignee: Kim Haase
>
> 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.
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762787#action_12762787 ]
Dag H. Wanvik commented on DERBY-4399:
--------------------------------------
Does this look right? I think it's more readable to factor out the correlation, e.g. as:
TableViewOrFunctionExpression:
{
{ table-Name | view-Name }
[ Correlation ]
|
{ TableSubquery | TableFunctionInvocation }
Correlation
}
Correlation:
[ AS ]
correlation-Name
[ ( Simple-column-Name [ , Simple-column-Name ]* ) ]
> 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.
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762893#action_12762893 ]
Knut Anders Hatlen commented on DERBY-4399:
-------------------------------------------
Looks correct to me. Factoring out the correlation sounds like a good idea. 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.
[jira] Resolved: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4399:
-----------------------------
Issue & fix info: [Patch Available]
Affects Version/s: 10.5.3.0
> 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.
[jira] Updated: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4399:
-----------------------------
Attachment: (was: rrefcorrelationname.html)
> 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-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.
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762626#action_12762626 ]
Knut Anders Hatlen commented on DERBY-4399:
-------------------------------------------
Isn't the correlation-Name required when you have a TableSubquery in a FROM clause? The suggested change will describe it as optional.
> 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.
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4399:
-----------------------------
Attachment: rreftableexpression.html
rrefsqlj33215.html
DERBY-4399-2.diff
Thanks, Dag! I've adopted your suggestion of leaving the correlation-name topic as it was and adding the production to the revised TableViewOrFunctionExpression syntax topic. I'm attaching a new patch file with those changes only.
M src/ref/rreftableexpression.dita
M src/ref/rrefsqlj33215.dita
> 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-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.
[jira] Updated: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-4399:
-----------------------------
Attachment: rreftableexpression.html
Other HTML file.
> 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
> 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.
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (DERBY-4399) Syntax description for
TableViewOrFunctionExpression lack subquery option
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12780208#action_12780208 ]
Kim Haase commented on DERBY-4399:
----------------------------------
Thanks, Dag! If we rename the topic, then maybe I should move it from its current location under "SQL identifiers" to under "SQL clauses"? But all the other clauses have introductory material. I'll post a patch without moving it and then we can think about it some more.
> 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
> Assignee: Kim Haase
>
> 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.