Fixed thanks. Both first() and last() functions works in non-aggregate mode.
Lvc@ On 17 January 2015 at 13:39, syshex <[email protected]> wrote: > https://github.com/orientechnologies/orientdb/issues/3416 > > On Saturday, January 17, 2015 at 12:32:21 PM UTC, syshex wrote: >> >> Sure, will do that. >> >> On 16 January 2015 at 23:20, Luca Garulli wrote: >> >>> Hi guys, >>> I think you are right: first shouldn't return one record at all, but >>> rather return the first element in a multi-value (array, list, set, map). >>> >>> Please could you open a new issue for that? >>> >>> Lvc@ >>> >>> >>> On 16 January 2015 at 20:09, syshex wrote: >>> >>>> Hi Marcel >>>> >>>> The [0] notation works like you said >>>> >>>> The other try, with the null being passed as an argument fails with an >>>> exception : >>>> >>>> com.orientechnologies.orient.core.exception.OCommandExecutionException: >>>> Syntax error: function 'first' needs 1 argument(s) while has been received >>>> 2 >>>> >>>> apparently first only accepts one argument. >>>> >>>> the [x] notation will do for now. It just surprised me to see first() >>>> behaving like that. >>>> >>>> Thanks so much for your help >>>> >>>> >>>> On Friday, January 16, 2015 at 2:34:51 PM UTC, Marcel Pitch wrote: >>>>> >>>>> In my first queries, I've encountered the same problem. That's why I >>>>> use now the '[0]' code. >>>>> >>>>> But I was just reading the OrientDB *Functions *documentation. >>>>> >>>>> And I saw that : >>>>> >>>>> "In case you need to use a function as inline when you've only one >>>>> parameter, then add a second one like "null": >>>>> >>>>> >>>>> SELECT first( out('friends').name, null ) as firstFriend FROM Profiles >>>>> >>>>> >>>>> >>>>> In this case first() function doesn't aggregate everything in only one >>>>> record, but returns one record per Profile where the firstFriend is the >>>>> first item of the collection received as parameter." >>>>> >>>>> >>>>> Maybe you could try it ? >>>>> >>>> -- >>>> >>>> --- >>>> 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. >>>> >>> >>> -- >>> >>> --- >>> 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/fbZEimTyJjM/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> 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. > -- --- 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.
