When I post the following JSON to http://localhost:2480/batch/testdb:
{
"transaction": false,
"operations":[
{
"type": "cmd",
"language": "sql",
"command": "select from comment fetchplan Replies:1000 where
@rid=#13:11"
}
]
}
The following output is returned:
{
"result": [
{
"@type": "d",
"@rid": "#13:11",
"@version": 2,
"@class": "Comment",
"EditText": "main comment",
"Replies": [
"#13:1",
"#13:3",
"#13:4",
"#13:5",
"#13:10"
]
}
]
}
When I send(POST) the following command
to http://localhost:2480/command/testdb/sql
select from comment fetchplan Replies:1000 where @rid=#13:11
The following output is returned:
{
"result": [
{
"@type": "d",
"@rid": "#13:11",
"@version": 2,
"@class": "Comment",
"EditText": "main comment",
"Replies": [
{
"@type": "d",
"@rid": "#13:1",
"@version": 4,
"@class": "Comment",
"EditText": "Comment A",
"Replies": [
{
"@type": "d",
"@rid": "#13:2",
"@version": 2,
"@class": "Comment",
"EditText": "Comment A.1",
"ParentComment": "#13:1"
}
]
},
{
"@type": "d",
"@rid": "#13:3",
"@version": 2,
"@class": "Comment",
"EditText": "Comment B"
},
{
"@type": "d",
"@rid": "#13:4",
"@version": 2,
"@class": "Comment",
"EditText": "Comment C"
},
{
"@type": "d",
"@rid": "#13:5",
"@version": 3,
"@class": "Comment",
"EditText": "Comment D",
"Replies": [
{
"@type": "d",
"@rid": "#13:6",
"@version": 3,
"@class": "Comment",
"EditText": "Comment D.1",
"ParentComment": "#13:5"
},
{
"@type": "d",
"@rid": "#13:7",
"@version": 4,
"@class": "Comment",
"EditText": "Comment D.2",
"Replies": [
{
"@type": "d",
"@rid": "#13:8",
"@version": 3,
"@class": "Comment",
"EditText": "Comment D.2.1",
"ParentComment": "#13:7"
}
],
"ParentComment": "#13:5"
},
{
"@type": "d",
"@rid": "#13:9",
"@version": 3,
"@class": "Comment",
"EditText": "Comment D.3",
"ParentComment": "#13:5"
}
]
},
{
"@type": "d",
"@rid": "#13:10",
"@version": 2,
"@class": "Comment",
"EditText": "Comment E"
}
]
}
]
}
The first one is unexpected, the second one is the output I expect. It
seems the fetchplan is not used when in batch mode???
--
---
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.
