Postgres Pro
Downloads
Home   >   mailing lists

Re: Expr. extended stats are skipped with equality operator - Mailing list pgsql-general

From Tomas Vondra
Subject Re: Expr. extended stats are skipped with equality operator
Date
Msg-id a7f9ac72-5711-7b5f-5052-6f708436037e@enterprisedb.com
Whole thread Raw
In response to Re: Expr. extended stats are skipped with equality operator  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On 8/7/22 19:28, Tom Lane wrote:
> Tomas Vondra <tomas.vondra@enterprisedb.com> writes:
>> Yeah, this seems like a clear bug - we should not fail queries like
>> this. It's a sign statext_is_compatible_clause() and the MCV code
>> disagrees which clauses are compatible.
> 
> Indeed.  I attempted to fix that at e33ae53dd.
> 

Thanks! That probably explains why I've been unable to reproduce that, I
haven't realized there's a fix already.



-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Expr. extended stats are skipped with equality operator
Next
From: Aleš Zelený
Date:
Subject: Re: PostgreSQL 14.4 ERROR: out of memory issues