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 1uFYfd-005osg-9l for pgsql-bugs@arkaria.postgresql.org; Thu, 15 May 2025 13:30:45 +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 1uFYfc-00Egok-9o for pgsql-bugs@arkaria.postgresql.org; Thu, 15 May 2025 13:30:44 +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 1uFSzl-00CmxE-QG for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 07:27: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 1uFSzi-001sut-1j for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 07:27: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=LjwarO6vyJ1YaR8HlQRo90fFCns8hhJtKwxwYvBIcXU=; b=5epWzQA8M0OwlE1cllWJG7lqDT bL5FKfm+A2vV4luCuX47dxXBnzX/mBz3BfER7a8X1TJRQmAX05wxrWXimnisBB/YdYj+GDGsLav1s 8qD/Ys6Wa9zzPVlkF/gJ2FRy4H1IRHesRAiemmTpjK0fSzvyowm0YcpBHQdh4uBwislAU/k0kByF/ 5Ge2P8JUWIYrgbHgw1g9n61r0fMkmoUPK3GF4PyQrPgMTFZhrRDbZnSFlpJ2p3VZiWf5C7mQGzWOE MZ8BxUk1AbkLA6FDBeO592kXMl1Bc7rZH5tcXHxKZvxevXGsJ0Y4AwAZayiaEIuW6HjVLTgbA7u03 qcgTId4w==; 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 1uFSzf-005N7F-Qw for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 07:27:06 +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 1uFSze-005QuZ-8M for pgsql-bugs@lists.postgresql.org; Thu, 15 May 2025 07:27:02 +0000 Content-Type: multipart/mixed; boundary="===============1487498830916709739==" MIME-Version: 1.0 Subject: BUG #18930: PostgreSQL fails to handle INTERSECT 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 07:26:12 +0000 Message-ID: <18930-16f1cfe323194f2e@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 --===============1487498830916709739== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODkzMApMb2dnZWQgYnk6ICAgICAgICAgIGppbmh1aSBsYWkKRW1haWwg YWRkcmVzczogICAgICBqaW5odWlsYWlAZW1haWwubmN1LmVkdS5jbgpQb3N0Z3JlU1FMIHZlcnNp b246IDE3LjUKT3BlcmF0aW5nIHN5c3RlbTogICB1YnVudHUgMjIuMDQKRGVzY3JpcHRpb246ICAg ICAgICAKCkhpLCBQb3N0Z3JlU1FMIERldmVsb3BlcnMsClBsZWFzZSBjb25zaWRlciBzdWNoIHF1 ZXJpZXM6ClNFTEVDVCAqIEZST00gZW1wdHlfdGFibGUgSU5URVJTRUNUIFNFTEVDVCAqIEZST00g bm90X2VtcHR5X3RhYmxlOwpTRUxFQ1QgKiBGUk9NIG5vdF9lbXB0eV90YWJsZSBJTlRFUlNFQ1Qg U0VMRUNUICogRlJPTSBlbXB0eV90YWJsZTsKT2J2aW91c2x5LCB0aGUgYWJvdmUgcXVlcmllcyBh bHdheXMgcmV0dXJucyBhbiBlbXB0eSBzZXQuIEkgdGhpbmsgaXQgc2hvdWxkCnJldHVybiBhbiBl bXB0eSBzZXQgcXVpY2tseS4gSG93ZXZlciwgaXQgd2FzdGUgbXVjaCB0aW1lLiBQb3N0Z3JlU1FM IGZhaWxzCnRvIG9wdGltaXplIHF1ZXJpZXMgY29udGFpbmluZyBJTlRFUlNFQ1Qgb3BlcmF0aW9u cyB3aGVuIG9uZSBicmFuY2ggaW5jbHVkZXMKYW4gZW1wdHkgdGFibGUuIFRoaXMgbGVhZHMgdG8g dW5uZWNlc3NhcnkgbWVtb3J5IGNvbnN1bXB0aW9uIGFuZCBxdWVyeQpjYW5jZWxsYXRpb24sIGV2 ZW4gdGhvdWdoIHRoZSByZXN1bHQgc2hvdWxkIGJlIGRldGVybWluaXN0aWNhbGx5IGVtcHR5LgpJ IHRoaW5rIHRoaXMgaXMgYSBjb21tb24gY2FzZSBpbiBhY3R1YWwgcHJvZHVjdGlvbiBzY2VuYXJp b3MuIEl0J3MgaW1wb3J0YW50CnRvIGNsYXJpZnkgdGhhdCB1c2VycyBtaWdodCBub3QgaW50ZW50 aW9uYWxseSBwZXJmb3JtIElOVEVSU0VDVCBvcGVyYXRpb25zCm9uIGVtcHR5IHRhYmxlcy4gUmF0 aGVyLCB0aGV5IG1heSBiZSB1bmF3YXJlIHRoYXQgYSB0YWJsZSBpcyBlbXB0eSAuIEZvcgpleGFt cGxlLCB3aGVuIGRhdGEgaGFzIGJlZW4gZGVsZXRlZCBieSBhbm90aGVyIHVzZXIgb3IgcHJvY2Vz cy4gSWYKUG9zdGdyZVNRTCBjYW4gYWRkcmVzcyB0aGlzIHBlcmZvcm1hbmNlIGJ1ZywgaXQgd291 bGQgc2lnbmlmaWNhbnRseSBpbXByb3ZlCnF1ZXJ5IGVmZmljaWVuY3kgYW5kIHNhdmUgdXNlcnMg dmFsdWFibGUgdGltZSBpbiBzdWNoIGNhc2VzLgpUaGFuayB5b3UgZm9yIHlvdXIgdmFsdWFibGUg dGltZSwgbG9va2luZyBmb3J3YXJkIHRvIHlvdXIgcmVwbHkhCkJlc3QgcmVnYXJkLApKaW5odWkg TGFpCllvdSBjYW4gcmVwcm9kdWNlIHRoZSBidWcgYXMgZm9sbG93IHN0ZXBzOgpwc3FsIC1VIHBv c3RncmVzIC1jICJDUkVBVEUgREFUQUJBU0UgdGVzdGRiOyIKcGdiZW5jaCAtVSBwb3N0Z3JlcyAt aSAtcyAxMDAwIHRlc3RkYgpwc3FsIC1VIHBvc3RncmVzClx0aW1pbmcgb24KXGMgdGVzdGRiOwp0 ZXN0ZGI9IyBDUkVBVEUgVEFCTEUgZW1wdHlfdGFibGUgQVMgU0VMRUNUICogRlJPTSBwZ2JlbmNo X2FjY291bnRzIExJTUlUIDA7ClNFTEVDVCAwClRpbWU6IDMuMTExIG1zCnRlc3RkYj0jIFNFTEVD VCAqIEZST00gZW1wdHlfdGFibGUgSU5URVJTRUNUIFNFTEVDVCAqIEZST00gcGdiZW5jaF9hY2Nv dW50czsKIGFpZCB8IGJpZCB8IGFiYWxhbmNlIHwgZmlsbGVyCi0tLS0tKy0tLS0tKy0tLS0tLS0t LS0rLS0tLS0tLS0KKDAgcm93cykKVGltZTogMTYyMzYuODQ1IG1zICgwMDoxNi4yMzcpIC0tIGV4 cGVjdCBsZXNzIHRpbWUKdGVzdGRiPSMgZXhwbGFpbiBTRUxFQ1QgKiBGUk9NIGVtcHR5X3RhYmxl IElOVEVSU0VDVCBTRUxFQ1QgKiBGUk9NCnBnYmVuY2hfYWNjb3VudHM7CiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KIEhhc2hTZXRPcCBJbnRlcnNlY3QgIChjb3N0PTAuMDAu LjUxMzkzNjIuMzUgcm93cz0yMDAgd2lkdGg9MzU2KQogICAtPiAgQXBwZW5kICAoY29zdD0wLjAw Li40MTM5MzYwLjI1IHJvd3M9MTAwMDAwMjEwIHdpZHRoPTM1NikKICAgICAgICAgLT4gIFN1YnF1 ZXJ5IFNjYW4gb24gIipTRUxFQ1QqIDEiICAoY29zdD0wLjAwLi4xNC4yMCByb3dzPTIxMAp3aWR0 aD0zNTYpCiAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBlbXB0eV90YWJsZSAgKGNvc3Q9 MC4wMC4uMTIuMTAgcm93cz0yMTAKd2lkdGg9MzUyKQogICAgICAgICAtPiAgU3VicXVlcnkgU2Nh biBvbiAiKlNFTEVDVCogMiIgIChjb3N0PTAuMDAuLjM2MzkzNDUuMDAKcm93cz0xMDAwMDAwMDAg d2lkdGg9MTAxKQogICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gcGdiZW5jaF9hY2NvdW50 cyAgKGNvc3Q9MC4wMC4uMjYzOTM0NS4wMApyb3dzPTEwMDAwMDAwMCB3aWR0aD05NykKIEpJVDoK ICAgRnVuY3Rpb25zOiA2CiAgIE9wdGlvbnM6IElubGluaW5nIHRydWUsIE9wdGltaXphdGlvbiB0 cnVlLCBFeHByZXNzaW9ucyB0cnVlLCBEZWZvcm1pbmcKdHJ1ZQooOSByb3dzKQpUaW1lOiAxLjQ0 NiBtcwp0ZXN0ZGI9IyBTRUxFQ1QgKiBGUk9NIHBnYmVuY2hfYWNjb3VudHMgSU5URVJTRUNUIFNF TEVDVCAqIEZST00gZW1wdHlfdGFibGU7CiBhaWQgfCBiaWQgfCBhYmFsYW5jZSB8IGZpbGxlcgot LS0tLSstLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tCigwIHJvd3MpClRpbWU6IDE2MzAzLjUyMCBt cyAoMDA6MTYuMzA0KSAgLS0gZXhwZWN0IGxlc3MgdGltZQp0ZXN0ZGI9IyBleHBsYWluIFNFTEVD VCAqIEZST00gcGdiZW5jaF9hY2NvdW50cyBJTlRFUlNFQ1QgU0VMRUNUICogRlJPTQplbXB0eV90 YWJsZTsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBM QU4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogSGFzaFNldE9wIElu dGVyc2VjdCAgKGNvc3Q9MC4wMC4uNTEzOTM2Mi4zNSByb3dzPTIwMCB3aWR0aD0zNTYpCiAgIC0+ ICBBcHBlbmQgIChjb3N0PTAuMDAuLjQxMzkzNjAuMjUgcm93cz0xMDAwMDAyMTAgd2lkdGg9MzU2 KQogICAgICAgICAtPiAgU3VicXVlcnkgU2NhbiBvbiAiKlNFTEVDVCogMiIgIChjb3N0PTAuMDAu LjE0LjIwIHJvd3M9MjEwCndpZHRoPTM1NikKICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9u IGVtcHR5X3RhYmxlICAoY29zdD0wLjAwLi4xMi4xMCByb3dzPTIxMAp3aWR0aD0zNTIpCiAgICAg ICAgIC0+ICBTdWJxdWVyeSBTY2FuIG9uICIqU0VMRUNUKiAxIiAgKGNvc3Q9MC4wMC4uMzYzOTM0 NS4wMApyb3dzPTEwMDAwMDAwMCB3aWR0aD0xMDEpCiAgICAgICAgICAgICAgIC0+ICBTZXEgU2Nh biBvbiBwZ2JlbmNoX2FjY291bnRzICAoY29zdD0wLjAwLi4yNjM5MzQ1LjAwCnJvd3M9MTAwMDAw MDAwIHdpZHRoPTk3KQogSklUOgogICBGdW5jdGlvbnM6IDYKICAgT3B0aW9uczogSW5saW5pbmcg dHJ1ZSwgT3B0aW1pemF0aW9uIHRydWUsIEV4cHJlc3Npb25zIHRydWUsIERlZm9ybWluZwp0cnVl Cig5IHJvd3MpClRpbWU6IDEuNzMyIG1zCgo= --===============1487498830916709739==--