On 9/3/18, Edson Poderoso <[email protected]> wrote: > WHERE outerr.spent = (SELECT spent ...)
The "spent" column holds a floating-point number. Depending on the order of operations, the values might be off by an epsilon, resulting in different floating point values and a failed comparison. This is why you should never perform equality comparisons of floating point numbers. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
