On Wed, 2 Jan 2002, Tom Lane wrote:
> Okay, I've been able to reproduce the problem here. Looks like the
> eqjoinsel math is not wrong, exactly, but small roundoff errors are
> causing the logic to do unreasonable things. I think
> get_att_numdistinct needs to round its result to an integer, and
> probably there needs to be some clamping of computed probabilities to
> the 0..1 range (otherfreq1 is coming out about -4.4703483581542969e-08
> in this example, which should be clamped to 0).
> Will have a fix late tonight or tomorrow.
> Thanks for the example case!
> regards, tom lane
NextBus Information Systems, Inc.
Passenger Information Everywhere
In response to
pgsql-hackers by date
|Next:||From: Ned Wolpert||Date: 2002-01-03 00:16:18|
|Subject: Re: software license question|
|Previous:||From: Tom Lane||Date: 2002-01-03 00:05:17|
|Subject: Re: Bulkloading using COPY - ignore duplicates? |