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 1uFYab-005ngy-Km for pgsql-bugs@arkaria.postgresql.org; Thu, 15 May 2025 13:25:34 +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 1uFYaa-00EZ2r-Mv for pgsql-bugs@arkaria.postgresql.org; Thu, 15 May 2025 13:25:32 +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 1uFYIr-00ETsv-0p for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 13:07: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 1uFYIo-001vIf-09 for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 13:07: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=zL1u9WMJHRqF/saAim+0zhx9lEfcDsN0dgTQgxDnosw=; b=B1jCTm/elNDZffPrvuHxZzC0uO bQa5jmrqCdVtuV0Q40boc1cWwc5uMwA1HHPaVd0spcMRmR1DoPrNXj62my5ZNdMo6NZuQ/TKcQIGa CtGz18h/Qf+wlpR6ff31xTPUQhDBOO9PuIJ78kNSWyfppg6QcrTDR00Fi9VyTyzO90XxvMB+e0Xkw HiwRH0J5M1BDDZ4v9yy8o25yddv3Z45Kwq30lN/CXR94+MUVieRw3aTljuJAIJWdSFUXxNqpAwR8u hqQo2K1JViWW1fttkyiRkEJtzUna05rbmTmxN5ztTMI7JtFg2d3uquzMRdmrwbNHpEnARcwO/GkQH GKfgDd0g==; 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 1uFYIi-005Txv-CV for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 13:07:10 +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 1uFYIg-005x3C-RE for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 13:07:02 +0000 Content-Type: multipart/mixed; boundary="===============7182408048728288095==" MIME-Version: 1.0 Subject: BUG #18932: PostgreSQL fails to handle EXCEPT operation when the left branch is an Empty Table To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jinhuilai@email.ncu.edu.cn Reply-To: jinhuilai@email.ncu.edu.cn, pgsql-bugs@lists.postgresql.org Date: Thu, 15 May 2025 13:06:35 +0000 Message-ID: <18932-3bf78b809a62a0ff@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 --===============7182408048728288095== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODkzMgpMb2dnZWQgYnk6ICAgICAgICAgIGppbmh1aSBsYWkKRW1haWwg YWRkcmVzczogICAgICBqaW5odWlsYWlAZW1haWwubmN1LmVkdS5jbgpQb3N0Z3JlU1FMIHZlcnNp b246IDE3LjUKT3BlcmF0aW5nIHN5c3RlbTogICB1YnVudHUgMjIuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCkhpLCBQb3N0Z3JlU1FMIERldmVsb3BlcnMsClBsZWFzZSBjb25zaWRlciBzdWNoIHF1 ZXJ5OgpTRUxFQ1QgKiBGUk9NIGVtcHR5X3RhYmxlIEVYQ0VQVCBTRUxFQ1QgKiBGUk9NIG5vdF9l bXB0eV90YWJsZTsKT2J2aW91c2x5LCB0aGUgYWJvdmUgcXVlcnkgYWx3YXlzIHJldHVybnMgYW4g ZW1wdHkgc2V0LiBJIHRoaW5rIGl0IHNob3VsZApyZXR1cm4gYW4gZW1wdHkgc2V0IHF1aWNrbHku IEhvd2V2ZXIsIGl0IHdhc3RlIG11Y2ggdGltZS4gUG9zdGdyZVNRTCBmYWlscwp0byBvcHRpbWl6 ZSBxdWVyaWVzIGNvbnRhaW5pbmcgRVhDRVBUIG9wZXJhdGlvbnMgd2hlbiB0aGUgbGVmdCBicmFu Y2ggaXMgYW4KRW1wdHkgVGFibGUuIFRoaXMgbGVhZHMgdG8gdW5uZWNlc3NhcnkgbWVtb3J5IGNv bnN1bXB0aW9uIGFuZCBxdWVyeQpjYW5jZWxsYXRpb24sIGV2ZW4gdGhvdWdoIHRoZSByZXN1bHQg c2hvdWxkIGJlIGRldGVybWluaXN0aWNhbGx5IGVtcHR5LgpJIHRoaW5rIHRoaXMgaXMgYSBjb21t b24gY2FzZSBpbiBhY3R1YWwgcHJvZHVjdGlvbiBzY2VuYXJpb3MuIEl0J3MgaW1wb3J0YW50CnRv IGNsYXJpZnkgdGhhdCB1c2VycyBtaWdodCBub3QgaW50ZW50aW9uYWxseSBwZXJmb3JtIEVYQ0VQ VCBvcGVyYXRpb25zIG9uCmVtcHR5IHRhYmxlcy4gUmF0aGVyLCB0aGV5IG1heSBiZSB1bmF3YXJl IHRoYXQgYSB0YWJsZSBpcyBlbXB0eSAuIEZvcgpleGFtcGxlLCB3aGVuIGRhdGEgaGFzIGJlZW4g ZGVsZXRlZCBieSBhbm90aGVyIHVzZXIgb3IgcHJvY2Vzcy4gSWYKUG9zdGdyZVNRTCBjYW4gYWRk cmVzcyB0aGlzIHBlcmZvcm1hbmNlIGJ1ZywgaXQgd291bGQgc2lnbmlmaWNhbnRseSBpbXByb3Zl CnF1ZXJ5IGVmZmljaWVuY3kgYW5kIHNhdmUgdXNlcnMgdmFsdWFibGUgdGltZSBpbiBzdWNoIGNh c2VzLgpUaGFuayB5b3UgZm9yIHlvdXIgdmFsdWFibGUgdGltZSwgbG9va2luZyBmb3J3YXJkIHRv IHlvdXIgcmVwbHkhCkJlc3QgcmVnYXJkLApKaW5odWkgTGFpCllvdSBjYW4gcmVwcm9kdWNlIHRo ZSBidWcgYXMgZm9sbG93IHN0ZXBzOgpwc3FsIC1VIHBvc3RncmVzIC1jICJDUkVBVEUgREFUQUJB U0UgdGVzdGRiOyIKcGdiZW5jaCAtVSBwb3N0Z3JlcyAtaSAtcyAxMDAwIHRlc3RkYgpwc3FsIC1V IHBvc3RncmVzClx0aW1pbmcgb24KXGMgdGVzdGRiOwp0ZXN0ZGI9IyBDUkVBVEUgVEFCTEUgZW1w dHlfdGFibGUgQVMgU0VMRUNUICogRlJPTSBwZ2JlbmNoX2FjY291bnRzIExJTUlUIDA7ClNFTEVD VCAwClRpbWU6IDMuMTExIG1zCnRlc3RkYj0jIFNFTEVDVCAqIEZST00gZW1wdHlfdGFibGUgRVhD RVBUIFNFTEVDVCAqIEZST00gcGdiZW5jaF9hY2NvdW50czsKIGFpZCB8IGJpZCB8IGFiYWxhbmNl IHwgZmlsbGVyCi0tLS0tKy0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0KKDAgcm93cykKVGltZTog MTYwNzcuODA0IG1zICgwMDoxNi4wNzgpIC0tIGV4cGVjdDogbGVzcyB0aW1lCnRlc3RkYj0jIGV4 cGxhaW4gU0VMRUNUICogRlJPTSBlbXB0eV90YWJsZSBFWENFUFQgU0VMRUNUICogRlJPTQpwZ2Jl bmNoX2FjY291bnRzOwogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg UVVFUlkgUExBTgotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiBIYXNo U2V0T3AgRXhjZXB0ICAoY29zdD0wLjAwLi41MTM5MzYyLjM1IHJvd3M9MjAwIHdpZHRoPTM1NikK ICAgLT4gIEFwcGVuZCAgKGNvc3Q9MC4wMC4uNDEzOTM2MC4yNSByb3dzPTEwMDAwMDIxMCB3aWR0 aD0zNTYpCiAgICAgICAgIC0+ICBTdWJxdWVyeSBTY2FuIG9uICIqU0VMRUNUKiAxIiAgKGNvc3Q9 MC4wMC4uMTQuMjAgcm93cz0yMTAKd2lkdGg9MzU2KQogICAgICAgICAgICAgICAtPiAgU2VxIFNj YW4gb24gZW1wdHlfdGFibGUgIChjb3N0PTAuMDAuLjEyLjEwIHJvd3M9MjEwCndpZHRoPTM1MikK ICAgICAgICAgLT4gIFN1YnF1ZXJ5IFNjYW4gb24gIipTRUxFQ1QqIDIiICAoY29zdD0wLjAwLi4z NjM5MzQ1LjAwCnJvd3M9MTAwMDAwMDAwIHdpZHRoPTEwMSkKICAgICAgICAgICAgICAgLT4gIFNl cSBTY2FuIG9uIHBnYmVuY2hfYWNjb3VudHMgIChjb3N0PTAuMDAuLjI2MzkzNDUuMDAKcm93cz0x MDAwMDAwMDAgd2lkdGg9OTcpCiBKSVQ6CiAgIEZ1bmN0aW9uczogNgogICBPcHRpb25zOiBJbmxp bmluZyB0cnVlLCBPcHRpbWl6YXRpb24gdHJ1ZSwgRXhwcmVzc2lvbnMgdHJ1ZSwgRGVmb3JtaW5n CnRydWUKKDkgcm93cykKVGltZTogMS42NzQgbXMKCg== --===============7182408048728288095==--