Current behavior could also be useful. Lets rename current one to "unionAll()" and create true "union()" that removes duplication.
Best regards, Artem Orobets * Orient Technologiesthe Company behind OrientDB* 2014/1/21 Luca Garulli <[email protected]> > This seems a bug. Please could you open a new issue for that? > > https://github.com/orientechnologies/orientdb/issues/new > > Lvc@ > > > > On 21 January 2014 12:37, Vishnu Govind <[email protected]> wrote: > >> Also it is adding a null record at the end of the list. >> >> >> On Friday, August 2, 2013 9:58:37 PM UTC+5:30, Lvc@ wrote: >> >>> Hi, >>> this is not supported, so you've to execute them as separate query and >>> then join the result using the UNION: >>> >>> select expand( $c ) let $a = ( select from E ), $b = ( select from V ), >>> $c = union( $a, $b ) >>> >>> Lvc@ >>> >>> PS: I found a small bug on union now fixed in 1.6.0-SNAPSHOT. >>> >>> >>> On 2 August 2013 10:40, dabro <[email protected]> wrote: >>> >>>> Hi >>>> When I execute query: >>>> >>>> select from OUser, V, E >>>> >>>> I get this error as result: >>>> >>>> Error: >>>> com.orientechnologies.orient.core.sql.OCommandSQLParsingException: >>>> Error on parsing command at position #17: Invalid keyword 'V' >>>> Command: select from OUser, V, E >>>> -------------------------^ >>>> >>>> Is it possible to get result from multiple tables? >>>> I use OrientDB 1.5 >>>> >>>> -- >>>> >>>> --- >>>> 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/groups/opt_out. >>>> >>>> >>>> >>> >>> -- >> >> --- >> 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/groups/opt_out. >> > > -- > > --- > 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/groups/opt_out. > -- --- 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/groups/opt_out.
