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.
