[sqlite] Non-transitive numeric equality

2015-11-06 Thread Simon Slavin
On 6 Nov 2015, at 2:20pm, Wade, William wrote: > I have an engineering application, where double can be part of a key. So do I, using Longitude and Latitude in GPS coordinates. A lot of things done inside GPS devices amount to "List everything in this rectangle". This is the problem.

[sqlite] Non-transitive numeric equality

2015-11-06 Thread Wade, William
he sqlite numeric types are all representable as bigint rationals). That may be overkill (and not all that lite). Regards -Original Message- From: Richard Hipp [mailto:d...@sqlite.org] Sent: Thursday, November 05, 2015 8:55 AM To: SQLite mailing list Subject: Re: [sqlite] Non-transitive n

[sqlite] Non-transitive numeric equality

2015-11-06 Thread Igor Tandetnik
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

[sqlite] Non-transitive numeric equality

2015-11-05 Thread R Smith
On 2015/11/05 4:55 PM, Richard Hipp wrote: > On 11/5/15, Zsb?n Ambrus wrote: >> Dear SQLite, >> >> It seems that equality of numeric values isn't transitive, when both >> integers and reals are involved. Here's an example output from the >> shell, which shows that the numeric value in the 'c'

[sqlite] Non-transitive numeric equality

2015-11-05 Thread Stephan Beal
On Thu, Nov 5, 2015 at 3:36 PM, Zsb?n Ambrus wrote: > It seems that equality of numeric values isn't transitive, when both > integers and reals are involved. See this really, really, really, really long thread on that topic from a couple weeks ago for far, far, far more information than you

[sqlite] Non-transitive numeric equality

2015-11-05 Thread Zsbán Ambrus
Dear SQLite, It seems that equality of numeric values isn't transitive, when both integers and reals are involved. Here's an example output from the shell, which shows that the numeric value in the 'c' row is equal to both the value in the 'b' and the 'd' rows, but the value in the 'b' row isn't

[sqlite] Non-transitive numeric equality

2015-11-05 Thread Richard Hipp
On 11/5/15, Zsb?n Ambrus wrote: > Dear SQLite, > > It seems that equality of numeric values isn't transitive, when both > integers and reals are involved. Here's an example output from the > shell, which shows that the numeric value in the 'c' row is equal to > both the value in the 'b' and the