Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL command round result of minus operation with high precision numbers #10212

Open
Nulhiedbriks opened this issue Apr 8, 2024 · 0 comments
Open
Labels
Milestone

Comments

@Nulhiedbriks
Copy link

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 ?

@tglman tglman added this to the 3.2.x milestone Apr 8, 2024
@tglman tglman added the bug label Apr 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development

No branches or pull requests

2 participants