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-00FFaG-Hg 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-009reC-IF 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 1u95SD-009mX2-La for pgsql-bugs@lists.postgresql.org; Sun, 27 Apr 2025 17:06:10 +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 1u95S9-002F4q-0x for pgsql-bugs@lists.postgresql.org; Sun, 27 Apr 2025 17:06:09 +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=+DV1QSAaRYcoT71fR05L9MVPHtJ6cu8VQE+37niO/tI=; b=IYD9qtV0VLTZdpl4Kqucr5ZQEq MaoleZz/klsUirzH45nNxB+ObJiTQCZ+/hH/byH9HDeqWWGuOY5El0YdqoNBRLO1rzcammP34ZqWQ Fkag8BKYlw1MIxneMIIpMIEZwrSqy/naINDMb30oXj2vVN+D5G945RffGeOOxan/LD9pHn50d3zqM WDd8xocQwo2QjLkxQfAlAkqerJFaZw3bpv2bMPDVimg5JPRdwdQNZ5PlrljmMHKP7Gv84IP1ph2IU FOh9AkperCVOOaUtPJd9fTkAeBnaBydcmYyx6cK6xWv5BW33J7j43Urgn20IWliQb57IxZdVNT/jy dsK+ztCA==; 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 1u95S7-006ZrX-83 for pgsql-bugs@lists.postgresql.org; Sun, 27 Apr 2025 17:06: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 1u95S5-000iPQ-TL for pgsql-bugs@lists.postgresql.org; Sun, 27 Apr 2025 17:06:02 +0000 Content-Type: multipart/mixed; boundary="===============2566838849406994298==" MIME-Version: 1.0 Subject: BUG #18906: EXCEPT with identical left/right queries isn't eliminated 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 17:05:54 +0000 Message-ID: <18906-30841e2ed429c5f8@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 --===============2566838849406994298== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODkwNgpMb2dnZWQgYnk6ICAgICAgICAgIGppbmh1aSBsYWkKRW1haWwg YWRkcmVzczogICAgICBqaC5sYWlAcXEuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTcuNApPcGVy YXRpbmcgc3lzdGVtOiAgIHVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAgICAgIAoKRGVhciBQ b3N0Z3JlU1FMIERldmVsb3BlcjoKcTEgRVhDRVBUIHExIHNob3VsZCBhbHdheXMgcmV0dXJuIGFu IGVtcHR5IHNldCBhbmQgY29uc3VtZSBtaW5pbWFsIGV4ZWN1dGlvbgp0aW1lLiBJdCBzaG91bGQg bm90IGJlIGV4ZWN1dGVkLCBidXQgdGhlIGVtcHR5IHNldCBpcyByZXR1cm5lZCBxdWlja2x5IGFu ZApkaXJlY3RseS4gIEhvd2V2ZXIsIFBvc3RncmVTUUwgYWN0dWFsbHkgZXhlY3V0ZWQgc3VjaCBh biB1bm5lY2Vzc2FyeSBxdWVyeS4KSSB0aGluayBzdWNoIHF1ZXJpZXMgc2hvdWxkIGJlIG9wdGlt aXplZC4KQmVzdCByZWdhcmRzLAoxLiBIb3cgdG8gcmVwZWF0Pwpkb2NrZXIgcHVsbCBwb3N0Z3Jl czpsYXRlc3QKZG9ja2VyIHJ1biAtLW5hbWUgcG9zdGdyZXMgLWUgUE9TVEdSRVNfUEFTU1dPUkQ9 MTIxMyAtZCAtcCA1NDMyOjU0MzIKcG9zdGdyZXMKZG9ja2VyIGV4ZWMgLWl0IHBvc3RncmVzIHBz cWwgLVUgcG9zdGdyZXMgLWMgIkNSRUFURSBEQVRBQkFTRSB0ZXN0ZGI7Igpkb2NrZXIgZXhlYyAt aXQgcG9zdGdyZXMgcGdiZW5jaCAtVSBwb3N0Z3JlcyAtaSAtcyAxMCB0ZXN0ZGIKZG9ja2VyIGV4 ZWMgLWl0ICBwb3N0Z3JlcyBwc3FsIC1VIHBvc3RncmVzCnBzcWwgKDE3LjQgKERlYmlhbiAxNy40 LTEucGdkZzEyMCsyKSkKVHlwZSAiaGVscCIgZm9yIGhlbHAuClx0aW1pbmcgb24KXGMgdGVzdGRi ClNFTEVDVCAqIEZST00gcGdiZW5jaF9hY2NvdW50cyBhIENST1NTIEpPSU4gcGdiZW5jaF90ZWxs ZXJzIFdIRVJFIGEuYWlkCj41MDAwMApFWENFUFQKU0VMRUNUICogRlJPTSBwZ2JlbmNoX2FjY291 bnRzIGEgQ1JPU1MgSk9JTiBwZ2JlbmNoX3RlbGxlcnMgV0hFUkUgYS5haWQgPgo1MDAwMDsKIGFp ZCB8IGJpZCB8IGFiYWxhbmNlIHwgZmlsbGVyIHwgdGlkIHwgYmlkIHwgdGJhbGFuY2UgfCBmaWxs ZXIKLS0tLS0rLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLSstLS0tLSstLS0tLSstLS0tLS0tLS0t Ky0tLS0tLS0tCigwIHJvd3MpClRpbWU6IDIzMTI5MC45MTYgbXMgKDAzOjUxLjI5MSkKMi4gV2hh dCBkbyBpIGV4cGVjdCB0byBzZWU/ClNFTEVDVCAqIEZST00gcGdiZW5jaF9hY2NvdW50cyBhIENS T1NTIEpPSU4gcGdiZW5jaF90ZWxsZXJzIFdIRVJFIGEuYWlkCj41MDAwMApFWENFUFQKU0VMRUNU ICogRlJPTSBwZ2JlbmNoX2FjY291bnRzIGEgQ1JPU1MgSk9JTiBwZ2JlbmNoX3RlbGxlcnMgV0hF UkUgYS5haWQgPgo1MDAwMDsKIGFpZCB8IGJpZCB8IGFiYWxhbmNlIHwgZmlsbGVyIHwgdGlkIHwg YmlkIHwgdGJhbGFuY2UgfCBmaWxsZXIKLS0tLS0rLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLSst LS0tLSstLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tCigwIHJvd3MpClRpbWU6IDAueHh4IG1zIChm ZXcgdGltZSkKMy4gV2hhdCBkbyBpICBzZWUgaW5zdGVhZD8KU0VMRUNUICogRlJPTSBwZ2JlbmNo X2FjY291bnRzIGEgQ1JPU1MgSk9JTiBwZ2JlbmNoX3RlbGxlcnMgV0hFUkUgYS5haWQKPjUwMDAw CkVYQ0VQVApTRUxFQ1QgKiBGUk9NIHBnYmVuY2hfYWNjb3VudHMgYSBDUk9TUyBKT0lOIHBnYmVu Y2hfdGVsbGVycyBXSEVSRSBhLmFpZCA+CjUwMDAwOwogYWlkIHwgYmlkIHwgYWJhbGFuY2UgfCBm aWxsZXIgfCB0aWQgfCBiaWQgfCB0YmFsYW5jZSB8IGZpbGxlcgotLS0tLSstLS0tLSstLS0tLS0t LS0tKy0tLS0tLS0tKy0tLS0tKy0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0KKDAgcm93cykKVGlt ZTogMjMxMjkwLjkxNiBtcyAoMDM6NTEuMjkxKQoK --===============2566838849406994298==--