https://github.com/orientechnologies/orientdb/issues/1984
Best regards, Artem Orobets * Orient Technologiesthe Company behind OrientDB* 2014/1/21 Luca Garulli <[email protected]> > 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. > -- --- 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.
