I'm trying to move from 2.0.2 to 2.1.1, this query worked in 2.0.2
select hostname, date().asLong(),
$agent.lastCommunicationTime[0].asLong() , date().asLong() -
$agent.lastCommunicationTime[0].asLong(),
$agent.version as agentVersion, $agent.lastCommunicationTime as
lastCommunicationTime
from (select expand(in("MemberOf")) from #14:1 ) Let $agent =
in("Manages") where @class = 'Asset' and (date() -
$agent.lastCommunicationTime[0]) > 40000
expect
date - $agent = 451605
1442008565000 - 1442008113395 = 451605
actual
date - $agent = date
{
"result": [
{
"@type": "d",
"@rid": "#-2:0",
"@version": 0,
"hostname": "JALQECG054.cddom100.lab",
"date": 1442008565000,
"$agent": 1442008113395,
"date2": 1442008565000,
"agentVersion": [
"4.2.0.264"
],
"lastCommunicationTime": [
"2015-09-11 16:48:33"
],
"@fieldTypes": "date=l,$agent=l,date2=l"
}
],
"notification": "Query executed in 0.117 sec. Returned 1 record(s)"
}
--
---
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.
