Result different from Studio query vs command function

[daviddupuy]

Hi there,

I cannot figure out why the result is different from studio vs command.

select $path, min($depth) from (traverse out() from (select from User where user_id = 1)STRATEGY DEPTH_FIRST) where user_id=31

Command :
array (size=2)
'$path' => string '(#17:0).out1.out1' (length=35)
'min' => string '2' (length=1)

Studio :
"result": [
{
"$path": [
"#17:0",
"#20:0"
],
"min($depth)": 1
}
],

The result from Studio is the correct one.

[andreyvk]

Hi, AFAIK, binary protocol, which is used by PhpOrient, on the server side uses a specific query executor (i dunno why, but Orient is apparently implemented this way). That executor is a bit limited and thus results may differ sometimes. So you need to find a workaround. Try rebuilding a query in a way that would work out. And also make a post on Orient's GitHub, not here. It's their issue really, so they may be able to suggest said workaround for you, if u ask for help. There're a bunch of problems with the binary driver at the moment that Orient guys wont fix. Their suggestion was to start using their REST driver instead, which is also a bit buggy at times, but works better than PhpOrient driver in most cases (for existing problems see GitHub issues).