Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h4PAD-0004C8-0j for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Mar 2019 12:08:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h4PAA-0001AE-G2 for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Mar 2019 12:08:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h4OU0-0007S1-U4 for pgsql-bugs@lists.postgresql.org; Thu, 14 Mar 2019 11:25:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h4OTy-0005jn-8X for pgsql-bugs@lists.postgresql.org; Thu, 14 Mar 2019 11:25:08 +0000 Content-Type: multipart/mixed; boundary="===============1915499586846515927==" MIME-Version: 1.0 Subject: BUG #15694: Server crash in EXPLAIN with LATERAL and a partitioned table 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: Thu, 14 Mar 2019 11:24:27 +0000 Message-ID: <15694-74f2ca97e7044f7f@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1915499586846515927== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTY5NApMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTEuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAxOC4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKVGhlIGZvbGxvd2luZyBxdWVyeToNCkNSRUFURSBUQUJMRSBwcnQxX2wgKGEgaW50KSBQ QVJUSVRJT04gQlkgUkFOR0UoYSk7DQpDUkVBVEUgVEFCTEUgcHJ0Ml9sIChhIGludCk7DQoNCkVY UExBSU4NClNFTEVDVCAqIEZST00gcHJ0MV9sIHQxIExFRlQgSk9JTiBMQVRFUkFMDQogIChTRUxF Q1QgdDEuYSBhcyB0MWEsIHBydDFfbC5hIEZST00gcHJ0MV9sKSB0MiBPTiB0MS5hID0gdDIuYTsN Cg0KY3Jhc2hlcyB0aGUgc2VydmVyIHdpdGggdGhlIHN0YWNrIHRyYWNlOg0KQ29yZSB3YXMgZ2Vu ZXJhdGVkIGJ5IGBwb3N0Z3JlczogbGF3IHJlZ3Jlc3Npb24gW2xvY2FsXSBFWFBMQUlOICAgICAg ICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAnLg0KUHJvZ3JhbSB0ZXJtaW5hdGVkIHdp dGggc2lnbmFsIFNJR0FCUlQsIEFib3J0ZWQuDQojMCAgX19HSV9yYWlzZSAoc2lnPXNpZ0BlbnRy eT02KSBhdCAuLi9zeXNkZXBzL3VuaXgvc3lzdi9saW51eC9yYWlzZS5jOjUxDQo1MSAgICAgIC4u L3N5c2RlcHMvdW5peC9zeXN2L2xpbnV4L3JhaXNlLmM6IE5vIHN1Y2ggZmlsZSBvciBkaXJlY3Rv cnkuDQooZ2RiKSBidA0KIzAgIF9fR0lfcmFpc2UgKHNpZz1zaWdAZW50cnk9NikgYXQgLi4vc3lz ZGVwcy91bml4L3N5c3YvbGludXgvcmFpc2UuYzo1MQ0KIzEgIDB4MDAwMDdmNjU0OGNhNTgwMSBp biBfX0dJX2Fib3J0ICgpIGF0IGFib3J0LmM6NzkNCiMyICAweDAwMDA1NWExYTc5MDZlMTMgaW4g RXhjZXB0aW9uYWxDb25kaXRpb24gKA0KICAgIGNvbmRpdGlvbk5hbWU9Y29uZGl0aW9uTmFtZUBl bnRyeT0weDU1YTFhN2FhZmI4MAoiIShibXNfaXNfc3Vic2V0KGFwcGVuZHJlbC0+bGF0ZXJhbF9y ZWxpZHMsIHJlcXVpcmVkX291dGVyKSkiLCANCiAgICBlcnJvclR5cGU9ZXJyb3JUeXBlQGVudHJ5 PTB4NTVhMWE3OTVjNjFkICJGYWlsZWRBc3NlcnRpb24iLApmaWxlTmFtZT1maWxlTmFtZUBlbnRy eT0weDU1YTFhN2FhZjE2NCAicmVsbm9kZS5jIiwgDQogICAgbGluZU51bWJlcj1saW5lTnVtYmVy QGVudHJ5PTE1NDMpIGF0IGFzc2VydC5jOjU0DQojMyAgMHgwMDAwNTVhMWE3NzUyMTM1IGluIGdl dF9hcHBlbmRyZWxfcGFyYW1wYXRoaW5mbwooYXBwZW5kcmVsPWFwcGVuZHJlbEBlbnRyeT0weDU1 YTFhOGFlNTQ1OCwgDQogICAgcmVxdWlyZWRfb3V0ZXI9cmVxdWlyZWRfb3V0ZXJAZW50cnk9MHgw KSBhdCByZWxub2RlLmM6MTU0Mw0KIzQgIDB4MDAwMDU1YTFhNzc0Nzc4MyBpbiBjcmVhdGVfYXBw ZW5kX3BhdGggKHJvb3Q9cm9vdEBlbnRyeT0weDAsCnJlbD1yZWxAZW50cnk9MHg1NWExYThhZTU0 NTgsIA0KICAgIHN1YnBhdGhzPXN1YnBhdGhzQGVudHJ5PTB4MCwKcGFydGlhbF9zdWJwYXRocz1w YXJ0aWFsX3N1YnBhdGhzQGVudHJ5PTB4MCwKcmVxdWlyZWRfb3V0ZXI9cmVxdWlyZWRfb3V0ZXJA ZW50cnk9MHgwLCANCiAgICBwYXJhbGxlbF93b3JrZXJzPXBhcmFsbGVsX3dvcmtlcnNAZW50cnk9 MCwgcGFyYWxsZWxfYXdhcmU9ZmFsc2UsCnBhcnRpdGlvbmVkX3JlbHM9MHgwLCByb3dzPXJvd3NA ZW50cnk9LTEpDQogICAgYXQgcGF0aG5vZGUuYzoxMjUwDQojNSAgMHgwMDAwNTVhMWE3NzA1YmY3 IGluIHNldF9kdW1teV9yZWxfcGF0aGxpc3QKKHJlbD1yZWxAZW50cnk9MHg1NWExYThhZTU0NTgp IGF0IGFsbHBhdGhzLmM6MjAxOQ0KIzYgIDB4MDAwMDU1YTFhNzcwNmUwNCBpbiBzZXRfc3VicXVl cnlfcGF0aGxpc3QgKHJ0ZT08b3B0aW1pemVkIG91dD4sCnJ0aT08b3B0aW1pemVkIG91dD4sIHJl bD08b3B0aW1pemVkIG91dD4sIA0KICAgIHJvb3Q9PG9wdGltaXplZCBvdXQ+KSBhdCBhbGxwYXRo cy5jOjIyMDUNCiM3ICBzZXRfcmVsX3NpemUgKHJvb3Q9cm9vdEBlbnRyeT0weDU1YTFhOGFlMjE1 OCwKcmVsPXJlbEBlbnRyeT0weDU1YTFhOGFlNTQ1OCwgcnRpPXJ0aUBlbnRyeT00LCBydGU9PG9w dGltaXplZCBvdXQ+KQ0KICAgIGF0IGFsbHBhdGhzLmM6Mzc5DQojOCAgMHgwMDAwNTVhMWE3NzA3 ZGNkIGluIHNldF9iYXNlX3JlbF9zaXplcyAocm9vdD08b3B0aW1pemVkIG91dD4pIGF0CmFsbHBh dGhzLmM6MjgxDQojOSAgbWFrZV9vbmVfcmVsIChyb290PXJvb3RAZW50cnk9MHg1NWExYThhZTIx NTgsCmpvaW5saXN0PWpvaW5saXN0QGVudHJ5PTB4NTVhMWE4YWU1MDQwKSBhdCBhbGxwYXRocy5j OjE3OQ0KIzEwIDB4MDAwMDU1YTFhNzcyOWEzYSBpbiBxdWVyeV9wbGFubmVyIChyb290PXJvb3RA ZW50cnk9MHg1NWExYThhZTIxNTgsCnRsaXN0PXRsaXN0QGVudHJ5PTB4NTVhMWE4YWUzZTU4LCAN CiAgICBxcF9jYWxsYmFjaz1xcF9jYWxsYmFja0BlbnRyeT0weDU1YTFhNzcyYTZjMCA8c3RhbmRh cmRfcXBfY2FsbGJhY2s+LApxcF9leHRyYT1xcF9leHRyYUBlbnRyeT0weDdmZmVmODhjYjUyMCkN CiAgICBhdCBwbGFubWFpbi5jOjI2NQ0KIzExIDB4MDAwMDU1YTFhNzcyZTYxNyBpbiBncm91cGlu Z19wbGFubmVyIChyb290PXJvb3RAZW50cnk9MHg1NWExYThhZTIxNTgsCg0KICAgIGluaGVyaXRh bmNlX3VwZGF0ZT1pbmhlcml0YW5jZV91cGRhdGVAZW50cnk9ZmFsc2UsCnR1cGxlX2ZyYWN0aW9u PTxvcHRpbWl6ZWQgb3V0PiwgdHVwbGVfZnJhY3Rpb25AZW50cnk9MCkNCiAgICBhdCBwbGFubmVy LmM6MTkwOA0KIzEyIDB4MDAwMDU1YTFhNzczMGYwYiBpbiBzdWJxdWVyeV9wbGFubmVyIChnbG9i PWdsb2JAZW50cnk9MHg1NWExYThhZTIwYzAsCnBhcnNlPXBhcnNlQGVudHJ5PTB4NTVhMWE4YTlj OTI4LCANCiAgICBwYXJlbnRfcm9vdD1wYXJlbnRfcm9vdEBlbnRyeT0weDAsCmhhc1JlY3Vyc2lv bj1oYXNSZWN1cnNpb25AZW50cnk9ZmFsc2UsCnR1cGxlX2ZyYWN0aW9uPXR1cGxlX2ZyYWN0aW9u QGVudHJ5PTApDQogICAgYXQgcGxhbm5lci5jOjk2Ng0KIzEzIDB4MDAwMDU1YTFhNzczMjA0ZSBp biBzdGFuZGFyZF9wbGFubmVyIChwYXJzZT0weDU1YTFhOGE5YzkyOCwKY3Vyc29yT3B0aW9ucz0y NTYsIGJvdW5kUGFyYW1zPTxvcHRpbWl6ZWQgb3V0PikNCiAgICBhdCBwbGFubmVyLmM6NDA1DQoj MTQgMHgwMDAwNTVhMWE3N2VjMzBkIGluIHBnX3BsYW5fcXVlcnkKKHF1ZXJ5dHJlZT1xdWVyeXRy ZWVAZW50cnk9MHg1NWExYThhOWM5MjgsIGN1cnNvck9wdGlvbnM9MjU2LCANCiAgICBib3VuZFBh cmFtcz1ib3VuZFBhcmFtc0BlbnRyeT0weDApIGF0IHBvc3RncmVzLmM6ODMyDQojMTUgMHgwMDAw NTVhMWE3NjIxZWZlIGluIEV4cGxhaW5PbmVRdWVyeSAocXVlcnk9MHg1NWExYThhOWM5MjgsCmN1 cnNvck9wdGlvbnM9PG9wdGltaXplZCBvdXQ+LCBpbnRvPTB4MCwgDQogICAgZXM9MHg1NWExYThh MzA1NDgsIA0KICAgIHF1ZXJ5U3RyaW5nPTB4NTVhMWE4YTBkNjE4ICJFWFBMQUlOXG5TRUxFQ1Qg KiBGUk9NIHBydDFfbCB0MSBMRUZUIEpPSU4KTEFURVJBTFxuICAoU0VMRUNUIHQxLmEgYXMgdDFh LCBwcnQxX2wuYSBGUk9NIHBydDFfbCkgdDIgT04gdDEuYSA9IHQyLmE7IiwKcGFyYW1zPTB4MCwg cXVlcnlFbnY9MHgwKSBhdCBleHBsYWluLmM6MzY1DQojMTYgMHgwMDAwNTVhMWE3NjIyNGM4IGlu IEV4cGxhaW5RdWVyeSAocHN0YXRlPXBzdGF0ZUBlbnRyeT0weDU1YTFhOGEyZTFkOCwKc3RtdD1z dG10QGVudHJ5PTB4NTVhMWE4YTBlZTc4LCANCiAgICBxdWVyeVN0cmluZz1xdWVyeVN0cmluZ0Bl bnRyeT0weDU1YTFhOGEwZDYxOCAiRVhQTEFJTlxuU0VMRUNUICogRlJPTQpwcnQxX2wgdDEgTEVG VCBKT0lOIExBVEVSQUxcbiAgKFNFTEVDVCB0MS5hIGFzIHQxYSwgcHJ0MV9sLmEgRlJPTSBwcnQx X2wpIHQyCk9OIHQxLmEgPSB0Mi5hOyIsIHBhcmFtcz1wYXJhbXNAZW50cnk9MHgwLCBxdWVyeUVu dj1xdWVyeUVudkBlbnRyeT0weDAsIA0KICAgIGRlc3Q9ZGVzdEBlbnRyeT0weDU1YTFhOGEzMDRi MCkgYXQgZXhwbGFpbi5jOjI1NA0KIzE3IDB4MDAwMDU1YTFhNzdmMjYzZCBpbiBzdGFuZGFyZF9Q cm9jZXNzVXRpbGl0eSAocHN0bXQ9MHg1NWExYThhMGVmNDgsIA0KICAgIHF1ZXJ5U3RyaW5nPTB4 NTVhMWE4YTBkNjE4ICJFWFBMQUlOXG5TRUxFQ1QgKiBGUk9NIHBydDFfbCB0MSBMRUZUIEpPSU4K TEFURVJBTFxuICAoU0VMRUNUIHQxLmEgYXMgdDFhLCBwcnQxX2wuYSBGUk9NIHBydDFfbCkgdDIg T04gdDEuYSA9IHQyLmE7IiwKY29udGV4dD1QUk9DRVNTX1VUSUxJVFlfVE9QTEVWRUwsIHBhcmFt cz0weDAsIHF1ZXJ5RW52PTB4MCwKZGVzdD0weDU1YTFhOGEzMDRiMCwgDQogICAgY29tcGxldGlv blRhZz0weDdmZmVmODhjYjk5MCAiIikgYXQgdXRpbGl0eS5jOjY3NQ0KIzE4IDB4MDAwMDU1YTFh NzdlZjJmMiBpbiBQb3J0YWxSdW5VdGlsaXR5IChwb3J0YWw9MHg1NWExYThhNzQxNjgsCnBzdG10 PTB4NTVhMWE4YTBlZjQ4LCBpc1RvcExldmVsPTxvcHRpbWl6ZWQgb3V0PiwgDQogICAgc2V0SG9s ZFNuYXBzaG90PTxvcHRpbWl6ZWQgb3V0PiwgZGVzdD08b3B0aW1pemVkIG91dD4sCmNvbXBsZXRp b25UYWc9MHg3ZmZlZjg4Y2I5OTAgIiIpIGF0IHBxdWVyeS5jOjExNzgNCiMxOSAweDAwMDA1NWEx YTc3ZjAyMDcgaW4gRmlsbFBvcnRhbFN0b3JlCihwb3J0YWw9cG9ydGFsQGVudHJ5PTB4NTVhMWE4 YTc0MTY4LCBpc1RvcExldmVsPWlzVG9wTGV2ZWxAZW50cnk9dHJ1ZSkNCiAgICBhdCBwcXVlcnku YzoxMDM4DQojMjAgMHgwMDAwNTVhMWE3N2YwZTdkIGluIFBvcnRhbFJ1biAocG9ydGFsPXBvcnRh bEBlbnRyeT0weDU1YTFhOGE3NDE2OCwKY291bnQ9Y291bnRAZW50cnk9OTIyMzM3MjAzNjg1NDc3 NTgwNywgDQogICAgaXNUb3BMZXZlbD1pc1RvcExldmVsQGVudHJ5PXRydWUsIHJ1bl9vbmNlPXJ1 bl9vbmNlQGVudHJ5PXRydWUsCmRlc3Q9ZGVzdEBlbnRyeT0weDU1YTFhOGFjYWJjMCwgDQogICAg YWx0ZGVzdD1hbHRkZXN0QGVudHJ5PTB4NTVhMWE4YWNhYmMwLCBjb21wbGV0aW9uVGFnPTB4N2Zm ZWY4OGNiYmMwICIiKQphdCBwcXVlcnkuYzo3NjgNCiMyMSAweDAwMDA1NWExYTc3ZWM2MTIgaW4g ZXhlY19zaW1wbGVfcXVlcnkgKA0KICAgIHF1ZXJ5X3N0cmluZz0weDU1YTFhOGEwZDYxOCAiRVhQ TEFJTlxuU0VMRUNUICogRlJPTSBwcnQxX2wgdDEgTEVGVCBKT0lOCkxBVEVSQUxcbiAgKFNFTEVD VCB0MS5hIGFzIHQxYSwgcHJ0MV9sLmEgRlJPTSBwcnQxX2wpIHQyIE9OIHQxLmEgPSB0Mi5hOyIp CmF0IHBvc3RncmVzLmM6MTE0NQ0KIzIyIDB4MDAwMDU1YTFhNzdlZTU5ZCBpbiBQb3N0Z3Jlc01h aW4gKGFyZ2M9PG9wdGltaXplZCBvdXQ+LAphcmd2PWFyZ3ZAZW50cnk9MHg1NWExYThhMzg3NDgs IGRibmFtZT08b3B0aW1pemVkIG91dD4sIA0KICAgIHVzZXJuYW1lPTxvcHRpbWl6ZWQgb3V0Pikg YXQgcG9zdGdyZXMuYzo0MTgyDQojMjMgMHgwMDAwNTVhMWE3NGMzMjdkIGluIEJhY2tlbmRSdW4g KHBvcnQ9MHg1NWExYThhMzBlNDApIGF0CnBvc3RtYXN0ZXIuYzo0MzYxDQojMjQgQmFja2VuZFN0 YXJ0dXAgKHBvcnQ9MHg1NWExYThhMzBlNDApIGF0IHBvc3RtYXN0ZXIuYzo0MDMzDQojMjUgU2Vy dmVyTG9vcCAoKSBhdCBwb3N0bWFzdGVyLmM6MTcwNg0KIzI2IDB4MDAwMDU1YTFhNzc2YzM5OCBp biBQb3N0bWFzdGVyTWFpbiAoYXJnYz0zLCBhcmd2PTB4NTVhMWE4YTA3OWYwKSBhdApwb3N0bWFz dGVyLmM6MTM3OQ0KIzI3IDB4MDAwMDU1YTFhNzRjNGVhOSBpbiBtYWluIChhcmdjPTMsIGFyZ3Y9 MHg1NWExYThhMDc5ZjApIGF0IG1haW4uYzoyMjgNCihnZGIpIHENCg0KZ2l0IGJpc2VjdCBwb2lu dHMgdG8gOWQ2ZDJiMjEzNC4NClRoYW5rcyB0byBSb21hbiBaaGFya292IGZvciBkaXNjb3Zlcmlu ZyB0aGlzLgoK --===============1915499586846515927==--