NOTE: This union statement isn't working either:
select expand( $c ) LET $a = (select from #32:2), $b = (select from #32:2), 
$c = UNIONALL($a,$b)
OrientDB version: Server v1.7.9-SNAPSHOT 

On Friday, September 5, 2014 9:41:53 AM UTC-4, Simon L wrote:
>
> Hi everyone.
>
> The following query was working fine for a while. Then, I did a major DB 
> update where the schema and other things were changed. I also updated ODB. 
> Now, it returns 0 objects for some reason:
>
> SELECT expand($c) LET $a = ( SELECT @rid as @rid, @class as @class FROM 
> (SELECT expand(out()) FROM #25:5632 )), $b = ( select * from #25:5632 ), $c 
> = UNIONALL( $a, $b )
>
> 0 Item(s) found.
>
> It used to return something like:
> #34:12, SomeClassName
> #34:13, SomeClassName
> #25:5632, property1, property2, property3
>
> It's possible I accidentally made a small change to the query, but I don't 
> recall.
>
> When I take each part of the query outside the UNIONALL/LET, then 
> individually they work fine.
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to