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-0V 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-002VCT-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-002T3Z-02 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-00000001tJj-1qCp for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 18:48:21 +0000 Received: from gemulon.postgresql.org ([72.32.157.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-00C4Wf-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-001d4a-1g for pgsql-committers@lists.postgresql.org; Mon, 06 Jul 2026 18:48:15 +0000 Content-Type: multipart/mixed; boundary="===============3076750137313222627==" 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 --===============3076750137313222627== 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 Y2twYXRjaC10aHJvdWdoOiAxOAoKQnJhbmNoCi0tLS0tLQpSRUxfMThfU1RBQkxFCgpEZXRhaWxz Ci0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi81MTY1MmM0 MmRhMmU5ODJmYjcwMjg5NzBlZWE1ZWVkNGM2NzBhNTU1CgpNb2RpZmllZCBGaWxlcwotLS0tLS0t LS0tLS0tLQpzcmMvYmFja2VuZC91dGlscy9hZHQvbGlrZV9tYXRjaC5jICAgICAgICAgICAgIHwg NzYgKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9j b2xsYXRlLmljdS51dGY4Lm91dCB8IDMwICsrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwv Y29sbGF0ZS5pY3UudXRmOC5zcWwgICAgICB8ICA2ICsrCjMgZmlsZXMgY2hhbmdlZCwgODAgaW5z ZXJ0aW9ucygrKSwgMzIgZGVsZXRpb25zKC0pCgo= --===============3076750137313222627==--