JCR-SQL2 UNION

[Paulo Carapinha <pa...@gmail.com>]

Hi,

I´m trying to make a simple example with UNION and JCR-SQL2 but apparently
is not supported, how could i reach an workaround?

Regards,

-- 
Paulo

Re: JCR-SQL2 UNION

[Jukka Zitting <ju...@gmail.com>]

Hi,

On Mon, Oct 3, 2011 at 10:46 AM, Paulo Carapinha
<pa...@gmail.com> wrote:
> Thanks for the reply, there is a way to check if a property does not exist
> in a JCR-SQL2 statement?

Yes, see the "IS NOT NULL" and "IS NULL" constraints [1].

[1] http://www.day.com/specs/jcr/2.0/6_Query.html#6.7.18%20PropertyExistence

BR,

Jukka Zitting

Re: JCR-SQL2 UNION

[Paulo Carapinha <pa...@gmail.com>]

Thanks for the reply, there is a way to check if a property does not exist
in a JCR-SQL2 statement?

On Mon, Oct 3, 2011 at 9:21 AM, Jukka Zitting <ju...@gmail.com>wrote:

> Hi,
>
> On Sun, Oct 2, 2011 at 7:12 PM, Paulo Carapinha
> <pa...@gmail.com> wrote:
> > I´m trying to make a simple example with UNION and JCR-SQL2 but
> > apparently is not supported, how could i reach an workaround?
>
> Yes, unfortunately union queries are not supported. Any work on that
> area would be much appreciated.
>
> Meanwhile the best workaround is probably to do two separate queries
> and to explicitly perform the union in the application code by
> combining the two result sets.
>
> BR,
>
> Jukka Zitting
>



-- 
Paulo

Re: JCR-SQL2 UNION

[Jukka Zitting <ju...@gmail.com>]

Hi,

On Sun, Oct 2, 2011 at 7:12 PM, Paulo Carapinha
<pa...@gmail.com> wrote:
> I´m trying to make a simple example with UNION and JCR-SQL2 but
> apparently is not supported, how could i reach an workaround?

Yes, unfortunately union queries are not supported. Any work on that
area would be much appreciated.

Meanwhile the best workaround is probably to do two separate queries
and to explicitly perform the union in the application code by
combining the two result sets.

BR,

Jukka Zitting