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 1uFaKv-006D3M-9D for pgsql-bugs@arkaria.postgresql.org; Thu, 15 May 2025 15:17:30 +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 1uFaKu-00FEHU-C5 for pgsql-bugs@arkaria.postgresql.org; Thu, 15 May 2025 15:17:28 +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 1uFYre-00El2x-34 for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 13:43: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 1uFYrZ-001vY7-2n for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 13:43: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=DI10O4iunRUPsTiEzBlco053Qtipup/4yA9+7g4eGes=; b=DkFR1E0qNE27w+UDYHNfArvoyP pTNeBJ7eTUzYgJoTrhO7ruP1gwoFN8A32+N4hN0CgxF6JcPRO9ZxN4Q/HvfIbEsqfZR1SOWOCCxv6 /oWyTgk843cAWwZpNk2jSdMbGQyWIzGPG+TYC7xrM1fH82Jm34auiLUg6k6Lbaa2xl22jMnk+5XvL H1Evoy5pl+uiNhBCs1QuRc09VC7XQdNfNJa7X3fGMo7aw3/UHU2wf3UVP+CZSsYjTFblyzPhi/coO 2jiStmlbioY0MyjHK0Ar6lMzlOFA3gWIZgV49dLPK2JqB8WBhZf9PR86Bq9IE2+Eds+d4gFQQmpFx Kjd5ZRpQ==; 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 1uFYrY-005UfT-B6 for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 13:43: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 1uFYrX-0060Us-6y for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 13:43:03 +0000 Content-Type: multipart/mixed; boundary="===============1521721531873707148==" MIME-Version: 1.0 Subject: BUG #18933: PostgreSQL fails to handle JOIN operation involving 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:42:30 +0000 Message-ID: <18933-85d850c7526716f6@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 --===============1521721531873707148== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODkzMwpMb2dnZWQgYnk6ICAgICAgICAgIGppbmh1aSBsYWkKRW1haWwg YWRkcmVzczogICAgICBqaW5odWlsYWlAZW1haWwubmN1LmVkdS5jbgpQb3N0Z3JlU1FMIHZlcnNp b246IDE3LjUKT3BlcmF0aW5nIHN5c3RlbTogICB1YnVudHUgMjIuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCkhpLCBQb3N0Z3JlU1FMIERldmVsb3BlcnMsCkhpLCBQb3N0Z3JlU1FMIERldmVsb3Bl cnMsClBsZWFzZSBjb25zaWRlciBzdWNoIHF1ZXJpZXM6ClNFTEVDVCAqIEZST00gZW1wdHlfdGFi bGUgQ1JPU1MgIEpPSU4gbm90X2VtcHR5X3RhYmxlOwpTRUxFQ1QgKiBGUk9NIG5vdF9lbXB0eV90 YWJsZSBDUk9TUyAgSk9JTiBlbXB0eV90YWJsZTsKU0VMRUNUICogRlJPTSBlbXB0eV90YWJsZSwg bm90X2VtcHR5X3RhYmxlOwpTRUxFQ1QgKiBGUk9NIG5vdF9lbXB0eV90YWJsZSwgZW1wdHlfdGFi bGU7Ci4uLgpPYnZpb3VzbHksIHRoZSBhYm92ZSBxdWVyaWVzIGFsd2F5cyByZXR1cm5zIGFuIGVt cHR5IHNldC4gSSB0aGluayBpdCBzaG91bGQKcmV0dXJuIGFuIGVtcHR5IHNldCBxdWlja2x5LiBI b3dldmVyLCBpdCB3YXN0ZSBtdWNoIHRpbWUuIFBvc3RncmVTUUwgZmFpbHMKdG8gb3B0aW1pemUg cXVlcmllcyBjb250YWluaW5nIEpPSU4gb3BlcmF0aW9ucyB3aGVuIGludm9sdmluZyBFbXB0eSBU YWJsZS4KVGhpcyBsZWFkcyB0byB1bm5lY2Vzc2FyeSBtZW1vcnkgY29uc3VtcHRpb24gYW5kIHF1 ZXJ5IGNhbmNlbGxhdGlvbiwgZXZlbgp0aG91Z2ggdGhlIHJlc3VsdCBzaG91bGQgYmUgZGV0ZXJt aW5pc3RpY2FsbHkgZW1wdHkuCkkgdGhpbmsgdGhpcyBpcyBhIGNvbW1vbiBjYXNlIGluIGFjdHVh bCBwcm9kdWN0aW9uIHNjZW5hcmlvcy4gSXQncyBpbXBvcnRhbnQKdG8gY2xhcmlmeSB0aGF0IHVz ZXJzIG1pZ2h0IG5vdCBpbnRlbnRpb25hbGx5IHBlcmZvcm1KT0lOIG9wZXJhdGlvbnMgb24KZW1w dHkgdGFibGVzLiBSYXRoZXIsIHRoZXkgbWF5IGJlIHVuYXdhcmUgdGhhdCBhIHRhYmxlIGlzIGVt cHR5IC4gRm9yCmV4YW1wbGUsIHdoZW4gZGF0YSBoYXMgYmVlbiBkZWxldGVkIGJ5IGFub3RoZXIg dXNlciBvciBwcm9jZXNzLiBJZgpQb3N0Z3JlU1FMIGNhbiBhZGRyZXNzIHRoaXMgcGVyZm9ybWFu Y2UgYnVnLCBpdCB3b3VsZCBzaWduaWZpY2FudGx5IGltcHJvdmUKcXVlcnkgZWZmaWNpZW5jeSBh bmQgc2F2ZSB1c2VycyB2YWx1YWJsZSB0aW1lIGluIHN1Y2ggY2FzZXMuClRoYW5rIHlvdSBmb3Ig eW91ciB2YWx1YWJsZSB0aW1lLCBsb29raW5nIGZvcndhcmQgdG8geW91ciByZXBseSEKQmVzdCBy ZWdhcmQsCkppbmh1aSBMYWkKWW91IGNhbiByZXByb2R1Y2UgdGhlIGJ1ZyBhcyBmb2xsb3cgc3Rl cHM6CnBzcWwgLVUgcG9zdGdyZXMgLWMgIkNSRUFURSBEQVRBQkFTRSB0ZXN0ZGI7IgpwZ2JlbmNo IC1VIHBvc3RncmVzIC1pIC1zIDEwMDAgdGVzdGRiCnBzcWwgLVUgcG9zdGdyZXMKXHRpbWluZyBv bgpcYyB0ZXN0ZGI7CnRlc3RkYj0jIFNFTEVDVCAqIEZST00gIHBnYmVuY2hfYWNjb3VudHMgQVMg YTEgQ1JPU1MgSk9JTiBwZ2JlbmNoX2FjY291bnRzCkFTIGEyICBDUk9TUyBKT0lOIGVtcHR5X3Rh YmxlOwpeQ0NhbmNlbCByZXF1ZXN0IHNlbnQKRVJST1I6ICBjYW5jZWxpbmcgc3RhdGVtZW50IGR1 ZSB0byB1c2VyIHJlcXVlc3QKVGltZTogMTMwMDkxNjAuMjQ0IG1zICgwMzozNjo0OS4xNjApCnRl c3RkYj0jIFNFTEVDVCAqIEZST00gcGdiZW5jaF9hY2NvdW50cyBDUk9TUyBKT0lOIGVtcHR5X3Rh YmxlOwogYWlkIHwgYmlkIHwgYWJhbGFuY2UgfCBmaWxsZXIgfCBhaWQgfCBiaWQgfCBhYmFsYW5j ZSB8IGZpbGxlcgotLS0tLSstLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tKy0tLS0tKy0t LS0tLS0tLS0rLS0tLS0tLS0KKDAgcm93cykKVGltZTogOTM0MS4xMDQgbXMgKDAwOjA5LjM0MSkK dGVzdGRiPSMgZXhwbGFpbiBTRUxFQ1QgKiBGUk9NIHBnYmVuY2hfYWNjb3VudHMgQ1JPU1MgSk9J TiBlbXB0eV90YWJsZTsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZ IFBMQU4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogTmVzdGVkIExvb3AgIChjb3N0PTAu MDAuLjI2NTEzOTM1Ny42MiByb3dzPTIxMDAwMDAwMDAwIHdpZHRoPTQ0OSkKICAgLT4gIFNlcSBT Y2FuIG9uIHBnYmVuY2hfYWNjb3VudHMgIChjb3N0PTAuMDAuLjI2MzkzNDUuMDAgcm93cz0xMDAw MDAwMDAKd2lkdGg9OTcpCiAgIC0+ICBNYXRlcmlhbGl6ZSAgKGNvc3Q9MC4wMC4uMTMuMTUgcm93 cz0yMTAgd2lkdGg9MzUyKQogICAgICAgICAtPiAgU2VxIFNjYW4gb24gZW1wdHlfdGFibGUgIChj b3N0PTAuMDAuLjEyLjEwIHJvd3M9MjEwIHdpZHRoPTM1MikKIEpJVDoKICAgRnVuY3Rpb25zOiAz CiAgIE9wdGlvbnM6IElubGluaW5nIHRydWUsIE9wdGltaXphdGlvbiB0cnVlLCBFeHByZXNzaW9u cyB0cnVlLCBEZWZvcm1pbmcKdHJ1ZQooNyByb3dzKQpUaW1lOiAxLjI0MSBtcwp0ZXN0ZGI9IyBT RUxFQ1QgKiBGUk9NIHBnYmVuY2hfYWNjb3VudHMsIGVtcHR5X3RhYmxlOwogYWlkIHwgYmlkIHwg YWJhbGFuY2UgfCBmaWxsZXIgfCBhaWQgfCBiaWQgfCBhYmFsYW5jZSB8IGZpbGxlcgotLS0tLSst LS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tKy0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0K KDAgcm93cykKVGltZTogOTQ5OS4xMDUgbXMgKDAwOjA5LjQ5OSkKdGVzdGRiPSMgZXhwbGFpbiBT RUxFQ1QgKiBGUk9NIHBnYmVuY2hfYWNjb3VudHMsIGVtcHR5X3RhYmxlOwogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTgotLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tCiBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC4wMC4uMjY1MTM5MzU3LjYyIHJvd3M9MjEwMDAw MDAwMDAgd2lkdGg9NDQ5KQogICAtPiAgU2VxIFNjYW4gb24gcGdiZW5jaF9hY2NvdW50cyAgKGNv c3Q9MC4wMC4uMjYzOTM0NS4wMCByb3dzPTEwMDAwMDAwMAp3aWR0aD05NykKICAgLT4gIE1hdGVy aWFsaXplICAoY29zdD0wLjAwLi4xMy4xNSByb3dzPTIxMCB3aWR0aD0zNTIpCiAgICAgICAgIC0+ ICBTZXEgU2NhbiBvbiBlbXB0eV90YWJsZSAgKGNvc3Q9MC4wMC4uMTIuMTAgcm93cz0yMTAgd2lk dGg9MzUyKQogSklUOgogICBGdW5jdGlvbnM6IDMKICAgT3B0aW9uczogSW5saW5pbmcgdHJ1ZSwg T3B0aW1pemF0aW9uIHRydWUsIEV4cHJlc3Npb25zIHRydWUsIERlZm9ybWluZwp0cnVlCig3IHJv d3MpClRpbWU6IDEuMTQ3IG1zCnRlc3RkYj0jIFNFTEVDVCAqIEZST00gZW1wdHlfdGFibGUgQ1JP U1MgSk9JTiBwZ2JlbmNoX2FjY291bnRzOwogYWlkIHwgYmlkIHwgYWJhbGFuY2UgfCBmaWxsZXIg fCBhaWQgfCBiaWQgfCBhYmFsYW5jZSB8IGZpbGxlcgotLS0tLSstLS0tLSstLS0tLS0tLS0tKy0t LS0tLS0tKy0tLS0tKy0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0KKDAgcm93cykKVGltZTogOTE4 Mi44NjMgbXMgKDAwOjA5LjE4MykKdGVzdGRiPSMgZXhwbGFpbiBTRUxFQ1QgKiBGUk9NIGVtcHR5 X3RhYmxlIENST1NTIEpPSU4gcGdiZW5jaF9hY2NvdW50czsKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQog TmVzdGVkIExvb3AgIChjb3N0PTAuMDAuLjI2NTEzOTM1Ny42MiByb3dzPTIxMDAwMDAwMDAwIHdp ZHRoPTQ0OSkKICAgLT4gIFNlcSBTY2FuIG9uIHBnYmVuY2hfYWNjb3VudHMgIChjb3N0PTAuMDAu LjI2MzkzNDUuMDAgcm93cz0xMDAwMDAwMDAKd2lkdGg9OTcpCiAgIC0+ICBNYXRlcmlhbGl6ZSAg KGNvc3Q9MC4wMC4uMTMuMTUgcm93cz0yMTAgd2lkdGg9MzUyKQogICAgICAgICAtPiAgU2VxIFNj YW4gb24gZW1wdHlfdGFibGUgIChjb3N0PTAuMDAuLjEyLjEwIHJvd3M9MjEwIHdpZHRoPTM1MikK IEpJVDoKICAgRnVuY3Rpb25zOiAzCiAgIE9wdGlvbnM6IElubGluaW5nIHRydWUsIE9wdGltaXph dGlvbiB0cnVlLCBFeHByZXNzaW9ucyB0cnVlLCBEZWZvcm1pbmcKdHJ1ZQooNyByb3dzKQpUaW1l OiAxLjExOCBtcwp0ZXN0ZGI9IyBTRUxFQ1QgKiBGUk9NICBwZ2JlbmNoX2FjY291bnRzIEFTIGEx IElOTkVSIEpPSU4gcGdiZW5jaF9hY2NvdW50cwpBUyBhMiBPTiBhMS5haWQgPWEyLmFpZCBDUk9T UyBKT0lOIGVtcHR5X3RhYmxlOwogYWlkIHwgYmlkIHwgYWJhbGFuY2UgfCBmaWxsZXIgfCBhaWQg fCBiaWQgfCBhYmFsYW5jZSB8IGZpbGxlciB8IGFpZCB8IGJpZCB8CmFiYWxhbmNlIHwgZmlsbGVy Ci0tLS0tKy0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0rLS0tLS0rLS0tLS0tLS0tLSst LS0tLS0tLSstLS0tLSstLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tCigwIHJvd3MpClRpbWU6IDM0 NjQ1LjA1NyBtcyAoMDA6MzQuNjQ1KQoK --===============1521721531873707148==--