Horton

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

Emre Hasegeli <emre@hasegeli.com>

View thread View on postgr.es
From: Emre Hasegeli <emre@hasegeli.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-03-06T10:16:11Z
Lists: pgsql-hackers 
> Hmm, state->next refers to two different pointer values on line 1 and line
> 2.  It may end up being set to NULL on line 1.  Am I missing something?

True, lnext(state->next) can set it to NULL.  I confused by the below
code on the same function doing the steps in reverse order.  With this
cleared, I have nothing else to say, so I am setting this to ready for
committer.

Commits

  1. Improve predtest.c's handling of cases with NULL-constant inputs.