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