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 1wgoNI-006Pzp-1l for pgsql-committers@arkaria.postgresql.org; Mon, 06 Jul 2026 18:49:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wgoNH-002VCR-0D for pgsql-committers@arkaria.postgresql.org; Mon, 06 Jul 2026 18:48:59 +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.96) (envelope-from ) id 1wgoMg-002T3v-09 for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 18:48:22 +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.98.2) (envelope-from ) id 1wgoMa-00000001tJg-1q6K for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 18:48:21 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wgoMZ-00C4Wb-2Y for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 18:48:15 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wgoMZ-001d4Q-1S for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 18:48:15 +0000 Content-Type: multipart/mixed; boundary="===============5134942942136480917==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix mishandling of leading '\' in nondeterministic LIKE. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 06 Jul 2026 18:48:15 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5134942942136480917== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IG1pc2hhbmRsaW5nIG9mIGxlYWRpbmcgJ1wnIGluIG5vbmRldGVybWluaXN0aWMgTElLRS4K ClRoZSBsb29wIGluIE1hdGNoVGV4dCgpIHByb2Nlc3NlZCBhIGxlYWRpbmcgJ1wnIHdpdGhvdXQg cmVnYXJkIHRvCm5vbmRldGVybWluaXN0aWMgbG9jYWxlcywgd2hpY2ggaXMgcHJvYmxlbWF0aWMg aWYgd2hhdCB0aGUgJ1wnCnByZWNlZGVzIGlzIGFuIG9yZGluYXJ5IGNoYXJhY3RlciB0aGF0IHNo b3VsZCBiZSBzdWJqZWN0IHRvCm5vbmRldGVybWluaXN0aWMgbWF0Y2hpbmcuICBXZSdkIGluc2lz dCBvbiBhIGxpdGVyYWwgbWF0Y2ggZm9yIGl0LAp3aGljaCBpcyBub3QgcmlnaHQgYW5kIGlzIG5v dCBsaWtlIHdoYXQgaGFwcGVucyB3aXRoIGEgJ1wnIHRoYXQKZm9sbG93cyBzb21lIG9yZGluYXJ5 IGNoYXJhY3RlcnMuICBXb3JzZSwgd2UnZCB0aGVuIGFkdmFuY2UgdGhlIHRleHQKYW5kIHBhdHRl cm4gcG9pbnRlcnMgYnkgb25lIGJ5dGUsIHNvIHRoYXQgaWYgdGhlIGVzY2FwZWQgY2hhcmFjdGVy CmlzIG11bHRpYnl0ZSB0aGUgbmV4dCBsb29wIGl0ZXJhdGlvbiB3b3VsZCB0YWtlIHRoZSBub25k ZXRlcm1pbmlzdGljCmNvZGUgcGF0aCBzdGFydGluZyBhdCBhIHBvaW50IHdpdGhpbiB0aGUgY2hh cmFjdGVyLiAgVGhhdCBjb3VsZCB2ZXJ5CnBvc3NpYmx5IGNhdXNlIHBnX3N0cm5jb2xsKCkgdG8g bWlzYmVoYXZlLgoKVGhlIGZpeCBpcyBxdWl0ZSBzaW1wbGU6IG1vdmUgdGhlIHN0YW56YSB0aGF0 IGhhbmRsZXMgJ1wnIGRvd24gcGFzdAp0aGUgb25lIHRoYXQgaGFuZGxlcyBub25kZXRlcm1pbmlz bS4gIFRoZSBzdGFuemFzIGZvciAnJScgYW5kICdfJwphcmUgZmluZSB3aGVyZSB0aGV5IGFyZSwg YnV0IHRoZSAnXCcgc3RhbnphIGlzIG9ubHkgY29ycmVjdCBmb3IKZGV0ZXJtaW5pc3RpYyBtYXRj aGluZy4gIFRoZSBsb2dpYyBmb3Igbm9uZGV0ZXJtaW5pc3RpYyBjYXNlcyBpcwphbHJlYWR5IHBy ZXBhcmVkIHRvIGRvIHRoZSByaWdodCB0aGluZ3Mgd2l0aCBhICdcJy4KCldoaWxlIGhlcmUsIEkg cmVwbGFjZWQgdGVzdHMgb2YgImxvY2FsZSAmJiAhbG9jYWxlLT5kZXRlcm1pbmlzdGljIgp3aXRo IGEgYm9vbGVhbiBsb2NhbCB2YXJpYWJsZSwgcmVhc29uaW5nIHRoYXQgdGhvc2UgYXJlIGluIHRo ZSBob3QKbG9vcCBwYXRocyBzbyBzYXZpbmcgYSBicmFuY2ggYW5kIGluZGlyZWN0IGZldGNoIGlz IHdvcnRoIHRoZQp0cm91YmxlLiAgSSBhbHNvIGltcHJvdmVkIGEgbnVtYmVyIG9mIHJlbGF0ZWQg Y29tbWVudHMuCgpBdXRob3I6IFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51cz4KRGlzY3Vzc2lv bjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8zOTE1OTIuMTc4MzE4Nzk4NkBzc3MucGdoLnBhLnVzCkJh Y2twYXRjaC10aHJvdWdoOiAxOAoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0t LQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzQyYjdmZjNhYWVmYTVm NjNiNDg5MDY3OWEyODNmODNmMWE0YWNiMDAKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0t CnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9saWtlX21hdGNoLmMgICAgICAgICAgICAgfCA3NiArKysr KysrKysrKysrKystLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NvbGxhdGUu aWN1LnV0Zjgub3V0IHwgMzAgKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9jb2xsYXRl LmljdS51dGY4LnNxbCAgICAgIHwgIDYgKysKMyBmaWxlcyBjaGFuZ2VkLCA4MCBpbnNlcnRpb25z KCspLCAzMiBkZWxldGlvbnMoLSkKCg== --===============5134942942136480917==--