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 1pT4jH-0001k4-CT for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Feb 2023 17:41:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pT4jG-0003aw-5b for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Feb 2023 17:41:02 +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 1pSxXH-0005Md-B4 for pgsql-bugs@lists.postgresql.org; Fri, 17 Feb 2023 10:00:11 +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 1pSxXE-0003zL-B6 for pgsql-bugs@lists.postgresql.org; Fri, 17 Feb 2023 10:00:10 +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=3B9z7KHVuHZJ28J2OWLvvCGJ//fM/ar3AVI7ogBEgmM=; b=5GTThGOrg6B2WfwuwYdP3UFjiU 8dLjIrbwH3pEWMTzYgqL7IoF+eaNNTlxINCEKvnQD4gAvEr304lw7UI/5QAD065j0Yz6+XyBy6MzY F5DCevyEIyrDLrBXRAwnwv+8r8mDQT9b00qiysuaNA4MtRZmA1SsiSgcPmv49jlrkUrlZWClrqo12 V5glZrIawGfWDEpDMyH7jeGCdr2xhqBffkN16OD8fNaAK0UGnHFpFR3HNDSLJbHxUpfbxbYQVLi3S zzT2Acx0IOtY/DR3/H0ktSO/d9uVPCsUnqz6l41MWxfr/9A6YZQw9FHBrI+ArBhPg6ixv0x3Y+v++ IpKQ5G1A==; 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 1pSxXC-000589-G1 for pgsql-bugs@lists.postgresql.org; Fri, 17 Feb 2023 10: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 1pSxX9-005Ydm-DU for pgsql-bugs@lists.postgresql.org; Fri, 17 Feb 2023 10:00:03 +0000 Content-Type: multipart/mixed; boundary="===============1488427799382432781==" MIME-Version: 1.0 Subject: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger 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: Fri, 17 Feb 2023 10:00:00 +0000 Message-ID: <17798-0907404928dcf0dd@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 --===============1488427799382432781== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzc5OApMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKV2hlbiBleGVjdXRpbmcgdGhlIGZvbGxvd2luZyBxdWVyaWVzIHVuZGVyIHZhbGdyaW5k Og0KY2F0IDw8ICJFT0YiIHwgcHNxbA0KQ1JFQVRFIFRBQkxFIGJydXR0ZXN0KGNudCBpbnQgREVG QVVMVCAwLCB0IHRleHQpOw0KQ1JFQVRFIEZVTkNUSU9OIG5vb3BfdGZ1bmMoKSBSRVRVUk5TIHRy aWdnZXIgTEFOR1VBR0UgcGxwZ3NxbCBBUyAkJCBCRUdJTgpSRVRVUk4gTkVXOyBFTkQkJDsNCkNS RUFURSBUUklHR0VSIGJydXBkYXRlX3RyaWdnZXIgQkVGT1JFIFVQREFURSBPTiBicnV0dGVzdCBG T1IgRUFDSCBST1cKRVhFQ1VURSBGVU5DVElPTiBub29wX3RmdW5jKCk7DQpJTlNFUlQgSU5UTyBi cnV0dGVzdCh0KSBWQUxVRVMgKHJlcGVhdCgneCcsIDEwMDApKTsNCkVPRg0KDQpmb3IgKChpPTE7 aTw9NDtpKyspKTsgZG8NCiAgZWNobyAiaXRlcmF0aW9uICRpIg0KICBwc3FsIC1jICJVUERBVEUg YnJ1dHRlc3QgU0VUIGNudCA9IGNudCArIDEiICYNCiAgcHNxbCAtYyAiVVBEQVRFIGJydXR0ZXN0 IFNFVCBjbnQgPSBjbnQgKyAxIiAmDQogIHdhaXQNCmRvbmUNCg0KSSBnZXQgYSBmYWlsdXJlOg0K Li4uDQppdGVyYXRpb24gNA0KVVBEQVRFIDENCnNlcnZlciBjbG9zZWQgdGhlIGNvbm5lY3Rpb24g dW5leHBlY3RlZGx5DQogICAgICAgIFRoaXMgcHJvYmFibHkgbWVhbnMgdGhlIHNlcnZlciB0ZXJt aW5hdGVkIGFibm9ybWFsbHkNCiAgICAgICAgYmVmb3JlIG9yIHdoaWxlIHByb2Nlc3NpbmcgdGhl IHJlcXVlc3QuDQpjb25uZWN0aW9uIHRvIHNlcnZlciB3YXMgbG9zdA0KDQpzZXJ2ZXIubG9nIGNv bnRhaW5zOg0KPT0wMDowMDowMDowOC44NzcgMzM4MTM0NT09IEludmFsaWQgcmVhZCBvZiBzaXpl IDENCj09MDA6MDA6MDA6MDguODc3IDMzODEzNDU9PSAgICBhdCAweDFFNDcyMTogaGVhcF9jb21w dXRlX2RhdGFfc2l6ZQooaGVhcHR1cGxlLmM6MTM4KQ0KPT0wMDowMDowMDowOC44NzcgMzM4MTM0 NT09ICAgIGJ5IDB4MUU1Njc0OiBoZWFwX2Zvcm1fdHVwbGUKKGhlYXB0dXBsZS5jOjEwNjEpDQo9 PTAwOjAwOjAwOjA4Ljg3NyAzMzgxMzQ1PT0gICAgYnkgMHg0MTNBRjY6IHR0c19idWZmZXJfaGVh cF9tYXRlcmlhbGl6ZQooZXhlY1R1cGxlcy5jOjc0OCkNCj09MDA6MDA6MDA6MDguODc3IDMzODEz NDU9PSAgICBieSAweDQxNENCOTogRXhlY0ZldGNoU2xvdEhlYXBUdXBsZQooZXhlY1R1cGxlcy5j OjE2NTQpDQo9PTAwOjAwOjAwOjA4Ljg3NyAzMzgxMzQ1PT0gICAgYnkgMHgzREYxMEI6IEV4ZWNC UlVwZGF0ZVRyaWdnZXJzCih0cmlnZ2VyLmM6MzA3NCkNCj09MDA6MDA6MDA6MDguODc3IDMzODEz NDU9PSAgICBieSAweDQzOEUyQzogRXhlY1VwZGF0ZVByb2xvZ3VlCihub2RlTW9kaWZ5VGFibGUu YzoxOTEyKQ0KPT0wMDowMDowMDowOC44NzcgMzM4MTM0NT09ICAgIGJ5IDB4NDNBNjIzOiBFeGVj VXBkYXRlCihub2RlTW9kaWZ5VGFibGUuYzoyMjY5KQ0KPT0wMDowMDowMDowOC44NzcgMzM4MTM0 NT09ICAgIGJ5IDB4NDNEOEJEOiBFeGVjTW9kaWZ5VGFibGUKKG5vZGVNb2RpZnlUYWJsZS5jOjM4 NTYpDQo9PTAwOjAwOjAwOjA4Ljg3NyAzMzgxMzQ1PT0gICAgYnkgMHg0MEU3RjE6IEV4ZWNQcm9j Tm9kZUZpcnN0CihleGVjUHJvY25vZGUuYzo0NjQpDQo9PTAwOjAwOjAwOjA4Ljg3NyAzMzgxMzQ1 PT0gICAgYnkgMHg0MDZFMTk6IEV4ZWNQcm9jTm9kZSAoZXhlY3V0b3IuaDoyNTkpDQo9PTAwOjAw OjAwOjA4Ljg3NyAzMzgxMzQ1PT0gICAgYnkgMHg0MDZFMTk6IEV4ZWN1dGVQbGFuIChleGVjTWFp bi5jOjE2MzYpDQo9PTAwOjAwOjAwOjA4Ljg3NyAzMzgxMzQ1PT0gICAgYnkgMHg0MDZGRjk6IHN0 YW5kYXJkX0V4ZWN1dG9yUnVuCihleGVjTWFpbi5jOjM2MykNCj09MDA6MDA6MDA6MDguODc3IDMz ODEzNDU9PSAgICBieSAweDQwNzBDNTogRXhlY3V0b3JSdW4gKGV4ZWNNYWluLmM6MzA3KQ0KPT0w MDowMDowMDowOC44NzcgMzM4MTM0NT09ICBBZGRyZXNzIDB4OTU3ZDExNCBpcyBpbiBhIHJ3LSBh bm9ueW1vdXMKc2VnbWVudA0KPT0wMDowMDowMDowOC44NzcgMzM4MTM0NT09DQp7DQogICA8aW5z ZXJ0X2Ffc3VwcHJlc3Npb25fbmFtZV9oZXJlPg0KLi4uDQo9PTAwOjAwOjAwOjA4Ljg3NyAzMzgx MzQ1PT0NCj09MDA6MDA6MDA6MDguODc3IDMzODEzNDU9PSBFeGl0IHByb2dyYW0gb24gZmlyc3Qg ZXJyb3IKKC0tZXhpdC1vbi1maXJzdC1lcnJvcj15ZXMpDQoyMDIzLTAyLTE3IDExOjI3OjE3LjY2 MyBNU0sgWzMzODEyNjhdIExPRzogIHNlcnZlciBwcm9jZXNzIChQSUQgMzM4MTM0NSkKZXhpdGVk IHdpdGggZXhpdCBjb2RlIDENCjIwMjMtMDItMTcgMTE6Mjc6MTcuNjYzIE1TSyBbMzM4MTI2OF0g REVUQUlMOiAgRmFpbGVkIHByb2Nlc3Mgd2FzIHJ1bm5pbmc6ClVQREFURSBicnV0dGVzdCBTRVQg Y250ID0gY250ICsgMQ0KDQpJJ3ZlIGFsc28gc2VlbiBhIHJlbGV2YW50IGZhaWx1cmUgZGV0ZWN0 ZWQgYnkgYXNhbiAob24gbWFzdGVyKToNCj09MTkxMjk2ND09RVJST1I6IEFkZHJlc3NTYW5pdGl6 ZXI6IGhlYXAtYnVmZmVyLW92ZXJmbG93IG9uIGFkZHJlc3MKMHg3ZjIyM2RkNTJjNzggYXQgcGMg MHg1NWM5ZTg0NjE0NmEgYnAgMHg3ZmZmMGM2M2U1NjAgc3AgMHg3ZmZmMGM2M2RkMzANCldSSVRF IG9mIHNpemUgNDIyMDUxMjIgYXQgMHg3ZjIyM2RkNTJjNzggdGhyZWFkIFQwDQouLi4NCiM4ICAw eDAwMDA1NWM5ZTg0Njk1M2YgaW4gX19hc2FuOjpSZXBvcnRHZW5lcmljRXJyb3IodW5zaWduZWQg bG9uZywgdW5zaWduZWQKbG9uZywgdW5zaWduZWQgbG9uZywgdW5zaWduZWQgbG9uZywgYm9vbCwg dW5zaWduZWQgbG9uZywgdW5zaWduZWQgaW50LCBib29sKQooKQ0KIzkgIDB4MDAwMDU1YzllODQ2 MTQ4YyBpbiBfX2FzYW5fbWVtY3B5ICgpDQojMTAgMHgwMDAwNTVjOWU4NGQwOWM1IGluIGZpbGxf dmFsIChhdHQ9PG9wdGltaXplZCBvdXQ+LCBiaXQ9PG9wdGltaXplZApvdXQ+LCBiaXRtYXNrPWJp dG1hc2tAZW50cnk9MHg3ZmZmMGM2M2U2MjAsIA0KICAgIGRhdGFQPWRhdGFQQGVudHJ5PTB4N2Zm ZjBjNjNlNWUwLAppbmZvbWFzaz1pbmZvbWFza0BlbnRyeT0weDdmMjIzZGQwOTg2NCwgZGF0dW09 PG9wdGltaXplZCBvdXQ+LCANCiAgICBpc251bGw9PG9wdGltaXplZCBvdXQ+KSBhdCBoZWFwdHVw bGUuYzoyNzANCiMxMSAweDAwMDA1NWM5ZTg0ZDAwODAgaW4gaGVhcF9maWxsX3R1cGxlICh0dXBs ZURlc2M9PG9wdGltaXplZCBvdXQ+LAp2YWx1ZXM9PG9wdGltaXplZCBvdXQ+LCBpc251bGw9PG9w dGltaXplZCBvdXQ+LCANCiAgICBkYXRhPTxvcHRpbWl6ZWQgb3V0PiwgZGF0YV9zaXplPTxvcHRp bWl6ZWQgb3V0PiwgaW5mb21hc2s9PG9wdGltaXplZApvdXQ+LCBiaXQ9PG9wdGltaXplZCBvdXQ+ KSBhdCBoZWFwdHVwbGUuYzozMzYNCiMxMiAweDAwMDA1NWM5ZTg0ZDUzMGUgaW4gaGVhcF9mb3Jt X3R1cGxlICh0dXBsZURlc2NyaXB0b3I9MHg3ZjIyODk4Zjc2ZTgsCnZhbHVlcz0weDFkMzA4NCwg aXNudWxsPTB4NjI1MDAwMGM4NWQ4KQ0KICAgIGF0IGhlYXB0dXBsZS5jOjEwOTANCiMxMyAweDAw MDA1NWM5ZThiYzhkMGUgaW4gdHRzX2J1ZmZlcl9oZWFwX21hdGVyaWFsaXplIChzbG90PTB4NjI1 MDAwMGM4NTQ4KQphdCBleGVjVHVwbGVzLmM6NzQ4DQojMTQgMHgwMDAwNTVjOWU4YmNkMDJhIGlu IEV4ZWNGZXRjaFNsb3RIZWFwVHVwbGUKKHNsb3Q9c2xvdEBlbnRyeT0weDYyNTAwMDBjODU0OCwg bWF0ZXJpYWxpemU9PG9wdGltaXplZCBvdXQ+LCANCiAgICBzaG91bGRGcmVlPXNob3VsZEZyZWVA ZW50cnk9MHg3ZmZmMGM2M2U4MTApIGF0IGV4ZWNUdXBsZXMuYzoxNjU0DQojMTUgMHgwMDAwNTVj OWU4YWZiZDlhIGluIEV4ZWNCUlVwZGF0ZVRyaWdnZXJzIChlc3RhdGU9PG9wdGltaXplZCBvdXQ+ LAplcHFzdGF0ZT08b3B0aW1pemVkIG91dD4sIA0KICAgIHJlbGluZm89MHg2MjUwMDAwYTJlODAs IHR1cGxlaWQ9PG9wdGltaXplZCBvdXQ+LApmZHdfdHJpZ3R1cGxlPTxvcHRpbWl6ZWQgb3V0Piwg bmV3c2xvdD08b3B0aW1pemVkIG91dD4sIA0KICAgIHRtZmQ9PG9wdGltaXplZCBvdXQ+KSBhdCB0 cmlnZ2VyLmM6MzAyMg0KLi4uDQoNCkFjY29yZGluZyB0byBnaXQgYmlzZWN0LCBmaXJzdCBiYWQg Y29tbWl0IGZvciB0aGlzIGFub21hbHkgaXMgODZkYzkwMDU2Lg0KDQpUaGF0IGNvbW1pdCBjaGFu Z2VkIGp1c3Qgb25lIHRoaW5nIGluIHRyaWdnZXIuYzoNCi0gICAgICAgICAgICAgICAgICAgICAg IGVwcXNsb3RfY2xlYW4gPQpFeGVjRmlsdGVySnVuayhyZWxpbmZvLT5yaV9qdW5rRmlsdGVyLCBl cHFzbG90X2NhbmRpZGF0ZSk7DQorICAgICAgICAgICAgICAgICAgICAgICBlcHFzbG90X2NsZWFu ID0gRXhlY0dldFVwZGF0ZU5ld1R1cGxlKHJlbGluZm8sCmVwcXNsb3RfY2FuZGlkYXRlLA0KKyAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICBvbGRzbG90KTsNCg0KSSd2ZSBm b3VuZCB0aGUgZm9sbG93aW5nIGV4cGxhbmF0aW9uIGZvciB0aGUgZmFpbHVyZToNCjEpIEFmdGVy IHRoZSBFeGVjR2V0VXBkYXRlTmV3VHVwbGUoKSBjYWxsIHRoZSBuZXdzbG90IGFuZCB0aGUgb2xk c2xvdCBhcmUNCiBsaW5rZWQgdG9nZXRoZXIgKHRoZWlyIHNsb3QtPnR0c192YWx1ZXNbMV0gaW4g dGhpcyBjYXNlIHBvaW50IHRvIHRoZSBzYW1lDQogbWVtb3J5IGFkZHJlc3MgKGluc2lkZSB0aGUg b2xkc2xvdCcgYnVmZmVyKSkuDQoyKSBQcmV2aW91c2x5LCBHZXRUdXBsZUZvclRyaWdnZXIoKSBj b3VsZCBnZXQgYSB0dXBsZSB3aXRoIGEgbmV3IGJ1ZmZlciwNCiBzbyB0aGUgb2xkc2xvdCB3b3Vs ZCBiZSB0aGUgb25seSB1c2VyIG9mIHRoZSBidWZmZXIgYXQgdGhhdCBtb21lbnQuDQogKFRoZSBu ZXdzbG90IGRvZXNuJ3QgYmVjb21lIGFuIG9mZmljaWFsIHVzZXIgb2YgdGhlIGJ1ZmZlci4pDQoz KSBUaGVuLCB0cmlndHVwbGUgPSBFeGVjRmV0Y2hTbG90SGVhcFR1cGxlKG9sZHNsb3QsIC4uLikg aW52b2tlcw0KIHR0c19idWZmZXJfaGVhcF9tYXRlcmlhbGl6ZSgpIHdoZXJlIHRoZSBvbGRzbG90 LT5idWZmZXIgaXMgcmVsZWFzZWQuDQo0KSBGaW5hbGx5LCBuZXd0dXBsZSA9IEV4ZWNGZXRjaFNs b3RIZWFwVHVwbGUobmV3c2xvdCwgLi4uKSBpbnZva2VzDQogdHRzX2J1ZmZlcl9oZWFwX21hdGVy aWFsaXplKCkgd2hlcmUgYW4gaW5jb3JyZWN0IGFjY2VzcyB0byBtZW1vcnkNCiB0aGF0IGJlY2Ft ZSBhbm9ueW1vdXMgb2NjdXJzLCBhbmQgdGhhdCBpcyBkZXRlY3RlZCBieSB2YWxncmluZC4NCiBJ ZiBub3QgZGV0ZWN0ZWQsIGRpZmZlcmVudCBjb25zZXF1ZW5jZXMgYXJlIHBvc3NpYmxlIChpbiB0 aGUgYXNhbiBjYXNlDQogaXQgd2FzIG1lbWNweSB3aXRoIGFuIGluY29ycmVjdGx5IHJlYWQgZXh0 cmEgbGFyZ2UgZGF0YV9sZW4pLgoK --===============1488427799382432781==--