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.96) (envelope-from ) id 1vQQOF-007Cvi-0p for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Dec 2025 13:25:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vQQNF-007whQ-0P for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Dec 2025 13:24:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vQNEw-0077Qp-0a for pgsql-bugs@lists.postgresql.org; Tue, 02 Dec 2025 10:04:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vQNEr-002iEe-2j for pgsql-bugs@lists.postgresql.org; Tue, 02 Dec 2025 10:04:08 +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=YIR2kjPpaQgYM6vNoY78p9TNll6z+inz0GhnizzStLU=; b=HE+CcTGnLSSpeT//pGyER7JsXe RNOWjTWQDnQFr4lkJwmKU4JOl5f/bKv33DjjaUm21Im9QJtaDMTBsBxve7eNYj0M6HLMCR6S8Jb9R 03KhDfUOcht1RZcMaT6AOKuvs9E4VTBnO6+tOqN79juyXpdRBI3PayJWO9M8Qt9+f9mMS+9ORDVRm rsRkk7S1o8B5LtIiduBTEPIwoKfvENMIGrPkfxx+nsoCrsdXGgvb1UDTSyP5rcnNI5VlDUSUxvAEs pAYK6LU5WTPDLPCvecmTnmrgmNEyN5ZQ0QzuP7hdbf98tUZ3g6QIcMVf8cc/79IFxEis7FPixUq6A DFtgye+A==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vQNEq-003xHR-18 for pgsql-bugs@lists.postgresql.org; Tue, 02 Dec 2025 10:04:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vQNEo-003Ykx-0n for pgsql-bugs@lists.postgresql.org; Tue, 02 Dec 2025 10:04:03 +0000 Content-Type: multipart/mixed; boundary="===============8748129507451402442==" MIME-Version: 1.0 Subject: BUG #19341: REPLACE() fails to match final character when using nondeterministic ICU collation To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: adam.warland@infor.com Reply-To: adam.warland@infor.com, pgsql-bugs@lists.postgresql.org Date: Tue, 02 Dec 2025 10:03:44 +0000 Message-ID: <19341-1d9a22915edfec58@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 --===============8748129507451402442== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTM0MQpMb2dnZWQgYnk6ICAgICAgICAgIEFkYW0gV2FybGFuZApFbWFp bCBhZGRyZXNzOiAgICAgIGFkYW0ud2FybGFuZEBpbmZvci5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxOC4xCk9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyAxMSBFbnRlcnByaXNlCkRlc2NyaXB0 aW9uOiAgICAgICAgCgpXaGVuIHVzaW5nIGEgbm9uZGV0ZXJtaW5pc3RpYyBJQ1UgY29sbGF0aW9u LCB0aGUgcmVwbGFjZSgpIGZ1bmN0aW9uIGZhaWxzIHRvCnJlcGxhY2UgYSBzdWJzdHJpbmcgd2hl biB0aGF0IHN1YnN0cmluZyBhcHBlYXJzIGF0IHRoZSBlbmQgb2YgdGhlIGlucHV0CnN0cmluZy4K Ck9jY3VycmVuY2VzIG9mIHRoZSBzYW1lIHN1YnN0cmluZyBlYXJsaWVyIGluIHRoZSBzdHJpbmcg YXJlIHJlcGxhY2VkCm5vcm1hbGx5LgoKVGhpcyBhcHBlYXJzIHRvIGJlIHVuaW50ZW5kZWQgYW5k IGluY29uc2lzdGVudCB3aXRoIHRoZSBkb2N1bWVudGVkCmxpbWl0YXRpb25zIG9mIG5vbmRldGVy bWluaXN0aWMgY29sbGF0aW9ucy4gVGhlIGZhaWx1cmUgc2VlbXMgc3BlY2lmaWMgdG8Kc2l0dWF0 aW9ucyB3aGVyZToKICAgICAgICDigKIgYSBub25kZXRlcm1pbmlzdGljIElDVSBjb2xsYXRpb24g aXMgYXBwbGllZCB0byBib3RoIHNvdXJjZSBhbmQKbWF0Y2ggc3RyaW5ncywgYW5kCiAgICAgICAg 4oCiIHRoZSBzdWJzdHJpbmcgYmVpbmcgcmVwbGFjZWQgYXBwZWFycyBhcyB0aGUgZmluYWwgY2hh cmFjdGVyIG9mIHRoZQpzb3VyY2Ugc3RyaW5nLgoKVGhlIGJlaGF2aW9yIHJlcHJvZHVjZXMgcmVs aWFibHkuCgpFeHBlY3RlZCBCZWhhdmlvcgpyZXBsYWNlKCkgc2hvdWxkIHJlcGxhY2UgYWxsIG9j Y3VycmVuY2VzIG9mIHRoZSBtYXRjaCBzdWJzdHJpbmcsIGluY2x1ZGluZwpvbmUgYXQgdGhlIGZp bmFsIHBvc2l0aW9uLCByZWdhcmRsZXNzIG9mIGNvbGxhdGlvbiDigJQgb3IsIGlmIG5vbmRldGVy bWluaXN0aWMKY29sbGF0aW9ucyBjYW5ub3Qgc3VwcG9ydCB0aGlzIG9wZXJhdGlvbiwgZG9jdW1l bnRhdGlvbiBzaG91bGQgZXhwbGljaXRseQpzdGF0ZSB0aGUgbGltaXRhdGlvbiAoYXMgaXMgYWxy ZWFkeSBkb25lIGZvciBMSUtFIGFuZCByZWd1bGFyIGV4cHJlc3Npb25zKS4KCkFjdHVhbCBCZWhh dmlvcgpVbmRlciBhIG5vbmRldGVybWluaXN0aWMgSUNVIGNvbGxhdGlvbiwgdGhlIGZpbmFsIG9j Y3VycmVuY2Ugb2YgdGhlCnN1YnN0cmluZyBpcyBub3QgcmVwbGFjZWQsIGV2ZW4gdGhvdWdoIGVh cmxpZXIgb2NjdXJyZW5jZXMgYXJlLgpFeGFtcGxlIG91dHB1dCAoYWN0dWFsKSByZXBsYWNlIHgg d2l0aCB5IDoKcmVzMSAgfCB0ZXN0eCAgICAgLS0gdW5jaGFuZ2VkLCBpbmNvcnJlY3QgKGZpbmFs IGNoYXJhY3RlciBub3QgcmVwbGFjZWQpCnJlczIgIHwgeWFiY2R4ICAgIC0tIGZpcnN0ICd4JyBy ZXBsYWNlZCwgZmluYWwgJ3gnIG5vdCByZXBsYWNlZApVbmRlciBhIGRldGVybWluaXN0aWMgb3Ig QyBjb2xsYXRpb24sIG91dHB1dCBpcyBjb3JyZWN0OgpyZXNfQyB8IHRlc3R5CgpFbnZpcm9ubWVu dApTRUxFQ1QgdmVyc2lvbigpOwrihpIgUG9zdGdyZVNRTCAxOC4xIChEZWJpYW4gMTguMS0xLnBn ZGcxMysyKSBvbiB4ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxlZApieSBnY2MgKERlYmlhbiAx NC4yLjAtMTkpIDE0LjIuMCwgNjQtYml0LgpTSE9XIHNlcnZlcl9lbmNvZGluZzsK4oaSIFVURjgK U0hPVyBsY19jb2xsYXRlOwpTSE9XIGxjX2N0eXBlOwrihpIgZW5fVVMudXRmOAplbl9VUy51dGY4 CgpTcGVjaWZpYyBjb2xsYXRpb24gdXNlZDoKY3JlYXRlIGNvbGxhdGlvbiB0ZXN0X25vbmRldGVy bWluaXN0aWMgKAogICAgcHJvdmlkZXIgPSBpY3UsCiAgICBsb2NhbGUgPSAndW5kLXUta3MtbGV2 ZWwyJywKICAgIGRldGVybWluaXN0aWMgPSBmYWxzZQopCgoKTWluaW1hbCBSZXByb2R1Y3Rpb24g Q2FzZQoKZHJvcCBDT0xMQVRJT04gaWYgRVhJU1RTIHRlc3Rfbm9uZGV0ZXJtaW5pc3RpYzsKY3Jl YXRlIGNvbGxhdGlvbiB0ZXN0X25vbmRldGVybWluaXN0aWMgKAogICAgcHJvdmlkZXIgPSBpY3Us CiAgICBsb2NhbGUgPSAndW5kLXUta3MtbGV2ZWwyJywKICAgIGRldGVybWluaXN0aWMgPSBmYWxz ZQopOwotLSBSZXBsYWNlIGZpbmFsIGNoYXJhY3RlciB1bmRlciBub25kZXRlcm1pbmlzdGljIGNv bGxhdGlvbgpTRUxFQ1QgcmVwbGFjZSgKICAgICd0ZXN0eCcgQ09MTEFURSAidGVzdF9ub25kZXRl cm1pbmlzdGljIiwKICAgICd4JyAgICAgQ09MTEFURSAidGVzdF9ub25kZXRlcm1pbmlzdGljIiwK ICAgICd5JykgQVMgcmVzMTsKLS0gUmVwbGFjZSBzdWJzdHJpbmcgYXBwZWFyaW5nIHR3aWNlIOKA lCBmaW5hbCBvbmUgZmFpbHMKU0VMRUNUIHJlcGxhY2UoCiAgICAneGFiY2R4JyBDT0xMQVRFICJ0 ZXN0X25vbmRldGVybWluaXN0aWMiLAogICAgJ3gnICAgICAgQ09MTEFURSAidGVzdF9ub25kZXRl cm1pbmlzdGljIiwKICAgICd5JykgQVMgcmVzMjsKLS0gQ29udHJvbCB0ZXN0IHVzaW5nIGRldGVy bWluaXN0aWMgY29sbGF0aW9uClNFTEVDVCByZXBsYWNlKAogICAgJ3Rlc3R4JyBDT0xMQVRFICJD IiwKICAgICd4JyAgICAgQ09MTEFURSAiQyIsCiAgICAneScpIEFTIHJlc19DOwoKT2JzZXJ2ZWQg cmVzdWx0OgpyZXMxIGFuZCB0aGUgZmluYWwgeCBpbiByZXMyIGFyZSBub3QgcmVwbGFjZWQuCgpB ZGRpdGlvbmFsIE5vdGVzCiAgICAgICAg4oCiIFRoZSBpc3N1ZSBkb2VzIG5vdCBvY2N1ciB3aXRo IGRldGVybWluaXN0aWMgSUNVIGNvbGxhdGlvbnMgb3Igd2l0aApDIGNvbGxhdGlvbi4KICAgICAg ICDigKIgVGhlIGZhaWx1cmUgc2VlbXMgdGllZCBzcGVjaWZpY2FsbHkgdG8gdGhlIGxhc3QgY2hh cmFjdGVyCnBvc2l0aW9uLCB3aGljaCBtYXkgaW5kaWNhdGUgYW4gb2ZmLWJ5LW9uZSBpc3N1ZSBv ciBhIGxpbWl0YXRpb24gaW4Kc3Vic3RyaW5nIG1hdGNoaW5nIHVuZGVyIG5vbmRldGVybWluaXN0 aWMgY29sbGF0aW9uIHJ1bGVzLgogICAgICAgIOKAoiBObyBkb2N1bWVudGF0aW9uIGN1cnJlbnRs eSBzdGF0ZXMgdGhhdCByZXBsYWNlKCkgaXMgcGFydGlhbGx5CnVuc3VwcG9ydGVkIHdpdGggbm9u ZGV0ZXJtaW5pc3RpYyBjb2xsYXRpb25zLCBhbHRob3VnaCBvdGhlciBvcGVyYXRpb25zCihMSUtF LCByZWdleCkgaGF2ZSBoaXN0b3JpY2FsbHkgYmVlbiByZXN0cmljdGVkLgoKQ29uY2x1c2lvbgpy ZXBsYWNlKCkgYXBwZWFycyB0byBiZWhhdmUgaW5jb3JyZWN0bHkgd2hlbiBtYXRjaGluZyBhIHN1 YnN0cmluZyBhdCB0aGUgZW5kCm9mIGEgc3RyaW5nIHVuZGVyIG5vbmRldGVybWluaXN0aWMgSUNV IGNvbGxhdGlvbnMuIFRoaXMgaXMgZWl0aGVyOgogICAgICAgIOKAoiBhIGRlZmVjdCBpbiBob3cg bm9uZGV0ZXJtaW5pc3RpYyBjb2xsYXRpb25zIGludGVyYWN0IHdpdGgKc3Vic3RyaW5nIG1hdGNo aW5nIGZ1bmN0aW9ucywgb3IKYW4gdW5kb2N1bWVudGVkIGxpbWl0YXRpb24gdGhhdCBzaG91bGQg YmUgY2xhcmlmaWVkLgoK --===============8748129507451402442==--