Every math operations or functions seem to round the number to the 17th most significants digits.
To showcase the problem, I have made a test lookup table that look like that:
If I run this :
The results in the new column are automaticly rounded like that:
id long_numbers should_be_the_same
1 12345678901234567894 12345678901234567000
2 12345678901234567814 12345678901234567000
3 12345678901234567826 12345678901234567000
The min(), max(), avg() used with stats all have the same behaviour.
Does someone know why it's acting like that and
if there a way to prevent this behaviour?
... View more