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 1oAuW4-0005GE-Kc for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Jul 2022 14:36:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oAuW3-0002JG-E6 for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Jul 2022 14:36:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oAuFg-0005NB-09 for pgsql-bugs@lists.postgresql.org; Mon, 11 Jul 2022 14:19:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oAuFd-0006bn-T3 for pgsql-bugs@lists.postgresql.org; Mon, 11 Jul 2022 14:19:07 +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=3pW2qho9HD5SSCtg7uwMHon7OrldLnofYuovX/KY7h8=; b=Ibli2Xnn44edGrqM6EjafVz71c Dxybv2qpbu/bW/x8mrGlh1NdsIrQff4t0pDnmoyLNnuK/5QFICUvZfKER8FxKOH3tONowaA7kUr1F MpGN/HgIrNTEh2R5GRnDUvsdcMyRjbw8lDOUK6TGT2uEWFuh2K9BLLv0Lzuvv7HcMkeAxryP582aw oemj3yhmkeeoyfmZH/hmdCjvAEQpX2WROaKBHSAdK0BTthSvl27aMhtYotNHYKHWS+F2JdQIMa3oZ +oxKeg36oBW90FqRNyIWI3adCiVz3ByAnkfuSrP5P/DXzh9ysMj0jYbINBeojcg8m09aUp3s/yUhE YB3n/XIQ==; 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 1oAuFc-0002Ec-IR for pgsql-bugs@lists.postgresql.org; Mon, 11 Jul 2022 14:19:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oAuFa-008aNy-6H for pgsql-bugs@lists.postgresql.org; Mon, 11 Jul 2022 14:19:02 +0000 Content-Type: multipart/mixed; boundary="===============4451431866022718992==" MIME-Version: 1.0 Subject: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rpsalmi@gmail.com Reply-To: rpsalmi@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 11 Jul 2022 14:18:44 +0000 Message-ID: <17545-a0ca4de888953169@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 --===============4451431866022718992== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU0NQpMb2dnZWQgYnk6ICAgICAgICAgIFJvb3BlIFNhbG1pCkVtYWls IGFkZHJlc3M6ICAgICAgcnBzYWxtaUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNC40 Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIyLjA0CkRlc2NyaXB0aW9uOiAgICAgICAgCgpI aSwNCg0KSXQgYXBwZWFycyB0aGF0IHNlbGVjdGl2aXR5IGZvciAiSVMgTk9UIERJU1RJTkNUIEZS T00iIGNsYXVzZXMgcmVnYXJkIHRoZQ0KcHJvcG9ydGlvbiBvZiBOVUxMcyBpbiB0aGUgc2FtZSB3 YXkgYXMgIj0iLCBsZWFkaW5nIHRvIHBvbGFyIG9wcG9zaXRlIHJvdwpjb3VudA0KZXN0aW1hdGVz Lg0KDQpJbiBwcmFjdGljZSB0aGlzIGNhdXNlcyBuZXN0ZWQgbG9vcCBqb2lucyB0byBiZSB1c2Vk IHdoZW4gdGhhdCBpcyBub3QNCmFwcHJvcHJpYXRlLiBOb3Qgc3VyZSBpZiB0aGlzIGlzIGEga25v d24gaXNzdWUsIGJ1dCBJIHdhcyB1bmFibGUgdG8gZmluZAphbnkNCnByZXZpb3VzIG1lbnRpb25z IG9mIGl0Lg0KDQpIZXJlIEkgY3JlYXRlIGEgdGFibGUgd2l0aCBvbmUgY29sdW1uIGFuZCAxMDAw IHJvd3Mgb2YgTlVMTC4gQSBjYXJ0ZXNpYW4KcHJvZHVjdA0Kd2l0aCAiV0hFUkUgeC5hID0geS5h IiBjb3JyZWN0bHkgZXN0aW1hdGVzIHRoYXQgdGhlcmUgYXJlIGFyb3VuZCB6ZXJvCm1hdGNoaW5n DQpyb3dzLiAieC5hIElTIE5PVCBESVNUSU5DVCBGUk9NIHkuYSIgaW5jb3JyZWN0bHkgZ2l2ZXMg dGhlIHNhbWUgZXN0aW1hdGUsDQp3aGVyZWFzICJ4LmEgPSB5LmEgT1IgKHguYSBJUyBOVUxMIEFO RCB5LmEgSVMgTlVMTCkiLCB3aGljaCBzaG91bGQgYmUNCmVxdWl2YWxlbnQsIGdpdmVzIHRoZSBj b3JyZWN0IDEwMDAwMDAuDQoNCnBvc3RncmVzPSMgQ1JFQVRFIFRBQkxFIHRlc3QoYSBJTlRFR0VS KTsNCkNSRUFURSBUQUJMRQ0KcG9zdGdyZXM9IyBJTlNFUlQgSU5UTyB0ZXN0KGEpIFNFTEVDVCBO VUxMIEZST00gZ2VuZXJhdGVfc2VyaWVzKDEsIDEwMDApOw0KSU5TRVJUIDAgMTAwMA0KcG9zdGdy ZXM9IyBBTkFMWVpFIHRlc3Q7DQpBTkFMWVpFDQpwb3N0Z3Jlcz0jIEVYUExBSU4gU0VMRUNUIEZS T00gdGVzdCB4LCB0ZXN0IHkgV0hFUkUgeC5hID0geS5hOw0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgUVVFUlkgUExBTiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KIE1lcmdlIEpvaW4gIChjb3N0PTEyNy42Ni4uMTM3LjY3IHJvd3M9MSB3aWR0aD0w KQ0KICAgTWVyZ2UgQ29uZDogKHguYSA9IHkuYSkNCiAgIC0+ICBTb3J0ICAoY29zdD02My44My4u NjYuMzMgcm93cz0xMDAwIHdpZHRoPTQpDQogICAgICAgICBTb3J0IEtleTogeC5hDQogICAgICAg ICAtPiAgU2VxIFNjYW4gb24gdGVzdCB4ICAoY29zdD0wLjAwLi4xNC4wMCByb3dzPTEwMDAgd2lk dGg9NCkNCiAgIC0+ICBTb3J0ICAoY29zdD02My44My4uNjYuMzMgcm93cz0xMDAwIHdpZHRoPTQp DQogICAgICAgICBTb3J0IEtleTogeS5hDQogICAgICAgICAtPiAgU2VxIFNjYW4gb24gdGVzdCB5 ICAoY29zdD0wLjAwLi4xNC4wMCByb3dzPTEwMDAgd2lkdGg9NCkNCig4IHJvd3MpDQoNCnBvc3Rn cmVzPSMgRVhQTEFJTiBTRUxFQ1QgRlJPTSB0ZXN0IHgsIHRlc3QgeQ0KcG9zdGdyZXM9IyBXSEVS RSB4LmEgSVMgTk9UIERJU1RJTkNUIEZST00geS5hOw0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgUVVFUlkgUExBTiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLQ0KIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi4xNTAzMC41MCByb3dzPTEgd2lkdGg9MCkN CiAgIEpvaW4gRmlsdGVyOiAoTk9UICh4LmEgSVMgRElTVElOQ1QgRlJPTSB5LmEpKQ0KICAgLT4g IFNlcSBTY2FuIG9uIHRlc3QgeCAgKGNvc3Q9MC4wMC4uMTQuMDAgcm93cz0xMDAwIHdpZHRoPTQp DQogICAtPiAgTWF0ZXJpYWxpemUgIChjb3N0PTAuMDAuLjE5LjAwIHJvd3M9MTAwMCB3aWR0aD00 KQ0KICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHRlc3QgeSAgKGNvc3Q9MC4wMC4uMTQuMDAgcm93 cz0xMDAwIHdpZHRoPTQpDQooNSByb3dzKQ0KDQpwb3N0Z3Jlcz0jIEVYUExBSU4gU0VMRUNUIEZS T00gdGVzdCB4LCB0ZXN0IHkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICANCnBv c3RncmVzLSMgV0hFUkUgeC5hID0geS5hIE9SICh4LmEgSVMgTlVMTCBBTkQgeS5hIElTIE5VTEwp Ow0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIE5lc3RlZCBMb29wICAoY29zdD0wLjAw Li4xNTAzMC41MCByb3dzPTEwMDAwMDAgd2lkdGg9MCkNCiAgIEpvaW4gRmlsdGVyOiAoKHguYSA9 IHkuYSkgT1IgKCh4LmEgSVMgTlVMTCkgQU5EICh5LmEgSVMgTlVMTCkpKQ0KICAgLT4gIFNlcSBT Y2FuIG9uIHRlc3QgeCAgKGNvc3Q9MC4wMC4uMTQuMDAgcm93cz0xMDAwIHdpZHRoPTQpDQogICAt PiAgTWF0ZXJpYWxpemUgIChjb3N0PTAuMDAuLjE5LjAwIHJvd3M9MTAwMCB3aWR0aD00KQ0KICAg ICAgICAgLT4gIFNlcSBTY2FuIG9uIHRlc3QgeSAgKGNvc3Q9MC4wMC4uMTQuMDAgcm93cz0xMDAw IHdpZHRoPTQpDQooNSByb3dzKQoK --===============4451431866022718992==--