Re: bug in join?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: bug in join?
Дата
Msg-id 8128.1010016171@sss.pgh.pa.us
обсуждение исходный текст
Ответ на bug in join?  (Laurette Cisneros <laurette@nextbus.com>)
Ответы Re: bug in join?
Re: bug in join?
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: problems with new vacuum (??)
Следующее
От: Laurette Cisneros
Дата:
Сообщение: Re: bug in join?