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 1u95br-00FFaH-IN for pgsql-bugs@arkaria.postgresql.org; Sun, 27 Apr 2025 17:16:07 +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 1u95bp-009reB-Kx for pgsql-bugs@arkaria.postgresql.org; Sun, 27 Apr 2025 17:16:06 +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 1u95Ci-009kVc-Be for pgsql-bugs@lists.postgresql.org; Sun, 27 Apr 2025 16:50:09 +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 1u95Cg-002EzR-07 for pgsql-bugs@lists.postgresql.org; Sun, 27 Apr 2025 16:50:08 +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=fN6QsZec2akKSIdCmtYw7GMI6qLKURFCfSFHVDcsUZ0=; b=c0Ofvkee2eMoxSO/mha7nU8DVs J/rNGpJ0wCOyLBfZMXf24f+hQGGYzusHs+oUzTbIWV9LoViMlANmccEta/6Ul4iK1vFPS2J5bu+UV Bon5ojEVgMSlDPfzE6ZHKXVjFVO5ib43lof3RDuFqeciYPeSknm1L1ZKqxlv+ryzJbU9QeXu0Arui ZrLBaisBxU1FJwM/fUCz3r2S0dMR776oFIWkdpc49kKznfHPoIVmxJyxXCyaJ0ubCwRr6f4XrxdrC vICAkRFKSln6K776s0usSNsNLhYiygyHiLaD9gOcu084+qNqJYSEqb8sDsC0t/7tQ6NDxmtXQri5q QpIFkAkA==; 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 1u95Ce-006ZOr-0G for pgsql-bugs@lists.postgresql.org; Sun, 27 Apr 2025 16:50:05 +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 1u95Cc-000hnk-5t for pgsql-bugs@lists.postgresql.org; Sun, 27 Apr 2025 16:50:02 +0000 Content-Type: multipart/mixed; boundary="===============2956022153089351461==" MIME-Version: 1.0 Subject: BUG #18905: The opposite WHERE clause intersects and is always an empty set. It should perform no action. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jh.lai@qq.com Reply-To: jh.lai@qq.com, pgsql-bugs@lists.postgresql.org Date: Sun, 27 Apr 2025 16:49:24 +0000 Message-ID: <18905-f17e775841805cda@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 --===============2956022153089351461== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODkwNQpMb2dnZWQgYnk6ICAgICAgICAgIGppbmh1aSBsYWkKRW1haWwg YWRkcmVzczogICAgICBqaC5sYWlAcXEuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTcuNApPcGVy YXRpbmcgc3lzdGVtOiAgIHVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAgICAgIAoKRGVhciBQ b3N0Z3JlU1FMIERldmVsb3BlcjoKU2luY2UgcTEgYW5kIHEyIGhhdmUgb3Bwb3NpdGUgV0hFUkUg Y2xhdXNlIChlLmcuLCA+IGFuZCA8PSwgPSBhbmQgIT0pLCBxMQpJTlRFUlNFQ1QgcTIgc2hvdWxk IGFsd2F5cyBwcm9kdWNlIGVtcHR5IHNldCBhbmQgd2l0aG91dCBwaHlzaWNhbCByZWFkLgpxMTog U0VMRUNUICogRlJPTSBwZ2JlbmNoX2FjY291bnRzIGEgQ1JPU1MgSk9JTiBwZ2JlbmNoX3RlbGxl cnMgV0hFUkUgYS5haWQKPiA1MDAwMDsKcTI6U0VMRUNUICogRlJPTSBwZ2JlbmNoX2FjY291bnRz IGEgQ1JPU1MgSk9JTiBwZ2JlbmNoX3RlbGxlcnMgV0hFUkUgYS5haWQKPD0gNTAwMDA7Ckhvd2V2 ZXIsIFBvc3RncmVTUUwgYWN0dWFsbHkgZXhlY3V0ZWQgc3VjaCBhbiB1bm5lY2Vzc2FyeSBxdWVy eS4gSSB0aGluawpzdWNoIHF1ZXJpZXMgc2hvdWxkIGJlIG9wdGltaXplZC4KQmVzdCByZWdhcmRz LAoxLiBIb3cgdG8gcmVwZWF0Pwpkb2NrZXIgcHVsbCBwb3N0Z3JlczpsYXRlc3QKZG9ja2VyIHJ1 biAtLW5hbWUgcG9zdGdyZXMgLWUgUE9TVEdSRVNfUEFTU1dPUkQ9MTIxMyAtZCAtcCA1NDMyOjU0 MzIKcG9zdGdyZXMKZG9ja2VyIGV4ZWMgLWl0IHBvc3RncmVzIHBzcWwgLVUgcG9zdGdyZXMgLWMg IkNSRUFURSBEQVRBQkFTRSB0ZXN0ZGI7Igpkb2NrZXIgZXhlYyAtaXQgcG9zdGdyZXMgcGdiZW5j aCAtVSBwb3N0Z3JlcyAtaSAtcyAxMCB0ZXN0ZGIKZG9ja2VyIGV4ZWMgLWl0ICBwb3N0Z3JlcyBw c3FsIC1VIHBvc3RncmVzCnBzcWwgKDE3LjQgKERlYmlhbiAxNy40LTEucGdkZzEyMCsyKSkKVHlw ZSAiaGVscCIgZm9yIGhlbHAuClx0aW1pbmcgb24KXGMgdGVzdGRiClNFTEVDVCAqIEZST00gcGdi ZW5jaF9hY2NvdW50cyBhIENST1NTIEpPSU4gcGdiZW5jaF90ZWxsZXJzIFdIRVJFIGEuYWlkID4K NTAwMDAKSU5URVJTRUNUClNFTEVDVCAqIEZST00gcGdiZW5jaF9hY2NvdW50cyBhIENST1NTIEpP SU4gcGdiZW5jaF90ZWxsZXJzIFdIRVJFIGEuYWlkIDw9CjUwMDAwOwogYWlkIHwgYmlkIHwgYWJh bGFuY2UgfCBmaWxsZXIgfCB0aWQgfCBiaWQgfCB0YmFsYW5jZSB8IGZpbGxlcgotLS0tLSstLS0t LSstLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tKy0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0KKDAg cm93cykKVGltZTogOTQwNzMuMzcyIG1zICgwMTozNC4wNzMpCjIuIFdoYXQgZG8gaSBleHBlY3Qg dG8gc2VlPwpTRUxFQ1QgKiBGUk9NIHBnYmVuY2hfYWNjb3VudHMgYSBDUk9TUyBKT0lOIHBnYmVu Y2hfdGVsbGVycyBXSEVSRSBhLmFpZCA+CjUwMDAwCklOVEVSU0VDVApTRUxFQ1QgKiBGUk9NIHBn YmVuY2hfYWNjb3VudHMgYSBDUk9TUyBKT0lOIHBnYmVuY2hfdGVsbGVycyBXSEVSRSBhLmFpZCA8 PQo1MDAwMDsKIGFpZCB8IGJpZCB8IGFiYWxhbmNlIHwgZmlsbGVyIHwgdGlkIHwgYmlkIHwgdGJh bGFuY2UgfCBmaWxsZXIKLS0tLS0rLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLSstLS0tLSstLS0t LSstLS0tLS0tLS0tKy0tLS0tLS0tCigwIHJvd3MpClRpbWU6IDAueHh4IG1zIChmZXcgdGltZSkK My4gV2hhdCBkbyBpIHNlZSBpbnN0ZWFkClNFTEVDVCAqIEZST00gcGdiZW5jaF9hY2NvdW50cyBh IENST1NTIEpPSU4gcGdiZW5jaF90ZWxsZXJzIFdIRVJFIGEuYWlkID4KNTAwMDAKSU5URVJTRUNU ClNFTEVDVCAqIEZST00gcGdiZW5jaF9hY2NvdW50cyBhIENST1NTIEpPSU4gcGdiZW5jaF90ZWxs ZXJzIFdIRVJFIGEuYWlkIDw9CjUwMDAwOwogYWlkIHwgYmlkIHwgYWJhbGFuY2UgfCBmaWxsZXIg fCB0aWQgfCBiaWQgfCB0YmFsYW5jZSB8IGZpbGxlcgotLS0tLSstLS0tLSstLS0tLS0tLS0tKy0t LS0tLS0tKy0tLS0tKy0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0KKDAgcm93cykKVGltZTogOTQw NzMuMzcyIG1zICgwMTozNC4wNzMpCgo= --===============2956022153089351461==--