Re: [sqlsmith] subplan variable reference / unassigned NestLoopParams

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [sqlsmith] subplan variable reference / unassigned NestLoopParams
Дата
Msg-id 14811.1439241721@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [sqlsmith] subplan variable reference / unassigned NestLoopParams  (Andreas Seltenreich <seltenreich@gmx.de>)
Список pgsql-hackers
Andreas Seltenreich <seltenreich@gmx.de> writes:
> 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.

Turns out my patch only addressed some cases of the underlying issue.
I've gone back for a second swipe at it; thanks for the continued testing!

BTW, the commit hashes you've been mentioning don't seem to correspond to
anything in the master PG repo ... are you working with modified sources?
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Fix pg_dump to dump shell types.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: linux sparc compile issue