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 1jOp2O-0000ws-J3 for pgsql-bugs@arkaria.postgresql.org; Wed, 15 Apr 2020 20:53:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jOp2N-0006Aj-D6 for pgsql-bugs@arkaria.postgresql.org; Wed, 15 Apr 2020 20:53:35 +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 1jOoWy-0002b4-1b for pgsql-bugs@lists.postgresql.org; Wed, 15 Apr 2020 20:21:08 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jOoWu-0005wa-HZ for pgsql-bugs@lists.postgresql.org; Wed, 15 Apr 2020 20:21:07 +0000 Content-Type: multipart/mixed; boundary="===============4847412724974962126==" MIME-Version: 1.0 Subject: BUG #16369: Segmentation Faults and Data Corruption with Generated Columns To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: cameron.ezell@clearcapital.com Reply-To: cameron.ezell@clearcapital.com, pgsql-bugs@lists.postgresql.org Date: Wed, 15 Apr 2020 20:20:35 +0000 Message-ID: <16369-5845a6f1bef59884@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============4847412724974962126== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjM2OQpMb2dnZWQgYnk6ICAgICAgICAgIENhbWVyb24gRXplbGwKRW1h aWwgYWRkcmVzczogICAgICBjYW1lcm9uLmV6ZWxsQGNsZWFyY2FwaXRhbC5jb20KUG9zdGdyZVNR TCB2ZXJzaW9uOiAxMi4yCk9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudE9TIDgsIFJlZCBIYXQgOCwg TWFjIE9TIFggMTAuMTQuNgpEZXNjcmlwdGlvbjogICAgICAgIAoKSXQgc2VlbXMgdGhhdCB0aGVy ZSBhcmUgYSBmZXcgYnVncyB0aGF0IGFyZSB0aHJvd2luZyBzZWdtZW50YXRpb24gZmF1bHRzIGFu ZApjYXVzaW5nIGRhdGEgY29ycnVwdGlvbi4gVGhlc2UgaXNzdWVzIGtlZXAgYXBwZWFyaW5nIGZv ciBvdXIgdGVhbSB3aGVuIHVzaW5nCnRhYmxlcyB0aGF0IGNvbnRhaW4gZ2VuZXJhdGVkIGNvbHVt bnMgaW50cm9kdWNlZCBpbiBQb3N0Z3JlU1FMIDEyLiBUaGlzIGhhcwpiZWVuIHRlc3RlZCBvbiAx Mi4yICYgMTIuMSBvbiBDZW50T1MgOCBhcyB3ZWxsIGFzIDEyLjEgb24gTWFjT1MgMTAuMTQuNjoN Cg0Kc2VsZWN0IHZlcnNpb24oKTsNCi0tIFBvc3RncmVTUUwgMTIuMiBvbiB4ODZfNjQtcGMtbGlu dXgtZ251LCBjb21waWxlZCBieSBnY2MgKEdDQykgNC44LjMKMjAxNDA5MTEgKFJlZCBIYXQgNC44 LjMtOSksIDY0LWJpdA0KDQpDUkVBVEUgU0NIRU1BIGlmIG5vdCBleGlzdHMgdGVzdDtjb21taXQ7 DQoNCkNSRUFURSBUQUJMRSBpZiBub3QgZXhpc3RzIHRlc3QuYnVnX3JlcG9ydA0KKA0KICAgIGlk IGJpZ2ludCBnZW5lcmF0ZWQgYnkgZGVmYXVsdCBhcyBpZGVudGl0eSwNCiAgICBob3N0bmFtZSB2 YXJjaGFyLA0KICAgIGhvc3RuYW1lX3Nob3J0IHZhcmNoYXIgR0VORVJBVEVEIEFMV0FZUyBBUyAo c3BsaXRfcGFydChob3N0bmFtZSwgJy4nLAoxKSkgU1RPUkVELA0KICAgIGRldmljZSB0ZXh0LA0K ICAgIG1vdW50IHRleHQsDQogICAgdXNlZF9zcGFjZV9ieXRlcyBiaWdpbnQsDQogICAgdXNlZF9z cGFjZV9nYiBudW1lcmljIEdFTkVSQVRFRCBBTFdBWVMgQVMgKFJPVU5EKHVzZWRfc3BhY2VfYnl0 ZXMgLwoxMDczNzQxODI0LjAsMikpIFNUT1JFRCwNCiAgICBhdmFpbF9zcGFjZV9ieXRlcyBiaWdp bnQsDQogICAgYXZhaWxfc3BhY2VfZ2IgbnVtZXJpYyBHRU5FUkFURUQgQUxXQVlTIEFTIChST1VO RChhdmFpbF9zcGFjZV9ieXRlcyAvCjEwNzM3NDE4MjQuMCwyKSkgU1RPUkVELA0KICAgIGluc2Vy dGVkX2R0cyB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUgTk9UIE5VTEwgREVGQVVMVApjbG9ja190 aW1lc3RhbXAoKSwNCiAgICBpbnNlcnRlZF9ieSB0ZXh0IE5PVCBOVUxMIERFRkFVTFQgc2Vzc2lv bl91c2VyDQopO2NvbW1pdDsNCg0KLS0gTm8gcHJvYmxlbXMgb24gdGhlIGZvbGxvd2luZyBpbnNl cnQNCklOU0VSVCBJTlRPIHRlc3QuYnVnX3JlcG9ydChob3N0bmFtZSwgZGV2aWNlLCBtb3VudCwg dXNlZF9zcGFjZV9ieXRlcywKYXZhaWxfc3BhY2VfYnl0ZXMpIFZBTFVFUyAoJzEyMzQ1Njc4OScs ICdkZXZ0bXBmcycsICcvZGV2JywgMCwKNjA0NzA3NjEzMTMxMyk7DQpzZWxlY3QgKiBmcm9tIHRl c3QuYnVnX3JlcG9ydDtjb21taXQ7DQoNCi0tIE9uIENlbnRPUyA4LCB0aGlzIGJ1ZyBpcyB0cmln Z2VyZWQgd2l0aCBhIGhvc3RuYW1lIHdpdGggMTArIGNoYXJhY3RlcnMuCk9uIE1hY09TIDEwLjE0 LjYsIDE5KyBjaGFyYWN0ZXJzLg0KSU5TRVJUIElOVE8gdGVzdC5idWdfcmVwb3J0KGhvc3RuYW1l LCBkZXZpY2UsIG1vdW50LCB1c2VkX3NwYWNlX2J5dGVzLAphdmFpbF9zcGFjZV9ieXRlcykgVkFM VUVTICgnMTIzNDU2Nzg5MDEyMzQ1Njc4OTAnLCAnZGV2dG1wZnMnLCAnL2RldicsIDAsCjYwNDcw NzYxMzEzMTMpO2NvbW1pdDsNCi0tIFRoaXMgc2hvdWxkIGltbWVkaWF0ZWx5IGNyYXNoIHRoZSBw b3N0Z3JlcyBzZXJ2aWNlDQoNCi0tIEluc2VydGluZyBzb21lIHN0cmluZ3MgYmVsb3cgdGhhdCBj aGFyYWN0ZXIgdGhyZXNob2xkIHdpbGwgaW5zZXJ0IGp1c3QKZmluZSwgYnV0IGEgc2VsZWN0IHN0 YXRlbWVudCBvbiB0aGUgdGFibGUgd2lsbCBub3cgdGhyb3cgYW4gZXJyb3INCklOU0VSVCBJTlRP IHRlc3QuYnVnX3JlcG9ydChob3N0bmFtZSwgZGV2aWNlLCBtb3VudCwgdXNlZF9zcGFjZV9ieXRl cywKYXZhaWxfc3BhY2VfYnl0ZXMpIFZBTFVFUyAoJ2FiYycsICdkZXZ0bXBmcycsICcvZGV2Jywg MCwKNjA0NzA3NjEzMTMxMyk7Y29tbWl0Ow0Kc2VsZWN0ICogZnJvbSB0ZXN0LmJ1Z19yZXBvcnQ7 Y29tbWl0Ow0KLS1FUlJPUjogIFhYMDAwOiBpbnZhbGlkIG1lbW9yeSBhbGxvYyByZXF1ZXN0IHNp emUgMTg0NDY3NDQwNzM3MDk1NTE2MTMNCi0tTE9DQVRJT046ICBwYWxsb2MsIG1jeHQuYzo5MzQN Cg0KDQotLSBPbmNlIHRoZSAiaG9zdG5hbWVfc2hvcnQiIGNvbHVtbiBubyBsb25nZXIgcmVmZXJl bmNlcyBhbnkgb3RoZXIgY29sdW1uLCBJCmFtIHVuYWJsZSB0byByZXByb2R1Y2UgdGhpcyBlcnJv cg0KQ1JFQVRFIFRBQkxFIGlmIG5vdCBleGlzdHMgdGVzdC5idWdfcmVwb3J0Mg0KKA0KICAgIGlk IGJpZ2ludCBnZW5lcmF0ZWQgYnkgZGVmYXVsdCBhcyBpZGVudGl0eSwNCiAgICBob3N0bmFtZSB2 YXJjaGFyLA0KICAgIGhvc3RuYW1lX3Nob3J0IHZhcmNoYXIgR0VORVJBVEVEIEFMV0FZUyBBUyAo J3N0YXRpY19zdHJpbmcnKSBTVE9SRUQsDQogICAgZGV2aWNlIHRleHQsDQogICAgbW91bnQgdGV4 dCwNCiAgICB1c2VkX3NwYWNlX2J5dGVzIGJpZ2ludCwNCiAgICB1c2VkX3NwYWNlX2diIG51bWVy aWMgR0VORVJBVEVEIEFMV0FZUyBBUyAoUk9VTkQodXNlZF9zcGFjZV9ieXRlcyAvCjEwNzM3NDE4 MjQuMCwyKSkgU1RPUkVELA0KICAgIGF2YWlsX3NwYWNlX2J5dGVzIGJpZ2ludCwNCiAgICBhdmFp bF9zcGFjZV9nYiBudW1lcmljIEdFTkVSQVRFRCBBTFdBWVMgQVMgKFJPVU5EKGF2YWlsX3NwYWNl X2J5dGVzIC8KMTA3Mzc0MTgyNC4wLDIpKSBTVE9SRUQsDQogICAgaW5zZXJ0ZWRfZHRzIHRpbWVz dGFtcCB3aXRoIHRpbWUgem9uZSBOT1QgTlVMTCBERUZBVUxUCmNsb2NrX3RpbWVzdGFtcCgpLA0K ICAgIGluc2VydGVkX2J5IHRleHQgTk9UIE5VTEwgREVGQVVMVCBzZXNzaW9uX3VzZXINCik7Y29t bWl0Ow0KDQpJTlNFUlQgSU5UTyB0ZXN0LmJ1Z19yZXBvcnQyKGhvc3RuYW1lLCBkZXZpY2UsIG1v dW50LCB1c2VkX3NwYWNlX2J5dGVzLAphdmFpbF9zcGFjZV9ieXRlcykgVkFMVUVTICgnMTIzNDU2 Nzg5MDEyMzQ1Njc4OTAnLCAnZGV2dG1wZnMnLCAnL2RldicsIDAsCjYwNDcwNzYxMzEzMTMpO2Nv bW1pdDsNCnNlbGVjdCAqIGZyb20gdGVzdC5idWdfcmVwb3J0Mjtjb21taXQ7DQoNCklOU0VSVCBJ TlRPIHRlc3QuYnVnX3JlcG9ydDIoaG9zdG5hbWUsIGRldmljZSwgbW91bnQsIHVzZWRfc3BhY2Vf Ynl0ZXMsCmF2YWlsX3NwYWNlX2J5dGVzKSBWQUxVRVMgKCdhYmMnLCAnZGV2dG1wZnMnLCAnL2Rl dicsIDAsCjYwNDcwNzYxMzEzMTMpO2NvbW1pdDsNCnNlbGVjdCAqIGZyb20gdGVzdC5idWdfcmVw b3J0Mjtjb21taXQ7DQoNCi0tIHNpbXBseSByZWZlcmVuY2luZyBhbm90aGVyIGNvbHVtbiBpbiB0 aGUgZ2VuZXJhdGVkIGNvbHVtbiB3aWxsIGNhdXNlIGEKY3Jhc2gNCkNSRUFURSBUQUJMRSBpZiBu b3QgZXhpc3RzIHRlc3QuYnVnX3JlcG9ydDMNCigNCiAgICBpZCBiaWdpbnQgZ2VuZXJhdGVkIGJ5 IGRlZmF1bHQgYXMgaWRlbnRpdHksDQogICAgaG9zdG5hbWUgdmFyY2hhciwNCiAgICBob3N0bmFt ZV9zaG9ydCB2YXJjaGFyIEdFTkVSQVRFRCBBTFdBWVMgQVMgKGhvc3RuYW1lKSBTVE9SRUQsDQog ICAgZGV2aWNlIHRleHQsDQogICAgbW91bnQgdGV4dCwNCiAgICB1c2VkX3NwYWNlX2J5dGVzIGJp Z2ludCwNCiAgICB1c2VkX3NwYWNlX2diIG51bWVyaWMgR0VORVJBVEVEIEFMV0FZUyBBUyAoUk9V TkQodXNlZF9zcGFjZV9ieXRlcyAvCjEwNzM3NDE4MjQuMCwyKSkgU1RPUkVELA0KICAgIGF2YWls X3NwYWNlX2J5dGVzIGJpZ2ludCwNCiAgICBhdmFpbF9zcGFjZV9nYiBudW1lcmljIEdFTkVSQVRF RCBBTFdBWVMgQVMgKFJPVU5EKGF2YWlsX3NwYWNlX2J5dGVzIC8KMTA3Mzc0MTgyNC4wLDIpKSBT VE9SRUQsDQogICAgaW5zZXJ0ZWRfZHRzIHRpbWVzdGFtcCB3aXRoIHRpbWUgem9uZSBOT1QgTlVM TCBERUZBVUxUCmNsb2NrX3RpbWVzdGFtcCgpLA0KICAgIGluc2VydGVkX2J5IHRleHQgTk9UIE5V TEwgREVGQVVMVCBzZXNzaW9uX3VzZXINCik7Y29tbWl0Ow0KDQotLSBpbW1lZGlhdGUgY3Jhc2gN CklOU0VSVCBJTlRPIHRlc3QuYnVnX3JlcG9ydDMoaG9zdG5hbWUsIGRldmljZSwgbW91bnQsIHVz ZWRfc3BhY2VfYnl0ZXMsCmF2YWlsX3NwYWNlX2J5dGVzKSBWQUxVRVMgKCcxMjM0NTY3ODkwMTIz NDU2Nzg5MCcsICdkZXZ0bXBmcycsICcvZGV2JywgMCwKNjA0NzA3NjEzMTMxMyk7Y29tbWl0Ow0K DQotLSBubyBjcmFzaCBvbiBpbnNlcnQNCklOU0VSVCBJTlRPIHRlc3QuYnVnX3JlcG9ydDMoaG9z dG5hbWUsIGRldmljZSwgbW91bnQsIHVzZWRfc3BhY2VfYnl0ZXMsCmF2YWlsX3NwYWNlX2J5dGVz KSBWQUxVRVMgKCdhYmMnLCAnZGV2dG1wZnMnLCAnL2RldicsIDAsCjYwNDcwNzYxMzEzMTMpO2Nv bW1pdDsNCi0tIGVycm9yIHRocm93biBvbiBzZWxlY3QNCnNlbGVjdCAqIGZyb20gdGVzdC5idWdf cmVwb3J0Mztjb21taXQ7DQotLUVSUk9SOiAgWFgwMDA6IGludmFsaWQgbWVtb3J5IGFsbG9jIHJl cXVlc3Qgc2l6ZSAxODQ0Njc0NDA3MzcwOTU1MTYxMw0KLS1MT0NBVElPTjogIHBhbGxvYywgbWN4 dC5jOjkzNAoK --===============4847412724974962126==--