Skip site navigation (1) Skip section navigation (2)

Re: bug in join?

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 (view raw or flat)
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


In response to

pgsql-hackers by date

Next:From: Ned WolpertDate: 2002-01-03 00:16:18
Subject: Re: software license question
Previous:From: Tom LaneDate: 2002-01-03 00:05:17
Subject: Re: Bulkloading using COPY - ignore duplicates?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group