Hi Gianluigi, This is correct. out() function return a collection of values.
Best Regards, Luca Garulli Founder & CEO OrientDB <http://orientdb.com/> On 8 August 2015 at 11:54, Gianluigi Belli <[email protected]> wrote: > > Hi all. > Background: Orientdb2.1 with strictsql enabled. > > I have embedded fields with subdocuments. Sometime a key of those > documents is composed just by numeric characters. > > eg: > { > "@type": "d", > "@version": 0, > "type": "document", > "apps": { > "main": { > "0": "2", > "9": "1" > }, > "tommy": { > "0": "0", > "32": "0" > }, > "jericho": { > "1": "0" > } > } > } > > > > If I want to query those documents through dot notation > > eg: > select out('hasSysUsersRole').sa_rules.apps.main.0 from #12:2 > > > > I get the following error: > > *com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error > on parsing command at position #0: Encountered " <FLOATING_POINT_LITERAL> > ".0 "" at line 1, column 49. Was expecting one of: <EOF> <TIMEOUT> ... <AS> > ... <FETCHPLAN> ... <LOCK> ... <LET> ... <NOCACHE> ... <PARALLEL> ... > <UNWIND> ... ";" ... "," ... <AS> ... "," ... * > > If I include the numeric keys in square brackets (like if it was an array > but is not) it works without errors. > > eg: > select out('hasSysUsersRole').sa_rules.apps.main[0] from #12:2 > > > > Is it the correct behavior? > > Thanks > > -- > > --- > 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.
