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 по дате отправления: