Issue Details (XML | Word | Printable)

Key: DERBY-155
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Unassigned
Reporter: Jeremy Boynes
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

Add DISTINCT keyword support to INTERSECT and EXCEPT

Created: 01/Mar/05 03:21 AM   Updated: 01/Mar/05 08:32 AM
Return to search
Component/s: SQL
Affects Version/s: 10.1.1.0
Fix Version/s: 10.1.1.0

Time Tracking:
Not Specified

Resolution Date: 01/Mar/05 08:31 AM


 Description  « Hide
Support the syntax

INTERSECT [ALL | DISTINCT] and EXCEPT [ALL | DISTINCT]

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Repository Revision Date User Message
ASF #155715 Mon Feb 28 23:30:04 UTC 2005 jboynes fix for DERBY-155 allow distinct in union/intersect/except
Files Changed
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/union.sql
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/intersect.sql
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/union.out
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/intersect.out
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj

Jeremy Boynes made changes - 01/Mar/05 06:46 AM
Field Original Value New Value
Assignee Jeremy Boynes [ jboynes ]
[ Permlink | « Hide ]
Jeremy Boynes added a comment - 01/Mar/05 08:31 AM
Sending java\engine\org\apache\derby\impl\sql\compile\sqlgrammar.jj
Sending java\testing\org\apache\derbyTesting\functionTests\master\intersect.out
Sending java\testing\org\apache\derbyTesting\functionTests\master\union.out
Sending java\testing\org\apache\derbyTesting\functionTests\tests\lang\intersect.sql
Sending java\testing\org\apache\derbyTesting\functionTests\tests\lang\union.sql
Transmitting file data .....
Committed revision 155715.

Jeremy Boynes made changes - 01/Mar/05 08:31 AM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Fix Version/s 10.1.0.0 [ 10993 ]
Jeremy Boynes made changes - 01/Mar/05 08:32 AM
Status Resolved [ 5 ] Closed [ 6 ]
Assignee Jeremy Boynes [ jboynes ]

Powered by a free Atlassian JIRA open source license for Apache Software Foundation. Try JIRA - bug tracking software for your team.
Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.2-#335) - Bug/feature request - Atlassian news - Contact Administrators