Re: BUG #14111: After minor upgrade (9.2.6 -> 9.2.16): ERROR: failed to build any 2-way joins

thanks.  Any idea when that release will go out?

On Mon, Apr 25, 2016 at 5:14 PM, David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Mon, Apr 25, 2016 at 5:03 AM, <bgrundmann@janestreet.com> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference:      14111
>> Logged by:          Benedikt Grundmann
>> Email address:      bgrundmann@janestreet.com
>> PostgreSQL version: 9.2.16
>> Operating system:   Linux
>> Description:
>>
>> >From all I know so far we have a query that used to work last week and
>> after
>> upgrading from 9.2.6 to 9.2.16 this weekend, we get
>>
>> ERROR: failed to build any 2-way joins
>>
>> when trying to plan the same query (that is either run the query or even
>> just explain it).  The query is this:
>>
>>
> =E2=80=8BThis sounds like the same as bug #
>  14105
>
> =E2=80=8B
> http://www.postgresql.org/message-id/20160420194758.22924.80319@wrigleys.=
postgresql.org
> =E2=80=8B
>
> =E2=80=8BThat one has been corrected and will go out in the next release.
>
> http://git.postgresql.org/pg/commitdiff/d9742ac4636ec847f9fd54c9d690da
> 7402319063
>
> Someone with source compilation can hopefully confirm that your specific
> example is indeed fixed.
>
> The combinations of left and full join lead me to suspect that indeed
> these are caused by the same bug.
>
> David J.
> =E2=80=8B
>
>
>