Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lQmWC-00041v-7I for pgsql-bugs@arkaria.postgresql.org; Mon, 29 Mar 2021 07:41:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lQmWB-0004LV-60 for pgsql-bugs@arkaria.postgresql.org; Mon, 29 Mar 2021 07:40:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lQdDb-0000De-Ja for pgsql-bugs@lists.postgresql.org; Sun, 28 Mar 2021 21:45:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lQdDX-0002Sx-1v for pgsql-bugs@lists.postgresql.org; Sun, 28 Mar 2021 21:45:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=ctQxmYE+1B0Iw6vgRQvtExiiWjkwALe9S7dkPIIdgQ0=; b=mobZvWqcIE3ZKDqyJkOtXCQ8H2 eSpBMFIo432c8Thh0FTO5kxoWsws64/FftnT/vf5qdb2PSpps/WOM7vHCDOGqxxiDQmwgtcpwlgdF caKYBu748U57nig/QiYQU125tyZV+WTcM3w6NeMLofm/jEgq4nlJeEQlo/ZNG04hKznBmMeY48FPZ NTwmCqqK2GeW3veW6N8xBi0MLRpET6DzBP3QSXUToC34nmxnpoMQQKTRaw9Enk3ZcITsoGG2nMdSC +0yYVqLiFfe91E35Bsb/26ImWd1Wwa9Hg3QWVAhsNLEkG7FipDpxPxkySkx56Csx2POWPhSokJzfj 5D5542TA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lQdDW-0008LM-8D for pgsql-bugs@lists.postgresql.org; Sun, 28 Mar 2021 21:45:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lQdDS-0001da-Uk for pgsql-bugs@lists.postgresql.org; Sun, 28 Mar 2021 21:45:02 +0000 Content-Type: multipart/mixed; boundary="===============6172887047679857745==" MIME-Version: 1.0 Subject: BUG #16945: where value in (null) set results inconsistent To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: glennwidener@gmail.com Reply-To: glennwidener@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 28 Mar 2021 21:44:47 +0000 Message-ID: <16945-b758f752890b2b8e@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6172887047679857745== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjk0NQpMb2dnZWQgYnk6ICAgICAgICAgIEdsZW5uIFdpZGVuZXIKRW1h aWwgYWRkcmVzczogICAgICBnbGVubndpZGVuZXJAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTEuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MgMTAKRGVzY3JpcHRpb246ICAgICAg ICAKClB1cnN1YW50IHRvIGEgZml4IGluIEhpYmVybmF0ZSwgdGhhdCB1c2VzICJ3aGVyZSB2YWx1 ZSBpbiAobnVsbCkiIGFzIGEKd29ya2Fyb3VuZCBmb3Igc2V2ZXJhbCBEQidzIG5vdCBoYW5kbGlu ZyAid2hlcmUgdmFsdWUgaW4gKCkiOg0KaHR0cHM6Ly9oaWJlcm5hdGUuYXRsYXNzaWFuLm5ldC9i cm93c2UvSEhILTgwOTENCg0KQ29uc2lkZXIgdGhpcyBpbmNvbnNpc3RlbmN5Og0KdGVzdC1kYj0+ IHNlbGVjdCBpZCBmcm9tIHByb2plY3RfdHlwZV92YXJpYW50cyB3aGVyZSBpZCBpbiAoMCk7DQog aWQNCi0tLS0NCigwIHJvd3MpDQoNCnRlc3QtZGI9PiBzZWxlY3QgaWQgZnJvbSBwcm9qZWN0X3R5 cGVfdmFyaWFudHMgd2hlcmUgaWQgaW4gKG51bGwpOw0KIGlkDQotLS0tDQooMCByb3dzKQ0KDQp0 ZXN0LWRiPT4gc2VsZWN0IGlkIGZyb20gcHJvamVjdF90eXBlX3ZhcmlhbnRzIHdoZXJlIGlkIG5v dCBpbiAoMCk7DQogaWQNCi0tLS0NCiAgMQ0KICAyDQogIDMNCigzIHJvd3MpDQoNCnRlc3QtZGI9 PiBzZWxlY3QgaWQgZnJvbSBwcm9qZWN0X3R5cGVfdmFyaWFudHMgd2hlcmUgaWQgbm90IGluIChu dWxsKTsNCiBpZA0KLS0tLQ0KKDAgcm93cykNCg0KTmVlZHMgdG8gd29yayBjb25zaXN0ZW50bHks IGJlY2F1c2UgKG51bGwpIGlzIGEgcmVxdWlyZWQgd29ya2Fyb3VuZCBmb3I6DQoNCnRlc3QtZGI9 PiBzZWxlY3QgaWQgZnJvbSBwcm9qZWN0X3R5cGVfdmFyaWFudHMgd2hlcmUgaWQgaW4gKCk7DQpF UlJPUjogIHN5bnRheCBlcnJvciBhdCBvciBuZWFyICIpIgoK --===============6172887047679857745==--