Re: [sqlsmith] Failed to generate plan on lateral subqueries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [sqlsmith] Failed to generate plan on lateral subqueries
Дата
Msg-id 12974.1449849518@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [sqlsmith] Failed to generate plan on lateral subqueries  (Andreas Seltenreich <seltenreich@gmx.de>)
Ответы Re: [sqlsmith] Failed to generate plan on lateral subqueries  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-hackers
Andreas Seltenreich <seltenreich@gmx.de> writes:
> Tom Lane writes:
>> [2. transitive-lateral-fixes-2.patch ]
>> [2. remove-lateraljoininfo-2.patch ]

> They seem to have fixed the issue for good now.  No errors have been
> logged for 2e8 queries since applying the first patch.  (The second one
> was applied later and didn't get as much exposure.)

Thanks.  It's good that you tested both states of the code, since I intend
to back-patch transitive-lateral-fixes into 9.4 and 9.3, but not the
second patch.

> I guess that means I have to go back to extending the grammar again :-).

I await the results with interest.  Did you note the suggestion about
trying to stress the ON CONFLICT code with this?  You'd need it to
issue non-SELECT queries, which might create some reproducibility
issues...
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: More on the libxml2 update situation
Следующее
От: Aleksander Alekseev
Дата:
Сообщение: Re: Patch: fix lock contention for HASHHDR.mutex