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 1pTTBA-0003Mf-5u for pgsql-bugs@arkaria.postgresql.org; Sat, 18 Feb 2023 19:47:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pTTB8-0000Dq-NZ for pgsql-bugs@arkaria.postgresql.org; Sat, 18 Feb 2023 19:47:26 +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 1pTI8i-0002YM-74 for pgsql-bugs@lists.postgresql.org; Sat, 18 Feb 2023 08:00:12 +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 1pTI8e-0000D0-Ig for pgsql-bugs@lists.postgresql.org; Sat, 18 Feb 2023 08:00:11 +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=86IGEGsgoH/QXc/vfxl6oBLxqDfaH8Vj+v4iyE4442A=; b=rFVP3W5oAv2fhMIIONXhwU+4TF INi1EpFIOYhuGQeErj+z8Spemmu7Vox8tdUC6pdTP1wcvDuTXJZ5Q9h/lpnt8FygsaoPnPkK+Ae6f eh0SxoslIFYNvZ/CRIgZpKQwPQ0dnNN/NgUltKe3Uv1LXcNhBi/IMIJYHG3s9H7qeyb1x6Akp+z34 pZC8RlJ39CymM/n5HY3s8SaUJLAaJUrH+dLLVPtJQSxU71Ok1rAggKkErYSmw7gbHyaM7csleThp6 ByMB5vP0pRuiLkuXuLVvANgURqTTpSLLJ6R/MW49kCx/+Yd/cFhZaMtPEPRn4C+soMpVkymY2c2KK xB3uk6hw==; 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 1pTI8c-0003Wf-BM for pgsql-bugs@lists.postgresql.org; Sat, 18 Feb 2023 08:00: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 1pTI8a-0065Z3-1d for pgsql-bugs@lists.postgresql.org; Sat, 18 Feb 2023 08:00:03 +0000 Content-Type: multipart/mixed; boundary="===============1383554475458181442==" MIME-Version: 1.0 Subject: BUG #17800: ON CONFLICT DO UPDATE fails to detect incompatible fields that leads to a server crash 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, 18 Feb 2023 08:00:00 +0000 Message-ID: <17800-ff90866b3906c964@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 --===============1383554475458181442== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzgwMApMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKV2hlbiBleGVjdXRpbmcgdGhlIGZvbGxvd2luZyBxdWVyaWVzOg0KQ1JFQVRFIFRBQkxF IHQgKGEgSU5UIFBSSU1BUlkgS0VZLCBiIFRFWFQpIFBBUlRJVElPTiBCWSBMSVNUIChhKTsNCg0K Q1JFQVRFIFRBQkxFIHRwMSAoYiBURVhULCBhIElOVCBQUklNQVJZIEtFWSk7DQpBTFRFUiBUQUJM RSB0IEFUVEFDSCBQQVJUSVRJT04gdHAxIEZPUiBWQUxVRVMgSU4gKDEpOw0KDQpDUkVBVEUgVEFC TEUgdHAyIChhIElOVCBQUklNQVJZIEtFWSwgYiBURVhUKTsNCkFMVEVSIFRBQkxFIHQgQVRUQUNI IFBBUlRJVElPTiB0cDIgRk9SIFZBTFVFUyBJTiAoMik7DQoNCklOU0VSVCBJTlRPIHQgVkFMVUVT ICgxKSwgKDIpOw0KDQpJTlNFUlQgSU5UTyB0IFZBTFVFUyAoMSksICgyKSBPTiBDT05GTElDVChh KQ0KICBETyBVUERBVEUgU0VUIChhLCBiKSA9IChTRUxFQ1QgdC5hLCB0LmIgfHwgJysnKTsNCg0K SSBnZXQgdGhlIHNlcnZlciBjcmFzaGVkIHdpdGggdGhlIGNvcmVkdW1wOg0KQ29yZSB3YXMgZ2Vu ZXJhdGVkIGJ5IGBwb3N0Z3JlczogbGF3IHJlZ3Jlc3Npb24gW2xvY2FsXSBJTlNFUlQgICAgICAg ICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAnLg0KUHJvZ3JhbSB0ZXJtaW5hdGVkIHdp dGggc2lnbmFsIFNJR1NFR1YsIFNlZ21lbnRhdGlvbiBmYXVsdC4NCg0Kd2FybmluZzogU2VjdGlv biBgLnJlZy14c3RhdGUvMTEyMTI0MicgaW4gY29yZSBmaWxlIHRvbyBzbWFsbC4NCiMwICAweDAw MDA1NjE3M2Y0OWQ5MWQgaW4gcGdfZGV0b2FzdF9kYXR1bV9wYWNrZWQgKGRhdHVtPTB4MikgYXQK Zm1nci5jOjE4NTMNCjE4NTMgICAgICAgICAgICBpZiAoVkFSQVRUX0lTX0NPTVBSRVNTRUQoZGF0 dW0pIHx8ClZBUkFUVF9JU19FWFRFUk5BTChkYXR1bSkpDQooZ2RiKSBidA0KIzAgIDB4MDAwMDU2 MTczZjQ5ZDkxZCBpbiBwZ19kZXRvYXN0X2RhdHVtX3BhY2tlZCAoZGF0dW09MHgyKSBhdApmbWdy LmM6MTg1Mw0KIzEgIDB4MDAwMDU2MTczZjQ0YmIzYyBpbiB0ZXh0Y2F0IChmY2luZm89MHg1NjE3 NDBjMGE0ZDgpIGF0IHZhcmxlbmEuYzo3NTANCiMyICAweDAwMDA1NjE3M2VmZWJkNmUgaW4gRXhl Y0ludGVycEV4cHIgKHN0YXRlPTB4NTYxNzQwYzA5ZmYwLAplY29udGV4dD0weDU2MTc0MGMwOWQx OCwgDQogICAgaXNudWxsPTB4N2ZmYzVmNTk1ZDJmKSBhdCBleGVjRXhwckludGVycC5jOjc1Mg0K IzMgIDB4MDAwMDU2MTczZjA0YTg2YSBpbiBFeGVjRXZhbEV4cHJTd2l0Y2hDb250ZXh0IChzdGF0 ZT0weDU2MTc0MGMwOWZmMCwKZWNvbnRleHQ9MHg1NjE3NDBjMDlkMTgsIA0KICAgIGlzTnVsbD0w eDdmZmM1ZjU5NWQyZikgYXQgLi4vLi4vLi4vc3JjL2luY2x1ZGUvZXhlY3V0b3IvZXhlY3V0b3Iu aDozNDQNCiM0ICAweDAwMDA1NjE3M2YwNGE4ZTIgaW4gRXhlY1Byb2plY3QgKHByb2pJbmZvPTB4 NTYxNzQwYzA5ZmU4KQ0KICAgIGF0IC4uLy4uLy4uL3NyYy9pbmNsdWRlL2V4ZWN1dG9yL2V4ZWN1 dG9yLmg6Mzc4DQojNSAgMHgwMDAwNTYxNzNmMDRhYjE5IGluIEV4ZWNSZXN1bHQgKHBzdGF0ZT0w eDU2MTc0MGMwOWMwOCkgYXQKbm9kZVJlc3VsdC5jOjEzNg0KIzYgIDB4MDAwMDU2MTczZjA0ZTQw ZCBpbiBFeGVjUHJvY05vZGUgKG5vZGU9MHg1NjE3NDBjMDljMDgpIGF0Ci4uLy4uLy4uL3NyYy9p bmNsdWRlL2V4ZWN1dG9yL2V4ZWN1dG9yLmg6MjYyDQojNyAgMHgwMDAwNTYxNzNmMDUwOGZlIGlu IEV4ZWNTZXRQYXJhbVBsYW4gKG5vZGU9MHg1NjE3NDBjMTEyYzAsCmVjb250ZXh0PTB4NTYxNzQw YzBmOGM4KQ0KICAgIGF0IG5vZGVTdWJwbGFuLmM6MTEzMw0KIzggIDB4MDAwMDU2MTczZWZlZjIy NSBpbiBFeGVjRXZhbFBhcmFtRXhlYyAoc3RhdGU9MHg1NjE3NDBjMGZhODAsCm9wPTB4NTYxNzQw YzBmYjQ4LCBlY29udGV4dD0weDU2MTc0MGMwZjhjOCkNCiAgICBhdCBleGVjRXhwckludGVycC5j OjI0MjgNCiM5ICAweDAwMDA1NjE3M2VmZWM1ZTggaW4gRXhlY0ludGVycEV4cHIgKHN0YXRlPTB4 NTYxNzQwYzBmYTgwLAplY29udGV4dD0weDU2MTc0MGMwZjhjOCwgDQogICAgaXNudWxsPTB4N2Zm YzVmNTk2MWNmKSBhdCBleGVjRXhwckludGVycC5jOjEwNjUNCiMxMCAweDAwMDA1NjE3M2VmZWUx NzkgaW4gRXhlY0ludGVycEV4cHJTdGlsbFZhbGlkIChzdGF0ZT0weDU2MTc0MGMwZmE4MCwKZWNv bnRleHQ9MHg1NjE3NDBjMGY4YzgsIA0KICAgIGlzTnVsbD0weDdmZmM1ZjU5NjFjZikgYXQgZXhl Y0V4cHJJbnRlcnAuYzoxODM4DQojMTEgMHgwMDAwNTYxNzNmMDQwYjRhIGluIEV4ZWNFdmFsRXhw clN3aXRjaENvbnRleHQgKHN0YXRlPTB4NTYxNzQwYzBmYTgwLAplY29udGV4dD0weDU2MTc0MGMw ZjhjOCwgDQogICAgaXNOdWxsPTB4N2ZmYzVmNTk2MWNmKSBhdCAuLi8uLi8uLi9zcmMvaW5jbHVk ZS9leGVjdXRvci9leGVjdXRvci5oOjM0NA0KIzEyIDB4MDAwMDU2MTczZjA0MGJjMiBpbiBFeGVj UHJvamVjdCAocHJvakluZm89MHg1NjE3NDBjMGZhNzgpDQogICAgYXQgLi4vLi4vLi4vc3JjL2lu Y2x1ZGUvZXhlY3V0b3IvZXhlY3V0b3IuaDozNzgNCiMxMyAweDAwMDA1NjE3M2YwNDRkZWYgaW4g RXhlY09uQ29uZmxpY3RVcGRhdGUgKGNvbnRleHQ9MHg3ZmZjNWY1OTY0MjAsCnJlc3VsdFJlbElu Zm89MHg1NjE3NDBjMmM0MTgsIA0KICAgIGNvbmZsaWN0VGlkPTB4N2ZmYzVmNTk2MmUyLCBleGNs dWRlZFNsb3Q9MHg1NjE3NDBjMGIxMzgsIGNhblNldFRhZz10cnVlLApyZXR1cm5pbmc9MHg3ZmZj NWY1OTYyZTgpDQogICAgYXQgbm9kZU1vZGlmeVRhYmxlLmM6MjY1OQ0KIzE0IDB4MDAwMDU2MTcz ZjA0MjZkOCBpbiBFeGVjSW5zZXJ0IChjb250ZXh0PTB4N2ZmYzVmNTk2NDIwLApyZXN1bHRSZWxJ bmZvPTB4NTYxNzQwYzJjNDE4LCANCiAgICBzbG90PTB4NTYxNzQwYzBiMTM4LCBjYW5TZXRUYWc9 dHJ1ZSwgaW5zZXJ0ZWRfdHVwbGU9MHgwLAppbnNlcnRfZGVzdHJlbD0weDApIGF0IG5vZGVNb2Rp ZnlUYWJsZS5jOjEwNTkNCiMxNSAweDAwMDA1NjE3M2YwNDZkYzYgaW4gRXhlY01vZGlmeVRhYmxl IChwc3RhdGU9MHg1NjE3NDBjMGE1NzgpIGF0Cm5vZGVNb2RpZnlUYWJsZS5jOjM4MTANCiMxNiAw eDAwMDA1NjE3M2YwMDRkZDMgaW4gRXhlY1Byb2NOb2RlRmlyc3QgKG5vZGU9MHg1NjE3NDBjMGE1 NzgpIGF0CmV4ZWNQcm9jbm9kZS5jOjQ2NA0KIzE3IDB4MDAwMDU2MTczZWZmN2ZmNiBpbiBFeGVj UHJvY05vZGUgKG5vZGU9MHg1NjE3NDBjMGE1NzgpIGF0Ci4uLy4uLy4uL3NyYy9pbmNsdWRlL2V4 ZWN1dG9yL2V4ZWN1dG9yLmg6MjYyDQojMTggMHgwMDAwNTYxNzNlZmZhZTJiIGluIEV4ZWN1dGVQ bGFuIChlc3RhdGU9MHg1NjE3NDBjMDk5MzgsCnBsYW5zdGF0ZT0weDU2MTc0MGMwYTU3OCwgDQog ICAgdXNlX3BhcmFsbGVsX21vZGU9ZmFsc2UsIG9wZXJhdGlvbj1DTURfSU5TRVJULCBzZW5kVHVw bGVzPWZhbHNlLApudW1iZXJUdXBsZXM9MCwgDQogICAgZGlyZWN0aW9uPUZvcndhcmRTY2FuRGly ZWN0aW9uLCBkZXN0PTB4NTYxNzQwYzBmMzEwLCBleGVjdXRlX29uY2U9dHJ1ZSkKYXQgZXhlY01h aW4uYzoxNjMzDQojMTkgMHgwMDAwNTYxNzNlZmY4NmRlIGluIHN0YW5kYXJkX0V4ZWN1dG9yUnVu IChxdWVyeURlc2M9MHg1NjE3NDBjMTJjNzgsCmRpcmVjdGlvbj1Gb3J3YXJkU2NhbkRpcmVjdGlv biwgDQogICAgY291bnQ9MCwgZXhlY3V0ZV9vbmNlPXRydWUpIGF0IGV4ZWNNYWluLmM6MzY0DQoj MjAgMHgwMDAwNTYxNzNlZmY4NGU3IGluIEV4ZWN1dG9yUnVuIChxdWVyeURlc2M9MHg1NjE3NDBj MTJjNzgsCmRpcmVjdGlvbj1Gb3J3YXJkU2NhbkRpcmVjdGlvbiwgY291bnQ9MCwgDQogICAgZXhl Y3V0ZV9vbmNlPXRydWUpIGF0IGV4ZWNNYWluLmM6MzA4DQojMjEgMHgwMDAwNTYxNzNmMmFhOTQ4 IGluIFByb2Nlc3NRdWVyeSAocGxhbj0weDU2MTc0MGMyMDE1OCwgDQogICAgc291cmNlVGV4dD0w eDU2MTc0MGIxYTE3OCAiSU5TRVJUIElOVE8gdCBWQUxVRVMgKDEpLCAoMikgT04KQ09ORkxJQ1Qo YSlcbiAgRE8gVVBEQVRFIFNFVCAoYSwgYikgPSAoU0VMRUNUIHQuYSwgdC5iIHx8ICcrJyk7IiwK cGFyYW1zPTB4MCwgcXVlcnlFbnY9MHgwLCBkZXN0PTB4NTYxNzQwYzBmMzEwLCBxYz0weDdmZmM1 ZjU5Njg4MCkgYXQKcHF1ZXJ5LmM6MTYwDQojMjIgMHgwMDAwNTYxNzNmMmFjNGVjIGluIFBvcnRh bFJ1bk11bHRpIChwb3J0YWw9MHg1NjE3NDBiOTI2YzgsCmlzVG9wTGV2ZWw9dHJ1ZSwgc2V0SG9s ZFNuYXBzaG90PWZhbHNlLCANCiAgICBkZXN0PTB4NTYxNzQwYzBmMzEwLCBhbHRkZXN0PTB4NTYx NzQwYzBmMzEwLCBxYz0weDdmZmM1ZjU5Njg4MCkgYXQKcHF1ZXJ5LmM6MTI3Nw0KIzIzIDB4MDAw MDU2MTczZjJhYjllMCBpbiBQb3J0YWxSdW4gKHBvcnRhbD0weDU2MTc0MGI5MjZjOCwKY291bnQ9 OTIyMzM3MjAzNjg1NDc3NTgwNywgaXNUb3BMZXZlbD10cnVlLCANCiAgICBydW5fb25jZT10cnVl LCBkZXN0PTB4NTYxNzQwYzBmMzEwLCBhbHRkZXN0PTB4NTYxNzQwYzBmMzEwLApxYz0weDdmZmM1 ZjU5Njg4MCkgYXQgcHF1ZXJ5LmM6NzkxDQojMjQgMHgwMDAwNTYxNzNmMmE0NzQzIGluIGV4ZWNf c2ltcGxlX3F1ZXJ5ICgNCiAgICBxdWVyeV9zdHJpbmc9MHg1NjE3NDBiMWExNzggIklOU0VSVCBJ TlRPIHQgVkFMVUVTICgxKSwgKDIpIE9OCkNPTkZMSUNUKGEpXG4gIERPIFVQREFURSBTRVQgKGEs IGIpID0gKFNFTEVDVCB0LmEsIHQuYiB8fCAnKycpOyIpIGF0CnBvc3RncmVzLmM6MTIzNw0KIzI1 IDB4MDAwMDU2MTczZjJhOTc1NCBpbiBQb3N0Z3Jlc01haW4gKGRibmFtZT0weDU2MTc0MGI1MjU3 OCAicmVncmVzc2lvbiIsCnVzZXJuYW1lPTB4NTYxNzQwYjE3NzA4ICJsYXciKQ0KICAgIGF0IHBv c3RncmVzLmM6NDU2NQ0KIzI2IDB4MDAwMDU2MTczZjFjZDRiYiBpbiBCYWNrZW5kUnVuIChwb3J0 PTB4NTYxNzQwYjQyYjEwKSBhdApwb3N0bWFzdGVyLmM6NDQ2MQ0KIzI3IDB4MDAwMDU2MTczZjFj Y2Q0NyBpbiBCYWNrZW5kU3RhcnR1cCAocG9ydD0weDU2MTc0MGI0MmIxMCkgYXQKcG9zdG1hc3Rl ci5jOjQxODkNCiMyOCAweDAwMDA1NjE3M2YxYzkwOGMgaW4gU2VydmVyTG9vcCAoKSBhdCBwb3N0 bWFzdGVyLmM6MTc3OQ0KIzI5IDB4MDAwMDU2MTczZjFjODkzNiBpbiBQb3N0bWFzdGVyTWFpbiAo YXJnYz0zLCBhcmd2PTB4NTYxNzQwYjE1NjQwKSBhdApwb3N0bWFzdGVyLmM6MTQ2Mw0KIzMwIDB4 MDAwMDU2MTczZjA4MmNmYSBpbiBtYWluIChhcmdjPTMsIGFyZ3Y9MHg1NjE3NDBiMTU2NDApIGF0 IG1haW4uYzoyMDANCg0KQnV0IHdoZW4gZXhlY3V0aW5nOg0KVVBEQVRFIHQgU0VUIChhLCBiKSA9 IChTRUxFQ1QgdC5hLCB0LmIgfHwgJysnKTsNCkkgZ2V0Og0KRVJST1I6ICBhdHRyaWJ1dGUgMSBv ZiB0eXBlIHRwMSBoYXMgd3JvbmcgdHlwZQ0KREVUQUlMOiAgVGFibGUgaGFzIHR5cGUgdGV4dCwg YnV0IHF1ZXJ5IGV4cGVjdHMgaW50ZWdlci4NCg0KQnkgY29tcGFyaW5nIHR3byBjYWxsc3RhY2tz IEkgY2FuIHNlZSB0aGF0IGluIHRoZSBzZWNvbmQgY2FzZQ0KRXhlY0ludGVycEV4cHJTdGlsbFZh bGlkKCkgaXMgZXhlY3V0ZWQgYWZ0ZXIgdGhlIGxhdGVzdApFeGVjRXZhbEV4cHJTd2l0Y2hDb250 ZXh0KCkuDQpUaGUgRXhlY0ludGVycEV4cHJTdGlsbFZhbGlkKCkgZnVuY3Rpb24gY29udGFpbnM6 DQogICAgICAgIC8qIHNraXAgdGhlIGNoZWNrIGR1cmluZyBmdXJ0aGVyIGV4ZWN1dGlvbnMgKi8N CiAgICAgICAgc3RhdGUtPmV2YWxmdW5jID0gKEV4cHJTdGF0ZUV2YWxGdW5jKSBzdGF0ZS0+ZXZh bGZ1bmNfcHJpdmF0ZTsNCg0KSWYganVzdCBjYWxsIGV2YWxmdW5jX3ByaXZhdGUoKSBoZXJlLCB0 aGUgZmlyc3QgY2FzZSBlbmRzIHdpdGggdGhlIGVycm9yIGFzCmV4cGVjdGVkLg0KDQpPYnNlcnZl ZCBvbiBSRUxfMTFfU1RBQkxFLi5tYXN0ZXIuCgo= --===============1383554475458181442==--