On 9/3/18, Edson Poderoso <edsonpoder...@gmail.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users