Postgres Pro
Downloads
Home   >   mailing lists

Re: Regression from 8.4 to 9.1.2/9.1.3: Optimizing filters on constants in unions - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Regression from 8.4 to 9.1.2/9.1.3: Optimizing filters on constants in unions
Date
Msg-id 390.1331918266@sss.pgh.pa.us
Whole thread Raw
In response to Regression from 8.4 to 9.1.2/9.1.3: Optimizing filters on constants in unions  (Claus Stadler <cstadler@informatik.uni-leipzig.de>)
Responses Re: Regression from 8.4 to 9.1.2/9.1.3: Optimizing filters on constants in unions
List pgsql-bugs
Tree view 
Claus Stadler <cstadler@informatik.uni-leipzig.de> writes:
> Filtering a Union on constant custom type:
> ...
> Expected: Query optimizer should discard the scan as filter cannot be
> satisfied.

I've applied a patch for this.  Thanks for the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: aren@arencambre.com
Date:
Subject: BUG #6535: LEFT JOIN on large table is altering data
Next
From: Alex Hunsaker
Date:
Subject: Re: BUG #6511: calling spi_exec_query from non-main package, results in: couldn't fetch $_TD