Postgres Pro
Downloads
Home   >   mailing lists

Re: Assert failure of the cross-check for nullingrels - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Assert failure of the cross-check for nullingrels
Date
Msg-id CAMbWs489MSrXdBDFis-KDKDBzZ4xg_UWqUrbR+9agYdxgNBtrw@mail.gmail.com
Whole thread Raw
In response to Re: Assert failure of the cross-check for nullingrels  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: Assert failure of the cross-check for nullingrels  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-hackers
Tree view

On Mon, Mar 13, 2023 at 5:03 PM Richard Guo <guofenglinux@gmail.com> wrote:
Back to the original issue, if a join has more than one quals, actually
we treat them as a whole when we check if identity 3 applies as well as
when we adjust them to be suitable for commutation according to identity
3.  So when we check if a qual is computable at a given level, I think
we should also consider the join's quals as a whole.  I'm thinking that
we use a 'group' notion for RestrictInfos and then use the clause_relids
of the 'group' in clause_is_computable_at.  Does this make sense?
 
I'm imagining something like attached (no comments and test cases yet).

Thanks
Richard
Attachment

pgsql-hackers by date:

Previous
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
Next
From: "Drouvot, Bertrand"
Date:
Subject: Re: [BUG] pg_stat_statements and extended query protocol