Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1qqw4y-001lfo-Cx
	for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Oct 2023 13:50:20 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1qqw4v-007L2L-Om
	for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Oct 2023 13:50:18 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <s.glukhov@postgrespro.ru>)
	id 1qqw1t-007DLE-9i
	for pgsql-hackers@lists.postgresql.org; Thu, 12 Oct 2023 13:47:10 +0000
Received: from mail.postgrespro.ru ([93.174.131.139])
	by makus.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <s.glukhov@postgrespro.ru>)
	id 1qqw1q-0008TD-TM
	for pgsql-hackers@lists.postgresql.org; Thu, 12 Oct 2023 13:47:08 +0000
Received: from [192.168.1.3] (a0.sub235.net78.udm.net [78.85.235.0])
	(using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
	(Client did not present a certificate)
	(Authenticated sender: s.glukhov@postgrespro.ru)
	by mail.postgrespro.ru (Postfix/587) with ESMTPSA id 6B0F0E20EA3;
	Thu, 12 Oct 2023 16:47:04 +0300 (MSK)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru;
	s=mx2023; t=1697118424;
	bh=iqIsRKo4MJTGWtCIj9Lz720eBjkjUn7VV31qdUUNHVU=;
	h=Message-ID:Date:User-Agent:Subject:To:Cc:References:From:
	 In-Reply-To:From;
	b=Fn27nx/gVbNqAA9/jRBjQJ3CFMwQ6qYfewkxVtwtH7226trxOiOROgPzHNMMKIzBN
	 FFx8WLBY6PulJLB6ZMGqkxxNWlQye5VkXJsTyRUNNhsOzEchMLlFmPmg0zvSla+Cu+
	 shX1jLXEKdvm4nORW+8QgaNIpZA0C+/DAMuZMQZj0iQagY64ZLc2mXig2oeOH8IuT1
	 v5e8lvsvvGTAVB9wapQjwbjzCd6W0U6aIonO+yHWhi+tedY4/l5rxVajNcYAdBfeLQ
	 OMNi2MKv78K40Tvc7QCSJ2zsda8jAIdTcLs4/2Rg43CrmuEb+3As/04FKaZOkUgLYl
	 FZXmVq8qmqODg==
Message-ID: <5ba5d840-1080-54ee-08e5-e76aadc2bcbb@postgrespro.ru>
Date: Thu, 12 Oct 2023 17:47:03 +0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.9.0
Subject: Re: Problem, partition pruning for prepared statement with IS NULL
 clause.
Content-Language: en-US
To: David Rowley <dgrowleyml@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
References: <d05b26fa-af54-27e1-f693-6c31590802fa@postgrespro.ru>
 <CAApHDvrc8BjkN8U3NUVzvat3EtC7bzLwFdUw_OFf3Sv-QCp-Vg@mail.gmail.com>
 <CAApHDvrAkY49h1J_OX+YraCJDGQnXu3SRHnBdEUNQXGm15Lrcw@mail.gmail.com>
From: Sergei Glukhov <s.glukhov@postgrespro.ru>
In-Reply-To: 
 <CAApHDvrAkY49h1J_OX+YraCJDGQnXu3SRHnBdEUNQXGm15Lrcw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/5ba5d840-1080-54ee-08e5-e76aadc2bcbb%40postgrespro.ru>
Precedence: bulk



On 10/12/23 16:27, David Rowley wrote:
>
> I've now also pushed the fix for the incorrect logic for nullkeys in
> ExecInitPruningContext().
>

Thanks!

Regards,
Gluh