On 12/11/15, Frank Millman <frank at chagford.com> wrote: > > Can anyone explain what is going on, and is there a way to avoid it? >
Short answer: https://www.sqlite.org/faq.html#q16 I don't have a longer answer readily at hand, but as questions about floating point numbers come up a lot, probably I should write up a tutorial. I'll try to get that done before the end of the year... -- D. Richard Hipp drh at sqlite.org