SQLite User Forum

Fail to calculate long expression
Login
The differences seem to be in integer arithmetic, is that right?

If one makes all the numbers floating point, then sqlite (and, I suspect others) join the 8.2598e+12 crowd.


 select (((((((788.)*(8.46))))+8342. * 1.803 -1.))*4186.4 *(15.))*(((22. /((7530. /((2.)*(((((25.))-421.))))))*597.)+7283.8 - 9.60+167.))+(8871.);
8259816920615.11

So is there any evidence that any of the listed software is not working as documented?