Re: constraint exclusion and nulls in IN (..) clause

Поиск
Список
Период
Сортировка
От Emre Hasegeli
Тема Re: constraint exclusion and nulls in IN (..) clause
Дата
Msg-id CAE2gYzzK=mE6ya+SzG=8TV1Bg6nK1RmPn36-BL0OYGhdYMuA4g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: constraint exclusion and nulls in IN (..) clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: constraint exclusion and nulls in IN (..) clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: JIT compiling with LLVM v12.2
Следующее
От: Darafei "Komяpa" Praliaskouski
Дата:
Сообщение: Re: [HACKERS] [PATCH] Incremental sort