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 1tDNlh-000Jho-SL for pgsql-bugs@arkaria.postgresql.org; Tue, 19 Nov 2024 12:55:46 +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 1tDNlg-00D3Up-1k for pgsql-bugs@arkaria.postgresql.org; Tue, 19 Nov 2024 12:55:44 +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.94.2) (envelope-from ) id 1tDC6B-008srv-Rr for pgsql-bugs@lists.postgresql.org; Tue, 19 Nov 2024 00:28:08 +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.94.2) (envelope-from ) id 1tDC6A-002ehm-42 for pgsql-bugs@lists.postgresql.org; Tue, 19 Nov 2024 00:28:07 +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=GhQDrRcJ/B4oJUW2vu2QCzZ9SxWmjvjyqZOPbhGhN9U=; b=5NVyBvx/c0BPmABfEBrYtXnAwK z6QuAtJzXIJ6JVtc6mJ4lE6yeTj8iYZfQIOE7jC444/U4fSOliCR+j1HutHEY36GQ1olegXljRH1A zwRHY3N9y7v/kcGCUWmW3yU5PYYdWFMjhcXfYeVvO4MqRFfeX3Q2eeGf99sng0DdI/oOiajez7CCi 67fIkEqAIHEtd6jy4XFqR6n6br9SnFa7ighSI619ybAJW2lz5d6eh5yy7wUf67IBsyUPibDWvP12Y hrhzlElcPCar6FMuyZDuqhCs5kzKApLnJaS+9iyo+RmZFz8/vq550W9CcL30425jrqmkqDmp3Ykna IIdeWyAA==; 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.94.2) (envelope-from ) id 1tDC68-0089Yp-LF for pgsql-bugs@lists.postgresql.org; Tue, 19 Nov 2024 00:28: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 1tDC66-008HWo-5r for pgsql-bugs@lists.postgresql.org; Tue, 19 Nov 2024 00:28:03 +0000 Content-Type: multipart/mixed; boundary="===============4132731548952845178==" MIME-Version: 1.0 Subject: BUG #18715: replace() function silently fails if 3rd argument is null To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: xpusostomos@gmail.com Reply-To: xpusostomos@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 19 Nov 2024 00:28:02 +0000 Message-ID: <18715-7035b5d78571887e@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 --===============4132731548952845178== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODcxNQpMb2dnZWQgYnk6ICAgICAgICAgIENocmlzCkVtYWlsIGFkZHJl c3M6ICAgICAgeHB1c29zdG9tb3NAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTYuNQpP cGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpJbWFnaW5lIEkn bSB1c2luZyB0aGUgcmVwbGFjZSgpIHRvIGRvIHZhcmlhYmxlIHN1YnN0aXR1dGlvbiBvbiBkYXRh YmFzZQpmaWVsZHMuLg0KcmVwbGFjZShteXRhYmxlLm15ZmllbGQxLCAnJHttfScsIG15dGFibGUy Lm15ZmllbGQyKQ0KDQpBdCBydW50aW1lLCB0aGlzIG1pZ2h0IGxvb2sgbGlrZToNCnJlcGxhY2Uo J2FiYyR7bX1kZWYnLCAnJHttfScsICdoZWxsbyEnKSA9PiAnYWJjaGVsbG8hZGVmJzsNCg0KT0ss IGJ1dCBub3cgaW1hZ2luZSB0aGF0IGF0IHJ1bnRpbWUgdGhlIDNyZCBhcmd1bWVudCBpcyBudWxs Li4uIGFuZCB3ZQpleHBlY3QgaXQgdG8gYmUgbnVsbCBiZWNhdXNlIHRoYXQgdmFyaWFibGUgaXMg bm90IHVzZWQgaW4gdGhhdCB0dXBsZToNCnJlcGxhY2UoJ2FiY2RlZicsICcke219JywgbnVsbCkg PT4gbnVsbA0KDQpzbyB3ZSdkIGV4cGVjdCB0aGUgcmVzdWx0ICdhYmNkZWYnLCBiZWNhdXNlICck e219JyBkb2VzIG5vdCBvY2N1ciBpbiB0aGUKc3RyaW5nLCB0aHVzIHdlJ2QgZXhwZWN0IHRoZSAz cmQgYXJndW1lbnQgdG8gYmUgaWdub3JlZC4uLiBob3dldmVyIHRoYXQncwpub3Qgd2hhdCBoYXBw ZW5zLCB0aGUgcmVzdWx0IGlzIG51bGwuIE5vIGVycm9yIGlzIHJhaXNlZCwgaXQganVzdCBzaWxl bnRseQpkb2VzIHNvbWV0aGluZyB2ZXJ5IG9kZC4NCg0Kd2UgY2FuIGdldCBhcm91bmQgaXQgb2Yg Y291cnNlLi4uLg0KcmVwbGFjZShteXRhYmxlLm15ZmllbGQxLCAnJHttfScsIGNvYWxlc2NlKG15 dGFibGUyLm15ZmllbGQyLCAnJykpDQoNCkJ1dCBzdXJlbHkgdGhhdCdzIG5lZWRsZXNzbHkgYW5k IGFic3VyZGx5IGNvbXBsaWNhdGVkIGZvciBubyByZWFzb24uIElmIHRoZQoybmQgYXJndW1lbnQg ZG9lcyBub3Qgb2NjdXIgaW4gdGhlIHN0cmluZywgd2hhdCBidXNpbmVzcyBkb2VzIHJlcGxhY2Uo KSBoYXZlCmluIG1vbGVzdGluZyB0aGUgc3RyaW5nPw0KDQpTbyB0aGUgYnVnIGlzIHRoYXQuLi4N CnJlcGxhY2UoJ2doaScsICdqa2wnLCBudWxsKSBvdWdodCB0byByZXR1cm4gJ2doaScsIGJlY2F1 c2Ugc2luY2UgJ2prbCcgZG9lcwpub3Qgb2NjdXIgaW4gJ2doaScgdGhlIHN0cmluZyBzaG91bGQg YmUgdW5tb2xlc3RlZCwgYW5kIHRoZSBmYWN0IHRoYXQgdGhlCjNyZCBhcmd1bWVudCBpcyBudWxs IG91Z2h0IG5vdCB0byBhZmZlY3QgdGhlIG91dGNvbWUuDQoNCk9uZSBtaWdodCBhc2sgd2hhdCBv dWdodCB0byBoYXBwZW4gaWYgdGhlIHN0cmluZyBkb2VzIG9jY3VyIHRoZXJlIGFuZCB0aGUKM3Jk IGFyZ3VtZW50IGlzIG51bGwuIFRoYXQgZG9lcyBub3QgZGlyZWN0bHkgY29uY2VybiBtZSB0aGVy ZSwgYWx0aG91Z2ggaW4KbXkgb3BpbmlvbiwgaXQgbWFrZXMgbW9yZSBzZW5zZSB0byBjb25zaWRl ciBudWxsIGFzIGVtcHR5IHN0cmluZyBiZWNhdXNlCnRoYXQncyBhIHJhdGlvbmFsIGV4cGVjdGF0 aW9uIGZvciBhIHByb2dyYW1tZXIsIHdoZXJlYXMgcmV0dXJuaW5nIG51bGwgaXMgYW4KIkkgZ2l2 ZSB1cCIgcmVzcG9uc2UuIFdoZW4gcGVvcGxlIHVzZSByZXBsYWNlKCkgdGhleSBhcmUgdmVyeSBt dWNoIGhvcGluZwphbmQgZXhwZWN0aW5nLCBpZiBhdCBhbGwgaHVtYW5seSBwb3NzaWJsZSwgdG8g Z2V0IGEgc3RyaW5nIGluIHJldHVybiwgYW5kCm5vdCB0byBnaXZlIHVwIHRvIG51bGwgd2hlbiB0 aGVyZSBpcyBhIHJhdGlvbmFsIHVzZWZ1bCBpbnRlcnByZXRhdGlvbiBvZiB0aGUKaW5wdXRzLgoK --===============4132731548952845178==--