Head on over to https://playcode.io/new/
console.log(0.1 * 125)
Look at you go, you're a programmer now!
Pipe down: add two more zeros.
Ah, so close, just two more zeros to go!
GAH! WHY!?
How does 0.0000001 x 125 = 0.0000124999999999???
The math can't get more basic, why the rounding error?
So when you get into fractions, a computer can't store numbers in base two like we think of numbers in base ten. For example, try to write 1/3 in base ten. What do you get?
0.333333333333333333333...
1/3 can not be expressed perfectly as a base 10 decimal. If you were using a base 3 number system 1/3 would be 0.1 and could be expressed perfectly without a rounding error. This same thing happens with floating point math to create some weird rounding errors (often times when multiplying/dividing numbers).
https://floating-point-gui.de/formats/binary/
I care! DAMMIT! When you're trying to keep track of money in a database (I am) then these rounding errors become unacceptable and totally ruin database integrity. In the case of the bug I just found, I wasn't even trying to keep track of money, but rather have been working on my sliding-scale voting system.
The schedule I've developed DEPENDS on the numbers being exact. If a variable in the database gets voted up/down and becomes 0.00014999999 instead of 0.00015 my code would get very confused and stop working.
This is exactly why every database has a DECIMAL class that completely avoids floating point math and actually uses base 10. It's slower and requires more storage but the loss in performance is more than worth it to maintain database integrity in many cases (especially those involving money).
In the case of my code, I was actually using a DECIMAL when the error occurred, but I was multiplying it by another exponent that was by default a floating point number. In the background it must have cast the entire result to a float and thus there was a bug in my code.
return cast(power(10, deviation) as decimal(65,30)) * temp;
In order to fix the bug I had to CAST the exponent as a decimal in order to stop floating-point math from occurring. Problem solved.
Well, that's how my day is going.
Just grinding out more code.
It's been slow going but hopefully I can pick up the pace.
Are the bears getting a bit too greedy?
Will there be an epic short squeeze?
Or will this market cave in once again?
Time will tell.