Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nGLL1-0003D9-Tr for pgsql-bugs@arkaria.postgresql.org; Sat, 05 Feb 2022 13:42:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nGLL0-0001j2-Jh for pgsql-bugs@arkaria.postgresql.org; Sat, 05 Feb 2022 13:42:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nGE7J-00032c-3v for pgsql-bugs@lists.postgresql.org; Sat, 05 Feb 2022 06:00:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nGE7E-0004v2-LM for pgsql-bugs@lists.postgresql.org; Sat, 05 Feb 2022 06:00: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=JqXXt6fJ/+3CTYbFhIgv6KyUs1ybkyXb2pi3I9ltQD8=; b=E8JfYq1q5puQDLBGWUQF5Id1IN IWyVvzrfN1SZaUfeXL0XCUmDjBU3Y9ZTQ2pbNalfpINt93trHviD2aAzaETmWorGugnJz9YW2jT2g k+Bdw8t1MErxU6k2gX4JOGVVOohSrLgr4CYOQzYKOxY0+s6cIF53tYsxb76NRpUgaq2BKYBmmjBD3 i6bztT6BI2W2Ch24FZz5TFXr0vkCkEyHae5n8J93YODbIKig1EUrRs6TdfXU9Gi7s5bTxPOje73EW H2Lhzz4eAHq/no9mRcuFR+U7NxtWq8tMp1wQp6LjMhLiH8EZFDPCI2mK3oL0HepTjrvHBkrLeaguh ouQ2detA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nGE7C-0003l4-OX for pgsql-bugs@lists.postgresql.org; Sat, 05 Feb 2022 06:00:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nGE79-0004yp-7V for pgsql-bugs@lists.postgresql.org; Sat, 05 Feb 2022 06:00:03 +0000 Content-Type: multipart/mixed; boundary="===============1717376744857400013==" MIME-Version: 1.0 Subject: BUG #17395: Assert failed on merge join when foreign range partition contains out-of-range value To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 05 Feb 2022 06:00:01 +0000 Message-ID: <17395-8c326292078d1a57@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 --===============1717376744857400013== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzM5NQpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTQuMQpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyBxdWVyeToNCkNSRUFURSBFWFRFTlNJT04gcG9zdGdyZXNfZmR3 Ow0KRE8gJGQkDQogICAgQkVHSU4NCiAgICAgICAgRVhFQ1VURSAkJENSRUFURSBTRVJWRVIgbG9v cGJhY2sgRk9SRUlHTiBEQVRBIFdSQVBQRVIgcG9zdGdyZXNfZmR3DQogICAgICAgICAgICBPUFRJ T05TIChkYm5hbWUgJyQkfHxjdXJyZW50X2RhdGFiYXNlKCl8fCQkJywNCiAgICAgICAgICAgICAg ICAgICAgIHBvcnQgJyQkfHxjdXJyZW50X3NldHRpbmcoJ3BvcnQnKXx8JCQnDQogICAgICAgICAg ICApJCQ7DQogICAgRU5EOw0KJGQkOw0KQ1JFQVRFIFVTRVIgTUFQUElORyBGT1IgQ1VSUkVOVF9V U0VSIFNFUlZFUiBsb29wYmFjazsNCg0KQ1JFQVRFIFRBQkxFIGZwcnQyIChhIGludCkgUEFSVElU SU9OIEJZIFJBTkdFKGEpOw0KQ1JFQVRFIFRBQkxFIGZwcnQyX3AxIChMSUtFIGZwcnQyKTsNCkNS RUFURSBUQUJMRSBmcHJ0Ml9wMiAoTElLRSBmcHJ0Mik7DQpJTlNFUlQgSU5UTyBmcHJ0Ml9wMSBW QUxVRVMgKDIpOw0KSU5TRVJUIElOVE8gZnBydDJfcDIgVkFMVUVTICgxKTsNCg0KQ1JFQVRFIEZP UkVJR04gVEFCTEUgZnRwcnQyX3AxIFBBUlRJVElPTiBPRiBmcHJ0MiBGT1IgVkFMVUVTIEZST00g KDApIFRPCigxKQ0KICAgIFNFUlZFUiBsb29wYmFjayBPUFRJT05TICh0YWJsZV9uYW1lICdmcHJ0 Ml9wMScpOw0KQ1JFQVRFIEZPUkVJR04gVEFCTEUgZnRwcnQyX3AyIFBBUlRJVElPTiBPRiBmcHJ0 MiBGT1IgVkFMVUVTIEZST00gKDEpIFRPCigyKQ0KICAgIFNFUlZFUiBsb29wYmFjayBPUFRJT05T ICh0YWJsZV9uYW1lICdmcHJ0Ml9wMicsIHVzZV9yZW1vdGVfZXN0aW1hdGUKJ3RydWUnKTsNCg0K U0VMRUNUIHQxLmEgRlJPTSBmcHJ0MiB0MSBKT0lOIGZwcnQyIHQyIE9OICh0MS5hID0gdDIuYSk7 DQoNCmNhdXNlcyBhbiBhc3NlcnRpb24gZmFpbHVyZSB3aXRoIHRoZSBmb2xsb3dpbmcgc3RhY2s6 DQpDb3JlIHdhcyBnZW5lcmF0ZWQgYnkgYHBvc3RncmVzOiBsYXcgcmVncmVzc2lvbiBbbG9jYWxd IFNFTEVDVCAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICcuDQpQcm9ncmFt IHRlcm1pbmF0ZWQgd2l0aCBzaWduYWwgU0lHQUJSVCwgQWJvcnRlZC4NCiMwICBfX0dJX3JhaXNl IChzaWc9c2lnQGVudHJ5PTYpIGF0IC4uL3N5c2RlcHMvdW5peC9zeXN2L2xpbnV4L3JhaXNlLmM6 NTANCjUwICAgICAgLi4vc3lzZGVwcy91bml4L3N5c3YvbGludXgvcmFpc2UuYzogIE5vIHN1Y2gg ZmlsZSBvciBkaXJlY3RvcnkuDQooZ2RiKSBidA0KIzAgIF9fR0lfcmFpc2UgKHNpZz1zaWdAZW50 cnk9NikgYXQgLi4vc3lzZGVwcy91bml4L3N5c3YvbGludXgvcmFpc2UuYzo1MA0KIzEgIDB4MDAw MDdmYmFlMTczNzg1OSBpbiBfX0dJX2Fib3J0ICgpIGF0IGFib3J0LmM6NzkNCiMyICAweDAwMDA1 NTY2YzdkM2U3MmMgaW4gRXhjZXB0aW9uYWxDb25kaXRpb24gKGNvbmRpdGlvbk5hbWU9MHg1NTY2 YzdlZDBhMWEKImNvbXBhcmVSZXN1bHQgPCAwIiwgDQogICAgZXJyb3JUeXBlPTB4NTU2NmM3ZWQw N2YzICJGYWlsZWRBc3NlcnRpb24iLCBmaWxlTmFtZT0weDU1NjZjN2VkMDk1YQoibm9kZU1lcmdl am9pbi5jIiwgbGluZU51bWJlcj04OTgpDQogICAgYXQgYXNzZXJ0LmM6NjkNCiMzICAweDAwMDA1 NTY2Yzc5NGMyMDggaW4gRXhlY01lcmdlSm9pbiAocHN0YXRlPTB4NTU2NmM4NTBmYWEwKSBhdApu b2RlTWVyZ2Vqb2luLmM6ODk4DQojNCAgMHgwMDAwNTU2NmM3OTA0MWJhIGluIEV4ZWNQcm9jTm9k ZSAobm9kZT0weDU1NjZjODUwZmFhMCkgYXQKLi4vLi4vLi4vc3JjL2luY2x1ZGUvZXhlY3V0b3Iv ZXhlY3V0b3IuaDoyNTcNCiM1ICAweDAwMDA1NTY2Yzc5MDZkZDggaW4gRXhlY3V0ZVBsYW4gKGVz dGF0ZT0weDU1NjZjODUwZjgzMCwKcGxhbnN0YXRlPTB4NTU2NmM4NTBmYWEwLCB1c2VfcGFyYWxs ZWxfbW9kZT1mYWxzZSwgDQogICAgb3BlcmF0aW9uPUNNRF9TRUxFQ1QsIHNlbmRUdXBsZXM9dHJ1 ZSwgbnVtYmVyVHVwbGVzPTAsCmRpcmVjdGlvbj1Gb3J3YXJkU2NhbkRpcmVjdGlvbiwgZGVzdD0w eDU1NjZjODU3YTU2MCwgDQogICAgZXhlY3V0ZV9vbmNlPXRydWUpIGF0IGV4ZWNNYWluLmM6MTU1 MQ0KIzYgIDB4MDAwMDU1NjZjNzkwNDhmMSBpbiBzdGFuZGFyZF9FeGVjdXRvclJ1biAocXVlcnlE ZXNjPTB4NTU2NmM4NDQxYmIwLApkaXJlY3Rpb249Rm9yd2FyZFNjYW5EaXJlY3Rpb24sIGNvdW50 PTAsIA0KICAgIGV4ZWN1dGVfb25jZT10cnVlKSBhdCBleGVjTWFpbi5jOjM2MQ0KIzcgIDB4MDAw MDU1NjZjNzkwNDZkYyBpbiBFeGVjdXRvclJ1biAocXVlcnlEZXNjPTB4NTU2NmM4NDQxYmIwLApk aXJlY3Rpb249Rm9yd2FyZFNjYW5EaXJlY3Rpb24sIGNvdW50PTAsIA0KICAgIGV4ZWN1dGVfb25j ZT10cnVlKSBhdCBleGVjTWFpbi5jOjMwNQ0KIzggIDB4MDAwMDU1NjZjN2I4MWQzOCBpbiBQb3J0 YWxSdW5TZWxlY3QgKHBvcnRhbD0weDU1NjZjODQ4ZjFhMCwKZm9yd2FyZD10cnVlLCBjb3VudD0w LCBkZXN0PTB4NTU2NmM4NTdhNTYwKQ0KICAgIGF0IHBxdWVyeS5jOjkyMQ0KIzkgIDB4MDAwMDU1 NjZjN2I4MTk1YyBpbiBQb3J0YWxSdW4gKHBvcnRhbD0weDU1NjZjODQ4ZjFhMCwKY291bnQ9OTIy MzM3MjAzNjg1NDc3NTgwNywgaXNUb3BMZXZlbD10cnVlLCBydW5fb25jZT10cnVlLCANCiAgICBk ZXN0PTB4NTU2NmM4NTdhNTYwLCBhbHRkZXN0PTB4NTU2NmM4NTdhNTYwLCBxYz0weDdmZmM2NGQy NjlmMCkgYXQKcHF1ZXJ5LmM6NzY1DQojMTAgMHgwMDAwNTU2NmM3YjdhODQ2IGluIGV4ZWNfc2lt cGxlX3F1ZXJ5ICgNCiAgICBxdWVyeV9zdHJpbmc9MHg1NTY2Yzg0MjAyYTAgIlNFTEVDVCB0MS5h IEZST00gZnBydDIgdDEgSk9JTiBmcHJ0MiB0MiBPTgoodDEuYSA9IHQyLmEpOyIpIGF0IHBvc3Rn cmVzLmM6MTIxNA0KIzExIDB4MDAwMDU1NjZjN2I3ZjczNSBpbiBQb3N0Z3Jlc01haW4gKGFyZ2M9 MSwgYXJndj0weDdmZmM2NGQyNmMxMCwKZGJuYW1lPTB4NTU2NmM4NDRjM2Y4ICJyZWdyZXNzaW9u IiwgDQogICAgdXNlcm5hbWU9MHg1NTY2Yzg0NGMzZDggImxhdyIpIGF0IHBvc3RncmVzLmM6NDQ4 Ng0KIzEyIDB4MDAwMDU1NjZjN2FhM2UzZCBpbiBCYWNrZW5kUnVuIChwb3J0PTB4NTU2NmM4NDQz ZDEwKSBhdApwb3N0bWFzdGVyLmM6NDUzMA0KIzEzIDB4MDAwMDU1NjZjN2FhMzY5OCBpbiBCYWNr ZW5kU3RhcnR1cCAocG9ydD0weDU1NjZjODQ0M2QxMCkgYXQKcG9zdG1hc3Rlci5jOjQyNTINCiMx NCAweDAwMDA1NTY2YzdhOWY0OGQgaW4gU2VydmVyTG9vcCAoKSBhdCBwb3N0bWFzdGVyLmM6MTc0 NQ0KIzE1IDB4MDAwMDU1NjZjN2E5ZWJlYSBpbiBQb3N0bWFzdGVyTWFpbiAoYXJnYz0zLCBhcmd2 PTB4NTU2NmM4NDFhNTYwKSBhdApwb3N0bWFzdGVyLmM6MTQxNw0KIzE2IDB4MDAwMDU1NjZjNzk4 ZTBmNyBpbiBtYWluIChhcmdjPTMsIGFyZ3Y9MHg1NTY2Yzg0MWE1NjApIGF0IG1haW4uYzoyMDkN Cg0KUmVwcm9kdWNlZCBvbiBSRUxfMTJfU1RBQkxFLi5tYXN0ZXIuIE9uIFJFTF8xMV9TVEFCTEUg YW5kIGFsc28gd2hlbiB0aGUKc2VydmVyIGlzIGJ1aWx0IHdpdGhvdXQgYXNzZXJ0cyBTRUxFQ1Qg cmV0dXJucyB0d28gcm93cy4gVGhlIG9mZmVuZGluZwpjb21taXQgaXMgOTU5ZDAwZTlkLgoK --===============1717376744857400013==--