Re: [sqlsmith] subplan variable reference / unassigned NestLoopParams

Поиск
Список
Период
Сортировка
От Andreas Seltenreich
Тема Re: [sqlsmith] subplan variable reference / unassigned NestLoopParams
Дата
Msg-id 8737ztua6v.fsf@ex.ansel.ydns.eu
обсуждение исходный текст
Ответ на Re: [sqlsmith] subplan variable reference / unassigned NestLoopParams (was: [sqlsmith] Failed assertion in joinrels.c)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [sqlsmith] subplan variable reference / unassigned NestLoopParams  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane writes:

> Andreas Seltenreich <seltenreich@gmx.de> writes:
>> Tom Lane writes:
>>> Well, I certainly think all of these represent bugs:
>>>> 3 | ERROR:  plan should not reference subplan's variable
>>>> 2 | ERROR:  failed to assign all NestLoopParams to plan nodes
>
>> These appear to be related.  The following query produces the former,
>> but if you replace the very last reference of provider with the literal
>> 'bar', it raises the latter error.
>
> Fixed that, thanks for the test case!

I haven't seen the former since your commit, but there recently were
some instances of the latter.  The attached queries all throw the error
against master at 8752bbb.

regards,
Andreas


Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Dependency between bgw_notify_pid and bgw_flags
Следующее
От: Joe Conway
Дата:
Сообщение: Re: WIP: SCRAM authentication