orientechnologies/orientdb

SQL command round result of minus operation with high precision numbers

Nulhiedbriks opened this issue · 0 comments

OrientDB Version: 3.2.7

I try to search vertex with a difference between a field (type Double) and a Number i get a round result when result is extremely closed to 0.

Let name the field : vertex_value with the type Double and value : 0.7243372797966003
When i do SEARCH vertex_value FROM my_vertex it shows : 0.7243372797966003
When i do SEARCH vertex_value - 0.7243372532921638 FROM my_vertex it shows : 0

I tried to write my own function with studio (in javascript). The testing show the result that i expect (which is 2.6504436534402487e-8 ) but on SQL command it return 0.
I had also check all types.

Any idea of what is wrong ?