Hi Artem, you're right: http://stackoverflow.com/questions/4127714/remove-duplicates-from-sql-union
Who can open the issue? Lvc@ On 21 January 2014 15:23, Artem Orobets <[email protected]> wrote: > 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. > -- --- 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.
