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 "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2010/01/06 13:12:54 UTC
[jira] Created: (DERBY-4506) Document NATURAL JOIN in the reference
manual
Document NATURAL JOIN in the reference manual
---------------------------------------------
Key: DERBY-4506
URL: https://issues.apache.org/jira/browse/DERBY-4506
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.6.0.0
Reporter: Knut Anders Hatlen
When support for NATURAL JOIN syntax has been added (DERBY-4495), we should also add a section about it under "JOIN operations" in the reference manual.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-4506) Document NATURAL JOIN in the reference
manual
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen closed DERBY-4506.
-------------------------------------
Issue & fix info: (was: [Patch Available])
Fix Version/s: 10.6.0.0
Resolution: Fixed
Thanks, Kim and Rick. Committed revision 937168.
> Document NATURAL JOIN in the reference manual
> ---------------------------------------------
>
> Key: DERBY-4506
> URL: https://issues.apache.org/jira/browse/DERBY-4506
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Fix For: 10.6.0.0
>
> Attachments: naturaljoin.diff, rrefsqlj29840.html, rrefsqljnaturaljoin.html
>
>
> When support for NATURAL JOIN syntax has been added (DERBY-4495), we should also add a section about it under "JOIN operations" in the reference manual.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-4506) Document NATURAL JOIN in the
reference manual
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen reassigned DERBY-4506:
-----------------------------------------
Assignee: Knut Anders Hatlen
> Document NATURAL JOIN in the reference manual
> ---------------------------------------------
>
> Key: DERBY-4506
> URL: https://issues.apache.org/jira/browse/DERBY-4506
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
>
> When support for NATURAL JOIN syntax has been added (DERBY-4495), we should also add a section about it under "JOIN operations" in the reference manual.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4506) Document NATURAL JOIN in the
reference manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12859934#action_12859934 ]
Kim Haase commented on DERBY-4506:
----------------------------------
Thanks very much, Knut -- the patch looks great.
> Document NATURAL JOIN in the reference manual
> ---------------------------------------------
>
> Key: DERBY-4506
> URL: https://issues.apache.org/jira/browse/DERBY-4506
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Attachments: naturaljoin.diff, rrefsqlj29840.html, rrefsqljnaturaljoin.html
>
>
> When support for NATURAL JOIN syntax has been added (DERBY-4495), we should also add a section about it under "JOIN operations" in the reference manual.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4506) Document NATURAL JOIN in the reference
manual
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-4506:
--------------------------------------
Attachment: natural_fix1.diff
rrefsqljnaturaljoin.html
Here's a followup patch (natural_fix1.diff) that removes the mentioning of first/left table in the description of how * expands to the common columns. Also added a note about how unqualified references to common columns are resolved.
> Document NATURAL JOIN in the reference manual
> ---------------------------------------------
>
> Key: DERBY-4506
> URL: https://issues.apache.org/jira/browse/DERBY-4506
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Fix For: 10.6.0.0
>
> Attachments: natural_fix1.diff, naturaljoin.diff, rrefsqlj29840.html, rrefsqljnaturaljoin.html, rrefsqljnaturaljoin.html
>
>
> When support for NATURAL JOIN syntax has been added (DERBY-4495), we should also add a section about it under "JOIN operations" in the reference manual.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-4506) Document NATURAL JOIN in the
reference manual
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen resolved DERBY-4506.
---------------------------------------
Resolution: Fixed
Committed revision 937962.
Marking as resolved again.
> Document NATURAL JOIN in the reference manual
> ---------------------------------------------
>
> Key: DERBY-4506
> URL: https://issues.apache.org/jira/browse/DERBY-4506
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Fix For: 10.6.0.0
>
> Attachments: natural_fix1.diff, naturaljoin.diff, rrefsqlj29840.html, rrefsqljnaturaljoin.html, rrefsqljnaturaljoin.html
>
>
> When support for NATURAL JOIN syntax has been added (DERBY-4495), we should also add a section about it under "JOIN operations" in the reference manual.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4506) Document NATURAL JOIN in the reference
manual
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-4506:
--------------------------------------
Issue & fix info: [Patch Available]
> Document NATURAL JOIN in the reference manual
> ---------------------------------------------
>
> Key: DERBY-4506
> URL: https://issues.apache.org/jira/browse/DERBY-4506
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Attachments: naturaljoin.diff, rrefsqlj29840.html, rrefsqljnaturaljoin.html
>
>
> When support for NATURAL JOIN syntax has been added (DERBY-4495), we should also add a section about it under "JOIN operations" in the reference manual.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (DERBY-4506) Document NATURAL JOIN in the
reference manual
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen reopened DERBY-4506:
---------------------------------------
Reopening the issue because there's an error in the new topic: It says that the first columns in the expansion of an asterisk (*) are the common columns from the first/left table. This is only true for INNER and LEFT OUTER join. For RIGHT OUTER join, we'll take the common columns from the second/right table.
> Document NATURAL JOIN in the reference manual
> ---------------------------------------------
>
> Key: DERBY-4506
> URL: https://issues.apache.org/jira/browse/DERBY-4506
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Fix For: 10.6.0.0
>
> Attachments: naturaljoin.diff, rrefsqlj29840.html, rrefsqljnaturaljoin.html
>
>
> When support for NATURAL JOIN syntax has been added (DERBY-4495), we should also add a section about it under "JOIN operations" in the reference manual.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4506) Document NATURAL JOIN in the reference
manual
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-4506:
--------------------------------------
Attachment: naturaljoin.diff
rrefsqlj29840.html
rrefsqljnaturaljoin.html
The attached patch adds syntax description for the NATURAL JOIN operation and links to it from JOIN operations. I've also attached the resulting HTML files.
> Document NATURAL JOIN in the reference manual
> ---------------------------------------------
>
> Key: DERBY-4506
> URL: https://issues.apache.org/jira/browse/DERBY-4506
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Attachments: naturaljoin.diff, rrefsqlj29840.html, rrefsqljnaturaljoin.html
>
>
> When support for NATURAL JOIN syntax has been added (DERBY-4495), we should also add a section about it under "JOIN operations" in the reference manual.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4506) Document NATURAL JOIN in the
reference manual
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12859880#action_12859880 ]
Rick Hillegas commented on DERBY-4506:
--------------------------------------
Thanks for the patch Knut. It is clear and a quick sanity check verifies that it describes the actual behavior of Derby. I didn't check whether this behavior conforms to the SQL Standard. I assume it does and I'm sure that your buddy-tester, Dag, will verify that. +1 to commit these changes. Thanks.
> Document NATURAL JOIN in the reference manual
> ---------------------------------------------
>
> Key: DERBY-4506
> URL: https://issues.apache.org/jira/browse/DERBY-4506
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Attachments: naturaljoin.diff, rrefsqlj29840.html, rrefsqljnaturaljoin.html
>
>
> When support for NATURAL JOIN syntax has been added (DERBY-4495), we should also add a section about it under "JOIN operations" in the reference manual.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.