Subject: bug#6366: join can't join on numeric fields

From: Alex Shinn <[email-masked]>
Date: Wed, 9 Jun 2010 16:33:06 +0900

On Wed, Jun 9, 2010 at 3:56 PM, Jim Meyering <[email-masked]> wrote:
>
> When comparing floating point numbers how would join measure equality?
> Should it consider 1.000000000000001e2 to be equal to 100.0 ?
> What if the maximum precision available does not
> allow us to distinguish those two values?

Indeed, that's why you generally don't use floating
point numbers as database keys.

We could either restrict the numbers to integers,
or continue to allow floats with a note to the effect
that float precision is machine-specific.  Personally
I have no need for floats so am happy with the former.

-- 
Alex