This Bugzilla instance is deprecated, and most Eclipse projects now use GitHub or Eclipse GitLab. Please see the deprecation plan for details.
Bug 276147 - Support UNION and INTERSECT in JPQL
Summary: Support UNION and INTERSECT in JPQL
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 enhancement with 1 vote (vote)
Target Milestone: ---   Edit
Assignee: James Sutherland CLA
QA Contact:
URL:
Whiteboard:
Keywords:
: 276146 (view as bug list)
Depends on:
Blocks:
 
Reported: 2009-05-13 13:31 EDT by Zarar Siddiqi CLA
Modified: 2022-06-09 10:04 EDT (History)
3 users (show)

See Also:

Attachments
adds union,intersect,except and regexp support (98.80 KB, patch)
2012-04-12 11:06 EDT, James Sutherland CLA 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Zarar Siddiqi CLA 2009-05-13 13:31:48 EDT 
More here:

http://www.nabble.com/UNION%2C-INTERSECT-in-JPQL-to23510002.html
Comment 1 Tom Ware CLA 2009-05-13 14:57:11 EDT 
*** Bug 276146 has been marked as a duplicate of this bug. ***
Comment 2 Oliver Snowden CLA 2009-05-26 09:17:47 EDT 
Agree that it should become part of the spec. but maybe the requirement would be better met via JPQL extensions, see bug 219814.

Also see http://www.eclipse.org/newsportal/article.php?id=848&group=eclipse.rt.eclipselink#848.

It might be better to generalise this subject under the title 'Spatial JPQL Operators' or similar.
Comment 3 Tom Ware CLA 2009-05-26 09:37:18 EDT 
I beleive this bug is for the set Operators, UNION and INTERSECT and not related to spatial funcitonality.
Comment 4 James Sutherland CLA 2012-04-12 11:06:45 EDT 
Created attachment 213905 [details]
adds union,intersect,except and regexp support
Comment 5 James Sutherland CLA 2012-04-16 13:31:24 EDT 
SVN trunk commit: Bug#276147 – Unions

https://bugs.eclipse.org/bugs/show_bug.cgi?id=276147

https://bugs.eclipse.org/bugs/show_bug.cgi?id=376215

Adds support for UNION, INTERSECT, EXCEPT operations to Expressions and JPQL.
Adds support for REGEXP operation for regular expression comparisons.

Changes:
-	Adds core Expression/Query tests for regexp and unions.
-	Adds Hermes JPQL support for RegexpExpression and UnionClause.
-	Add None JPQL validation option.
-	Add regexp and union, intersect, except support to expressions, queries.
-	Add conforming support for regexp.
-	Add JPA JPQL tests for regexp, unions.
-	Fix NoSQL connection spec properties to try both class loaders.
Comment 6 James Sutherland CLA 2012-04-19 10:04:16 EDT 
fixed
Comment 7 Eclipse Webmaster CLA 2022-06-09 10:04:37 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink