Re: Crash in 9.4 Beta when partially collapsing left outer joins - Mailing list pgsql-general

From Tom Lane
Subject Re: Crash in 9.4 Beta when partially collapsing left outer joins
Date
Msg-id 7732.1410269107@sss.pgh.pa.us
Whole thread Raw
In response to Re: Crash in 9.4 Beta when partially collapsing left outer joins  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Crash in 9.4 Beta when partially collapsing left outer joins  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Michael Paquier <michael.paquier@gmail.com> writes:
> The logic for nested OR is correct by reading it, hence why not simply
> removing the assertion failing? The attached patch 1 does so.

The reason for the assert is that there should never be an OR directly
underneath an OR in the planner after eval_const_expressions has flattened
such cases.  Evidently commit f343a88 failed to preserve AND/OR flatness
in some cases :-(.  That code should be taught to do so, rather than
lobotomizing this assertion.  Lack of flatness causes optimization
inefficiencies, which is why we don't want to just allow it.

            regards, tom lane


pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: Async IO HTTP server frontend for PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Advisory lock grant order