Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnGVZ-00AM8n-4A for pgsql-bugs@arkaria.postgresql.org; Mon, 02 Oct 2023 10:50:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qnGUY-00Ajxj-6n for pgsql-bugs@arkaria.postgresql.org; Mon, 02 Oct 2023 10:49:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnDsV-00HS4c-Tr for pgsql-bugs@lists.postgresql.org; Mon, 02 Oct 2023 08:02:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnDsS-007kKy-Qg for pgsql-bugs@lists.postgresql.org; Mon, 02 Oct 2023 08:02:06 +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=BJqvuP4lG7JNhxz6Tqftl80+Q1JGnrxAnTGOJveCdys=; b=EZC9qEkCIs/uffzuP+A4a9hSDy uY/HJxqgKdXCJe8wvBXvAr618/TkTyujcB4TJaPq8z/adv0N3vCTWc8ELpNtN0iGk8ly1vXPsm50U NSZhITNBUzsjKw7EB6zoBsFvaWK8IhXrykHOXfw4Cy2ssKfc7A/c17zrdVrpZd0sX8jGwz/DdMIle YZF32Z55UL+myA6dMHVEVeCx69eI7xQCQW08j5QdJMIMRZdbJPtuwgAZGHhdt1B5eLGzSVbUbLByP 54/D3h6uFMbsTy6ARihjY5VdPkX82t/qSPJ9fjZpP41v1GROpxMiBQsLA4/mh8CWQtWn1ANgQqP7t zhXeg5aQ==; 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 1qnDsS-0000eC-DL for pgsql-bugs@lists.postgresql.org; Mon, 02 Oct 2023 08:02:04 +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 1qnDsQ-008KYU-TW for pgsql-bugs@lists.postgresql.org; Mon, 02 Oct 2023 08:02:02 +0000 Content-Type: multipart/mixed; boundary="===============2335089788040646666==" MIME-Version: 1.0 Subject: BUG #18142: strange behaviour of "UPDATE" with id_encode() To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: info@dataselfservice.com Reply-To: info@dataselfservice.com, pgsql-bugs@lists.postgresql.org Date: Mon, 02 Oct 2023 08:01:30 +0000 Message-ID: <18142-b2cd722a4a74a712@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 --===============2335089788040646666== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE0MgpMb2dnZWQgYnk6ICAgICAgICAgIERhdGFTZWxmU2VydmljZSBT cmwKRW1haWwgYWRkcmVzczogICAgICBpbmZvQGRhdGFzZWxmc2VydmljZS5jb20KUG9zdGdyZVNR TCB2ZXJzaW9uOiAxNS40Ck9wZXJhdGluZyBzeXN0ZW06ICAgZG9ja2VyCkRlc2NyaXB0aW9uOiAg ICAgICAgCgpIaSwNCg0KSW4gc2hvcnQ6IHdoeSBpcyBgVVBEQVRFLi4uaWRfZW5jb2RlKClgIG1p c3NiZWhhdmluZyBhbmQgYmVoYXZpbmcKZGlmZmVyZW50bHkgaW4gY2FzZSBhIHNpbmdsZSBgU0VU YCBvciBtdWx0aXBsZSBgU0VUYCBvbiB0aGUgc2FtZSBsaW5lIGFyZQpkb25lPw0KDQpEZXRhaWxz DQoNCkknbSBydW5uaW5nIGEga3ViZXJuZXRlcyBpbnN0YW5jZSBvZiAgYDE1LjQtYWxwaW5lMy4x OGAsIHdpdGggbW9kaWZpZWQgaW1hZ2UKYElNR19QT1NUR1JFU19UQUdgIGFkZGVkIHdpdGggYHBn X2hhc2hpZHNgIHZpYSBmb2xsb3dpbmcgYERvY2tlcmZpbGVgOg0KYGBgDQpGUk9NIHBvc3RncmVz OjE1LjQtYWxwaW5lMy4xOCAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgDQog DQpSVU4gYXBrIGFkZCAtLW5vLWNhY2hlIC0tdmlydHVhbCAuYnVpbGQtZGVwcyBidWlsZC1iYXNl IHBvc3RncmVzcWwtZGV2CmNsYW5nMTUgbGx2bTE1IDsgXA0KICAgIHdnZXQgLXFPLQpodHRwczov L2dpdGh1Yi5jb20vaUN5YmVyb24vcGdfaGFzaGlkcy9hcmNoaXZlL3JlZnMvdGFncy92MS4yLjEu dGFyLmd6IHwgdGFyCnh6ZiAtIC1DIC90bXAgJiYgXA0KICAgIG1ha2UgLUMgL3RtcC9wZ19oYXNo aWRzLTEuMi4xICYmIFwNCiAgICBtYWtlIC1DIC90bXAvcGdfaGFzaGlkcy0xLjIuMSBpbnN0YWxs ICYmIFwNCiAgICBybSAtcmYgL3RtcC9wZ19oYXNoaWRzLTEuMi4xICYmIFwNCiAgICBhcGsgZGVs IC5idWlsZC1kZXBzDQpgYGANCkRlcGxveWVkIHRvIHRoZSBjbHVzdGVyIHdpdGg6DQpgYGANCmhl bG0gaW5zdGFsbCBwb3N0Z3JlcyAtLXNldAppbWFnZS5yZXBvc2l0b3J5PXBvc3RncmVzLGltYWdl LnRhZz0ke0lNR19QT1NUR1JFU19UQUd9LHByaW1hcnkuc2VydmljZS5jbHVzdGVySVA9JHtQT1NU R1JFU19DTFVTVEVSX0lQfSxwcmltYXJ5LnBlcnNpc3RlbmNlLmV4aXN0aW5nQ2xhaW09cG9zdGdy ZXMKb2NpOi8vcmVnaXN0cnktMS5kb2NrZXIuaW8vYml0bmFtaWNoYXJ0cy9wb3N0Z3Jlc3FsDQpg YGANCg0KVGhlIGlzc3VlIGlzIHRoYXQgYSB0cmlnZ2VyIGZ1bmN0aW9uIHdoaWNoIGdlbmVyYXRl cyBoYXNoZXMgZHVyaW5nIGluc2VydCwKbWlzcy1iZWhhdmVzIGFuZCBnZW5lcmF0ZXMgYSAqd3Jv bmcgaGFzaCBlbmRpbmcgd2l0aCBhIHNwYWNlKi4gDQoNClJlcHJvZHVjZSBpdCBieSBydW5uaW5n IHRoZSBmb2xsb3dpbmcgU1FMOiANCmBgYA0KQkVHSU47DQpEUk9QIFNDSEVNQSBJRiBFWElTVFMg dGVzdCBDQVNDQURFOw0KQ1JFQVRFIFNDSEVNQSB0ZXN0Ow0KQ1JFQVRFIFRBQkxFIHRlc3QudGVz dCAoDQogICAgaWQgYmlnaW50IE5PVCBOVUxMLA0KICAgIGRhdGEgdGV4dCwNCiAgICBpZHMgdGV4 dCwNCiAgICBpZHMxIHRleHQsDQogICAgaWRzMiB0ZXh0DQopOw0KQ1JFQVRFIFNFUVVFTkNFIHRl c3QudGVzdF9pZF9zZXENCiAgICBTVEFSVCBXSVRIIDENCiAgICBJTkNSRU1FTlQgQlkgMQ0KICAg IE5PIE1JTlZBTFVFDQogICAgTk8gTUFYVkFMVUUNCiAgICBDQUNIRSAxOw0KQUxURVIgU0VRVUVO Q0UgdGVzdC50ZXN0X2lkX3NlcSBPV05FRCBCWSB0ZXN0LnRlc3QuaWQ7DQpBTFRFUiBUQUJMRSBP TkxZIHRlc3QudGVzdA0KICAgIEFMVEVSIENPTFVNTiBpZCBTRVQgREVGQVVMVCBuZXh0dmFsKCd0 ZXN0LnRlc3RfaWRfc2VxJzo6cmVnY2xhc3MpOw0KQ1JFQVRFIEZVTkNUSU9OIHRlc3QubXlmdW5j ICgpDQogICAgUkVUVVJOUyBUUklHR0VSDQogICAgTEFOR1VBR0UgcGxwZ3NxbA0KICAgIEFTICQk DQpCRUdJTg0KICAgIFVQREFURQ0KICAgICAgICB0ZXN0LnRlc3QNCiAgICBTRVQNCiAgICAgICAg aWRzID0gaWRfZW5jb2RlIChORVcuaWQsICdoYXNoMScsIDUsCidhYmNkZWZnaGlqa2xtbm9wcXJz dHV2d3h5eicpLA0KICAgICAgICBpZHMxID0gaWRfZW5jb2RlIChORVcuaWQsICdoYXNoMicsIDEy LAonYWJjZGVmZ2hpamtsbW5vcHFyc3R1dnd4eXonKSwNCiAgICAgICAgaWRzMiA9IGlkX2VuY29k ZSAoTkVXLmlkLCAnaGFzaDMnLCAxMiwKJ2FiY2RlZmdoaWprbG1ub3BxcnN0dXZ3eHl6JykNCiAg ICBXSEVSRQ0KICAgICAgICBpZCA9IE5FVy5pZDsNCiAgICBSRVRVUk4gbmV3Ow0KRU5EOw0KJCQ7 DQpDUkVBVEUgRlVOQ1RJT04gdGVzdC5teWZ1bmNfZml4ICgpDQogICAgUkVUVVJOUyBUUklHR0VS DQogICAgTEFOR1VBR0UgcGxwZ3NxbA0KICAgIEFTICQkDQpCRUdJTg0KICAgIFVQREFURQ0KICAg ICAgICB0ZXN0LnRlc3QNCiAgICBTRVQNCiAgICAgICAgaWRzID0gaWRfZW5jb2RlIChORVcuaWQs ICdoYXNoMScsIDUsICdhYmNkZWZnaGlqa2xtbm9wcXJzdHV2d3h5eicpDQogICAgV0hFUkUNCiAg ICAgICAgaWQgPSBORVcuaWQ7DQogICAgVVBEQVRFDQogICAgICAgIHRlc3QudGVzdA0KICAgIFNF VA0KICAgICAgICBpZHMxID0gaWRfZW5jb2RlIChORVcuaWQsICdoYXNoMicsIDEyLAonYWJjZGVm Z2hpamtsbW5vcHFyc3R1dnd4eXonKSwNCiAgICAgICAgaWRzMiA9IGlkX2VuY29kZSAoTkVXLmlk LCAnaGFzaDMnLCAxMiwKJ2FiY2RlZmdoaWprbG1ub3BxcnN0dXZ3eHl6JykNCiAgICBXSEVSRQ0K ICAgICAgICBpZCA9IE5FVy5pZDsNCiAgICBSRVRVUk4gbmV3Ow0KRU5EOw0KJCQ7DQpDUkVBVEUg VFJJR0dFUiB0ZXN0X215ZnVuYw0KICAgIEFGVEVSIElOU0VSVCBPTiB0ZXN0LnRlc3QNCiAgICBG T1IgRUFDSCBST1cNCiAgICBFWEVDVVRFIEZVTkNUSU9OIHRlc3QubXlmdW5jICgpOw0KXGNvcHkg dGVzdC50ZXN0IHRvIHN0ZG91dCBDU1YgRk9SQ0UgUVVPVEUgKjsNCklOU0VSVCBJTlRPIHRlc3Qu dGVzdCAoZGF0YSkNCiAgICBWQUxVRVMgKCdhJyksDQogICAgKCdiJyk7DQpcY29weSB0ZXN0LnRl c3QgdG8gc3Rkb3V0IENTViBGT1JDRSBRVU9URSAqOw0KRFJPUCBUUklHR0VSIHRlc3RfbXlmdW5j IE9OIHRlc3QudGVzdDsNCkNSRUFURSBUUklHR0VSIHRlc3RfbXlmdW5jX2ZpeA0KICAgIEFGVEVS IElOU0VSVCBPTiB0ZXN0LnRlc3QNCiAgICBGT1IgRUFDSCBST1cNCiAgICBFWEVDVVRFIEZVTkNU SU9OIHRlc3QubXlmdW5jX2ZpeCAoKTsNClxjb3B5IHRlc3QudGVzdCB0byBzdGRvdXQgQ1NWIEZP UkNFIFFVT1RFICo7DQpJTlNFUlQgSU5UTyB0ZXN0LnRlc3QgKGRhdGEpDQogICAgVkFMVUVTICgn YTEnKSwNCiAgICAoJ2IxJyk7DQpcY29weSB0ZXN0LnRlc3QgdG8gc3Rkb3V0IENTViBGT1JDRSBR VU9URSAqOw0KQ09NTUlUDQpgYGANCg0KUnVuIGl0IHdpdGg6IGBjYXQgdGVzdC5zcWwgfCBwc3Eg LVUgdGVzdGRiYC4NCg0KT3V0cHV0IGxvb2tzIGxpa2U6DQpgYGANCldBUk5JTkc6ICBkYXRhYmFz ZSAidGVzdGRiIiBoYXMgbm8gYWN0dWFsIGNvbGxhdGlvbiB2ZXJzaW9uLCBidXQgYSB2ZXJzaW9u CndhcyByZWNvcmRlZA0KQkVHSU4NCk5PVElDRTogIGRyb3AgY2FzY2FkZXMgdG8gMyBvdGhlciBv YmplY3RzDQpERVRBSUw6ICBkcm9wIGNhc2NhZGVzIHRvIHRhYmxlIHRlc3QudGVzdA0KZHJvcCBj YXNjYWRlcyB0byBmdW5jdGlvbiB0ZXN0Lm15ZnVuYygpDQpkcm9wIGNhc2NhZGVzIHRvIGZ1bmN0 aW9uIHRlc3QubXlmdW5jX2ZpeCgpDQpEUk9QIFNDSEVNQQ0KQ1JFQVRFIFNDSEVNQQ0KQ1JFQVRF IFRBQkxFDQpDUkVBVEUgU0VRVUVOQ0UNCkFMVEVSIFNFUVVFTkNFDQpBTFRFUiBUQUJMRQ0KQ1JF QVRFIEZVTkNUSU9ODQpDUkVBVEUgRlVOQ1RJT04NCkNSRUFURSBUUklHR0VSDQpJTlNFUlQgMCAy DQoiMSIsImEiLCJ6bW5iICIsInd6ZWpnbXBybW5wYSIsInl6dm1icnlkbm9nZCINCiIyIiwiYiIs InB5bHcgIiwieGFiZG9teXdtZW5sIiwiem1iZXhuYXducGFxIg0KRFJPUCBUUklHR0VSDQpDUkVB VEUgVFJJR0dFUg0KIjEiLCJhIiwiem1uYiAiLCJ3emVqZ21wcm1ucGEiLCJ5enZtYnJ5ZG5vZ2Qi DQoiMiIsImIiLCJweWx3ICIsInhhYmRvbXl3bWVubCIsInptYmV4bmF3bnBhcSINCklOU0VSVCAw IDINCiIxIiwiYSIsInptbmIgIiwid3plamdtcHJtbnBhIiwieXp2bWJyeWRub2dkIg0KIjIiLCJi IiwicHlsdyAiLCJ4YWJkb215d21lbmwiLCJ6bWJleG5hd25wYXEiDQoiMyIsImExIiwiem1wZG0i LCJqbHllem1yd3Zha2QiLCJ5Ymp3cHJnem5keGwiDQoiNCIsImIxIiwiZG1lcHkiLCJ5ZHFscHZq cnZ4bnoiLCJqd212cHJ4bW5rZWEiDQpDT01NSVQNCmBgYA0KDQpUaGUgaXNzdWUgaXMgdGhlIHNw YWNlIGluIHRoZSBlbmQgb2YgInptbmIgIi4gVXRpbGl6aW5nIGBteWZ1bmNfZml4KClgIHdoaWNo CmJhc2ljYWxseSBydW5zIHNlcGFyYXRlZCBgVVBEQVRFYCwgd29ya3MgaS5lLiBnZW5lcmF0ZXMg aGFzaGVzIHdpdGhvdXQgdGhlCnRyYWlsaW5nICBzcGFjZS4gQnV0IEkgYW0gbm90IGF0IGFsbCBz YXRpc2ZpZWQgYW5kIEkgd291bGQgbGlrZSB0bwp1bmRlcnN0YW5kIHdoYXQgaXMgdGhlIHJvb3Qg Y2F1c2U/IT8hIA0KDQpJIG5vdGljZWQgdGhlIGBXQVJOSU5HOiAgZGF0YWJhc2UgInRlc3RkYiIg aGFzIG5vIGFjdHVhbCBjb2xsYXRpb24gdmVyc2lvbiwKYnV0IGEgdmVyc2lvbiB3YXMgcmVjb3Jk ZWRgIGFuZCBJIGFtIG5vdCBzdXJlIGhvdyB0aGF0IGlzIHJlYWx0ZWQgKEkgZG8gbm90CnJlYWxs eSBrbm93IHdoYXQgaXMgdGhlIGltcGFjdCBvZiB0aGF0LiANCg0KQW55IGhlbHAgb3IgaWRlYXM/ Cgo= --===============2335089788040646666==--