[#DERBY-155] Add DISTINCT keyword support to INTERSECT and EXCEPT

Derby

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:

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