Re: [eclipselink-users] UNION, INTERSECT in JPQL

[Tom Ware <tom.ware@xxxxxxxxxx>]

Hi Zarar,

  In general, the contents of JPQL are not up to us as a JPA implementer.  They 
are up to the JPA specification committee.  JPA 2.0 is in its final-draft-stage, 
so this would be something to request for the next JPA version.

  If there was enough customer interest, it is possible we would develop, at 
least, a native-API-based way of doing this.  Please feel free to enter an 
enhancement request and vote for it.

-Tom

Zarar Siddiqi wrote:
> I got it working through native queries, just felt a little dirty
> doing it since its the only place in the entire app JPQL is not used.
>
> Thanks, any plans on implementing this?
>
>
>
> On Tue, May 12, 2009 at 4:47 PM, Tom Ware <tom.ware@xxxxxxxxxx> wrote:
> > Hi Zarar,
> >
> >  Neither UNION nor INTERSECT is supported in JPQL in general.
> >
> >  Depending on the goal of your query, it may be possible to achieve what you
> > are looking for in some other way.
> >
> > -Tom
> >
> > Zarar Siddiqi wrote:
> > > Are these keywords supported in EclipseLink?
> > >
> > > I tried doing a simple SELECT p FROM Person INTERSECT SELECT p FROM
> > > Person and it couldn't parse it.  Couldn't find any examples in the
> > > docs. Possible or no?
> > >
> > > Thanks,
> > > Zarar
> > > _______________________________________________
> > > eclipselink-users mailing list
> > > eclipselink-users@xxxxxxxxxxx
> > > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> > _______________________________________________
> > eclipselink-users mailing list
> > eclipselink-users@xxxxxxxxxxx
> > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users