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 "Jeff Levitt (JIRA)" <de...@db.apache.org> on 2005/05/13 02:17:33 UTC
[jira] Created: (DERBY-278) Document INTERSECT and EXCEPT operations
Document INTERSECT and EXCEPT operations
----------------------------------------
Key: DERBY-278
URL: http://issues.apache.org/jira/browse/DERBY-278
Project: Derby
Type: Task
Components: Documentation
Environment: All
Reporter: Jeff Levitt
Assigned to: Jeff Levitt
Priority: Minor
Fix For: 10.1.0.0
Currently the documentation does not discuss using INTERSECT and EXCEPT in queries. We just added the DISTINCT keyword recently to those operations as well as to the UNION operation, so I will attempt to document the DISTINCT keyword for UNION, and add the INTERSECT and EXCEPT syntax as I go along.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Re: [jira] Updated: (DERBY-278) Document INTERSECT and EXCEPT operations
Posted by Jack Klebanoff <kl...@sbcglobal.net>.
Jeff Levitt (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/DERBY-278?page=all ]
>
>Jeff Levitt updated DERBY-278:
>------------------------------
>
> Attachment: intersectdocsupdate.zip
>
>The new zip file attached (intersectdocsupdate.zip) includes a new patch incorporating all of Jack's feedback. It also includes new html output files for review. Please let me know if you would like any more changes, and if there are no further changes from anyone, can a committer please commit this? Thanks!
>
>
>
I did a quick scan. It looked OK to me.
Jack
[jira] Updated: (DERBY-278) Document INTERSECT and EXCEPT operations
Posted by "Jeff Levitt (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-278?page=all ]
Jeff Levitt updated DERBY-278:
------------------------------
Attachment: intersectdocsupdate.zip
The new zip file attached (intersectdocsupdate.zip) includes a new patch incorporating all of Jack's feedback. It also includes new html output files for review. Please let me know if you would like any more changes, and if there are no further changes from anyone, can a committer please commit this? Thanks!
> Document INTERSECT and EXCEPT operations
> ----------------------------------------
>
> Key: DERBY-278
> URL: http://issues.apache.org/jira/browse/DERBY-278
> Project: Derby
> Type: Task
> Components: Documentation
> Environment: All
> Reporter: Jeff Levitt
> Assignee: Jeff Levitt
> Priority: Minor
> Fix For: 10.1.0.0
> Attachments: intersectdocsupdate.zip
>
> Currently the documentation does not discuss using INTERSECT and EXCEPT in queries. We just added the DISTINCT keyword recently to those operations as well as to the UNION operation, so I will attempt to document the DISTINCT keyword for UNION, and add the INTERSECT and EXCEPT syntax as I go along.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-278) Document INTERSECT and EXCEPT operations
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-278?page=comments#action_12313055 ]
Jean T. Anderson commented on DERBY-278:
----------------------------------------
Jack Klebanoff <kl...@sbcglobal.net> reviewed the patch and marked it "OK", see http://mail-archives.apache.org/mod_mbox/db-derby-dev/200506.mbox/%3c42A65562.6090601@sbcglobal.net%3e .
> Document INTERSECT and EXCEPT operations
> ----------------------------------------
>
> Key: DERBY-278
> URL: http://issues.apache.org/jira/browse/DERBY-278
> Project: Derby
> Type: Task
> Components: Documentation
> Environment: All
> Reporter: Jeff Levitt
> Assignee: Jeff Levitt
> Priority: Minor
> Fix For: 10.1.0.0
> Attachments: intersectdocsupdate.zip
>
> Currently the documentation does not discuss using INTERSECT and EXCEPT in queries. We just added the DISTINCT keyword recently to those operations as well as to the UNION operation, so I will attempt to document the DISTINCT keyword for UNION, and add the INTERSECT and EXCEPT syntax as I go along.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Closed: (DERBY-278) Document INTERSECT and EXCEPT operations
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-278?page=all ]
Jean T. Anderson closed DERBY-278:
----------------------------------
Resolution: Fixed
Committed, revision 189592, Jeff Levitt's patch that adds documentation for INTERSECT and EXCEPT. Here's a list of the files that changed:
M src/tuning/ctuntransform14044.dita
M src/ref/rrefselectexpression.dita
M src/ref/DitaLink.cat
M src/ref/rrefsqlj21571.dita
M src/ref/rrefsql9241891.dita
M src/ref/rrefsqlj1083019.dita
M src/ref/rrefsqlj41360.dita
M src/ref/rrefso2.dita
M src/devguide/cdevstandards806001.dita
> Document INTERSECT and EXCEPT operations
> ----------------------------------------
>
> Key: DERBY-278
> URL: http://issues.apache.org/jira/browse/DERBY-278
> Project: Derby
> Type: Task
> Components: Documentation
> Environment: All
> Reporter: Jeff Levitt
> Assignee: Jeff Levitt
> Priority: Minor
> Fix For: 10.1.0.0
> Attachments: intersectdocsupdate.zip
>
> Currently the documentation does not discuss using INTERSECT and EXCEPT in queries. We just added the DISTINCT keyword recently to those operations as well as to the UNION operation, so I will attempt to document the DISTINCT keyword for UNION, and add the INTERSECT and EXCEPT syntax as I go along.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-278) Document INTERSECT and EXCEPT operations
Posted by "Jeff Levitt (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-278?page=comments#action_65517 ]
Jeff Levitt commented on DERBY-278:
-----------------------------------
Could someone possibly review this so we can commit if all is OK? Thanks!
> Document INTERSECT and EXCEPT operations
> ----------------------------------------
>
> Key: DERBY-278
> URL: http://issues.apache.org/jira/browse/DERBY-278
> Project: Derby
> Type: Task
> Components: Documentation
> Environment: All
> Reporter: Jeff Levitt
> Assignee: Jeff Levitt
> Priority: Minor
> Fix For: 10.1.0.0
> Attachments: intersectdocs.zip
>
> Currently the documentation does not discuss using INTERSECT and EXCEPT in queries. We just added the DISTINCT keyword recently to those operations as well as to the UNION operation, so I will attempt to document the DISTINCT keyword for UNION, and add the INTERSECT and EXCEPT syntax as I go along.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-278) Document INTERSECT and EXCEPT operations
Posted by "Jack Klebanoff (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-278?page=comments#action_65623 ]
Jack Klebanoff commented on DERBY-278:
--------------------------------------
There is a problem in document rrefsqlj1083019.html. Item 4 reads:
"... in rule rrefsqlj1083019.html#rrefsqlj1083019__sqlj30695". I think that we need a more descriptive text for the link.
Document rrefsqlj21571.html is incorrect about the precedence of the intersect, except, and union operators. It confuses precedence with the number of duplicates in the output. The document states "... INTERSECT, EXCEPT, or UNION operations. These operations are evaluated from left to right when no parentheses are present". This is incorrect. In the absence of parentheses INTERSECTs are evaluated before EXCEPT, or UNION operations, but EXCEPT and UNION operations are evaluated from left to right. That is, INTERSECT has higher precedence than EXCEPT or UNION and EXCEPT and UNION have the same precedence.
The sentence "You can combine two queries into one using the ALL parameter" is misleading. The set operators combine two queries into one with or without the ALL parameter. Change the sentence to something like: "The ALL and DISTINCT keywords determine whether duplicates are eliminated from the result. If you specify DISTINCT then there will be no duplicate rows in the result. If you specify ALL then there may be duplicates in the result, depending on whether there were duplicates in the input. DISTINCT is the default: if you specify neither ALL nor DISTINCT then duplicates will be eliminated".
The next section in rrefsqlj21571.html is titled "Precedence of UNION, INTERSECT, and EXCEPT" and starts with "There are rules of precedence in how many duplicates will be contained...". Precedence has nothing to do with the number of duplicates in the output. Change the title to "Duplicates in UNION/INTERSECT/EXCEPT ALL". Include the previous paragraph in this section. Remove the sentence "There are rules of precedence ..."
I think that the examples in rrefsqlj21571.html should have a header, e.g. "Examples". My first thought was that the examples were part of the discussion of the number of duplicates. A header would separate the two.
> Document INTERSECT and EXCEPT operations
> ----------------------------------------
>
> Key: DERBY-278
> URL: http://issues.apache.org/jira/browse/DERBY-278
> Project: Derby
> Type: Task
> Components: Documentation
> Environment: All
> Reporter: Jeff Levitt
> Assignee: Jeff Levitt
> Priority: Minor
> Fix For: 10.1.0.0
> Attachments: intersectdocs.zip
>
> Currently the documentation does not discuss using INTERSECT and EXCEPT in queries. We just added the DISTINCT keyword recently to those operations as well as to the UNION operation, so I will attempt to document the DISTINCT keyword for UNION, and add the INTERSECT and EXCEPT syntax as I go along.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-278) Document INTERSECT and EXCEPT operations
Posted by "Jeff Levitt (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-278?page=all ]
Jeff Levitt updated DERBY-278:
------------------------------
Attachment: intersectdocs.zip
Here is the patch zipped up with the relevant output HTML files for review. Please let me know if anyone would like any modifications.
> Document INTERSECT and EXCEPT operations
> ----------------------------------------
>
> Key: DERBY-278
> URL: http://issues.apache.org/jira/browse/DERBY-278
> Project: Derby
> Type: Task
> Components: Documentation
> Environment: All
> Reporter: Jeff Levitt
> Assignee: Jeff Levitt
> Priority: Minor
> Fix For: 10.1.0.0
> Attachments: intersectdocs.zip
>
> Currently the documentation does not discuss using INTERSECT and EXCEPT in queries. We just added the DISTINCT keyword recently to those operations as well as to the UNION operation, so I will attempt to document the DISTINCT keyword for UNION, and add the INTERSECT and EXCEPT syntax as I go along.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira