On 11/6/2015 9:20 AM, Wade, William wrote: > However I do depend on getting consistent answers, and on (x >= 1234) being > disjoint from (x < 1234) and that those two ranges cover the number line. I > suspect that sqlite makes that kind of guarantee, at least if I explicitly > cast values to double whenever I do an INSERT or UPDATE or WHERE, although > that seems like an easy thing to forget to do.
Declare your columns with REAL affinity ( http://www.sqlite.org/datatype3.html ). Such columns never contain integers, only floats (any attempt to insert an integer coerces it to a float, possibly losing precision). One of the problems in the OPs example is that columns have no declared type, and thus BLOB affinity (which pretty much means, anything goes and no conversions are performed). -- Igor Tandetnik
