:params {wrong:1.E6,acceptable:1E6,ok:1.0E6}
results in
{
"wrong": "1.E6",
"acceptable": 1000000.0,
"ok": 1000000.0
}
creates unexpected multiplication error:
return $wrong * 2
obviously results in
ERROR #### Neo.ClientError.Statement.SyntaxError
Type mismatch for parameter 'wrong': expected Float, Integer or Duration but was String (line 1, column 8 (offset: 7)) "return $wrong*2"
^
in complicated Cypher this is almost impossible to detect!
Interesting post. Thanks! It works correctly if you include a 0 after the decimal point:
:params {wrong:1.0E6,acceptable:1E6,ok:1.0E6}
{
"wrong": 1000000.0,
"acceptable": 1000000.0,
"ok": 1000000.0
}