Re: [sqlsmith] Failed assertion in joinrels.c
От | Piotr Stefaniak |
---|---|
Тема | Re: [sqlsmith] Failed assertion in joinrels.c |
Дата | |
Msg-id | BLU437-SMTP75D969B15A0BB43A4A4570F2750@phx.gbl обсуждение исходный текст |
Ответ на | Re: [sqlsmith] Failed assertion in joinrels.c (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On 08/05/2015 08:43 PM, Tom Lane wrote: > Piotr Stefaniak <postgres@piotr-stefaniak.me> writes: >> On 08/05/2015 02:24 AM, Tom Lane wrote: >>> Piotr Stefaniak <postgres@piotr-stefaniak.me> writes: >>>> Set join_collapse_limit = 32 and you should see the error. > >>> Ah ... now I get that error on the smaller query, but the larger one >>> (that you put in an attachment) still doesn't show any problem. >>> Do you have any other nondefault settings? > >> Sorry, that needs from_collapse_limit = 32 as well. > > Yeah, I assumed as much, but it still doesn't happen for me. Possibly > something platform-dependent in statistics, or something like that. > > Anyway, I fixed the problem exposed by the smaller query; would you > check that the larger one is okay for you now? I can't reproduce the error in either case, so that seems to be fixed now. Thanks!
В списке pgsql-hackers по дате отправления: