Yap, also just in case there is anything with the OUser. But also works on them.
select expand( $c ) LET $a = (select from #5:0), $b = (select from #5:1), $c = UNIONALL($a,$b) 2 results: #5:0 <http://localhost:2480/studio/index.html#/database/Test6x%20save%20this%21/browse/edit/5:0> 1OUser - #4:0 <http://localhost:2480/studio/index.html#/database/Test6x%20save%20this%21/browse/edit/4:0> ACTIVE {SHA-256}8C6976E5B5410415BDE908BD4DEE15DFB167A9C873FC4BB8A81F6F2AB448A918 admin #5:1 <http://localhost:2480/studio/index.html#/database/Test6x%20save%20this%21/browse/edit/5:1> 1OUser - #4:1 <http://localhost:2480/studio/index.html#/database/Test6x%20save%20this%21/browse/edit/4:1> ACTIVE {SHA-256}3D0941964AA3EBDCB00CCEF58B1BB399F9F898465E9886D5AEC7F31090A0FB30 readerYeah or just reinstall. Give some feedback what helped you =) Am Samstag, 6. September 2014 00:37:06 UTC+2 schrieb Simon L: > > 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] <javascript:>> 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] <javascript:>. >> 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.
