| From: | Laurette Cisneros <laurette(at)nextbus(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: bug in join? |
| Date: | 2002-01-03 00:12:53 |
| Message-ID: | Pine.LNX.4.33.0201021612490.18608-100000@visor.corp.nextbus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Thanks Tom!
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
>
--
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ned Wolpert | 2002-01-03 00:16:18 | Re: software license question |
| Previous Message | Tom Lane | 2002-01-03 00:05:17 | Re: Bulkloading using COPY - ignore duplicates? |