Re: Expr. extended stats are skipped with equality operator

From: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Danny Shemesh <dany74q(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Expr. extended stats are skipped with equality operator
Date: 2022-08-07 17:31:28
Message-ID: a7f9ac72-5711-7b5f-5052-6f708436037e@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/7/22 19:28, Tom Lane wrote:
> Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aleš Zelený 2022-08-07 19:47:09 Re: PostgreSQL 14.4 ERROR: out of memory issues
Previous Message Tom Lane 2022-08-07 17:28:02 Re: Expr. extended stats are skipped with equality operator