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 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.
