SQLite 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?