Re: constraint exclusion and nulls in IN (..) clause - Mailing list pgsql-hackers

From Emre Hasegeli
Subject Re: constraint exclusion and nulls in IN (..) clause
Date
Msg-id CAE2gYzzK=mE6ya+SzG=8TV1Bg6nK1RmPn36-BL0OYGhdYMuA4g@mail.gmail.com
Whole thread Raw
In response to Re: constraint exclusion and nulls in IN (..) clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: constraint exclusion and nulls in IN (..) clause  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> After further thought, it seems like the place to deal with this is
> really operator_predicate_proof(), as in the attached draft patch
> against HEAD.  This passes the smell test for me, in the sense that
> it's an arguably correct and general extension of the proof rules,
> but it could use more testing.

I am not sure if we are covering the case when clause_const and
pred_const are both NULL.  In this case, we should be able to return
true only by checking op_strict(pred_op) or maybe even without
checking that.  Am I mistaken?


pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: JIT compiling with LLVM v12.2
Next
From: Darafei "Komяpa" Praliaskouski
Date:
Subject: Re: [HACKERS] [PATCH] Incremental sort