[orientdb] 2.1.1 broke calculations in sql

[alexander anguiano]

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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.