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 ) id 1ufDtG-004A5T-Bj for pgsql-bugs@arkaria.postgresql.org; Fri, 25 Jul 2025 08:34:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ufDtF-00FyrE-8z for pgsql-bugs@arkaria.postgresql.org; Fri, 25 Jul 2025 08:34:53 +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 ) id 1ufAI0-00ESol-Mc for pgsql-bugs@lists.postgresql.org; Fri, 25 Jul 2025 04:44:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ufAHv-000fGK-0k for pgsql-bugs@lists.postgresql.org; Fri, 25 Jul 2025 04:44:12 +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=Co7CGTkostdT+IOtR1NnTGHmK9paUPUkhmu5TwzyNgU=; b=LSsMJVkud7+C41m8S0+9MtIB6a kK/M0TXYCgGbJ8lzKOatAk8vM2aB5GF3ombMQS426iwp+DFfUv/MSC0E5DU04m9hFhTmwTaypke02 h4qn8LViSW3dsthrSCL+rpcQhxvl0hSny/rLJOVJx1uhC+oylkmZDc3NwAKK9jicYfDzRnka/v8QZ H2HbUxTpFFX2TtJE7GK8rH66nw3N4PY1nqs0PoEW0pqwL+gZ8Vn+U8Oex4z9XwVLrBgEaqO6zAqGi /U53+E5ZAbKsMYGG5xYT+0t0RVtXW1qYWn32MeD3o2+/cS/Vq7xj5c+6I9G+PYo0D2KIGjThSLQCV RJC1k9bQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ufAHr-001lSe-Jw for pgsql-bugs@lists.postgresql.org; Fri, 25 Jul 2025 04:44:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ufAHr-0030Lt-0L for pgsql-bugs@lists.postgresql.org; Fri, 25 Jul 2025 04:44:03 +0000 Content-Type: multipart/mixed; boundary="===============3787512172336205586==" MIME-Version: 1.0 Subject: BUG #18999: Equivalent queries processing WHERE IS NULL & WHERE IS NOT NULL produce mutually exclusive results To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jinhui-lai@foxmail.com Reply-To: jinhui-lai@foxmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 25 Jul 2025 04:43:03 +0000 Message-ID: <18999-4dbdbaeafb1c1023@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 --===============3787512172336205586== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk5OQpMb2dnZWQgYnk6ICAgICAgICAgIEppbmh1aSBMYWkKRW1haWwg YWRkcmVzczogICAgICBqaW5odWktbGFpQGZveG1haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTcuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIHVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAgICAg IAoKRGVhciBQRyBkZXZlbG9wZXJzLAoKVGhhbmtzIGZvciByZWFkaW5nIG15IHJlcG9ydC4KCkkg dGhpbmsgIlNFTEVDVCBDT1VOVChjMCkgRlJPTSB0MCIgPSAiU0VMRUNUIENPVU5UKGMwKSBGUk9N IHQwIFdIRVJFIGMwIElTCk5PVCBOVUxMIiArICJTRUxFQ1QgQ09VTlQoYzApIEZST00gdDAgV0hF UkUgYzAgSVMgTlVMTCIuIEhvd2V2ZXIsIHRoZQpmb2xsb3dpbmcgY2FzZSB2aW9sYXRlcyB0aGlz IGVxdWl2YWxlbmNlIHJlbGF0aW9uc2hpcC4KClBsZWFzZSB5b3UgY2FuIHJlcHJvZHVjZSBpdCBh cyBmb2xsb3dzOgoKQ1JFQVRFIFRZUEUgY29tcG9zaXRlIEFTIChhIFRFWFQsIGIgVEVYVCk7CkNS RUFURSBUQUJMRSB0MCAoYzAgY29tcG9zaXRlIFVOSVFVRSBOT1QgTlVMTCk7CklOU0VSVCBJTlRP IHQwIFZBTFVFUyAoJygsKScpOwpJTlNFUlQgSU5UTyB0MCBWQUxVRVMgKCcoTlVMTCwpJyk7CklO U0VSVCBJTlRPIHQwIFZBTFVFUyAoJygsTlVMTCknKTsKClNFTEVDVCBDT1VOVChjMCkgRlJPTSB0 MCA7CiBjb3VudAotLS0tLS0tCiAgICAgMwoKU0VMRUNUIENPVU5UKGMwKSBGUk9NIHQwIFdIRVJF IGMwIElTIE5PVCBOVUxMOwogY291bnQKLS0tLS0tLQogICAgIDAKClNFTEVDVCBDT1VOVChjMCkg RlJPTSB0MCBXSEVSRSBjMCBJUyBOVUxMOwogY291bnQKLS0tLS0tLQogICAgIDEKClNFTEVDVCBD T1VOVChjMCkgRlJPTSB0MCBXSEVSRSBjMCBJUyBOVUxMIE9SIGMwIElTIE5PVCBOVUxMOwogY291 bnQKLS0tLS0tLQogICAgIDEKCgpTRUxFQ1QgVkVSU0lPTigpCnZlcnNpb24KLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiBQb3N0Z3Jl U1FMIDE3LjUgKERlYmlhbiAxNy41LTEucGdkZzEyMCsxKSBvbiB4ODZfNjQtcGMtbGludXgtZ251 LCBjb21waWxlZApieSBnY2MgKERlYmlhbiAxMi4yLjAtMTQpIDEyLjIuMCwgNjQtYml0CgpUaGFu a3MgZm9yIHlvdSB0aW1lLgoKQmVzdCByZWdhcmRzLApKaW5odWkKCg== --===============3787512172336205586==--