Unfortunately, I think I may need to use this version. I copied and pasted your query and replaced the RIDs with ones from the OUser table on a fresh DB. It still gave 0 results. Will see what I can do.
On Fri, Sep 5, 2014 at 6:26 PM, 'Curtis Mosters' via OrientDB < [email protected]> wrote: > 1.7.9 is not officially released. For me on 1.7.8 and also on 1.7.9 it > works. Maybe downgrade and open an issue in Github? > > Tested with > select expand( $c ) LET $a = (select from #11:1), $b = (select from > #11:0), $c = UNIONALL($a,$b) > > and also (2 identical results) > select expand( $c ) LET $a = (select from #11:1), $b = (select from > #11:1), $c = UNIONALL($a,$b) > > worked for me of Version 1.7.8 and 1.7.9. > Am Freitag, 5. September 2014 23:49:16 UTC+2 schrieb Simon L: > >> 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 a topic in the > Google Groups "OrientDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/orient-database/mRRmmL-MgsM/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- 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.
