Re: [sqlsmith] Failed to generate plan on lateral subqueries - Mailing list pgsql-hackers

From Andreas Seltenreich
Subject Re: [sqlsmith] Failed to generate plan on lateral subqueries
Date
Msg-id 87lh95h1kk.fsf@elite.ansel.ydns.eu
Whole thread Raw
In response to Re: [sqlsmith] Failed to generate plan on lateral subqueries  (Andreas Seltenreich <seltenreich@gmx.de>)
Responses Re: [sqlsmith] Failed to generate plan on lateral subqueries  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I wrote:

> Tom Lane writes:
>> Andreas Seltenreich <seltenreich@gmx.de> writes:
>>> I've added new grammar rules to sqlsmith and improved some older ones.
>>> This was rewarded with a return of "failed to generate plan" errors.
>>
>> I believe I've dealt with these cases now.  Thanks for the report!
>
> I no longer see "failed to build any n-way joins" after pulling, but
> there are still instances of "could not devise a query plan". Samples below.

sorry, I spoke too soon: nine of the former have been logged through the
night.  I'm attaching a larger set of sample queries this time in case
that there are still multiple causes for the observed errors.

regards,
Andreas


Attachment

pgsql-hackers by date:

Previous
From: Catalin Iacob
Date:
Subject: Re: proposal: PL/Pythonu - function ereport
Next
From: Michael Paquier
Date:
Subject: