Horton
Menu

Re: SIMILAR TO expressions translate wildcards where they shouldn't

Michael Paquier <michael@paquier.xyz>

View thread
From: Michael Paquier <michael@paquier.xyz>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs@lists.postgresql.org
Date: 2025-05-28T00:00:20Z
Lists: pgsql-bugs 
On Tue, May 27, 2025 at 11:39:02PM +0200, Laurenz Albe wrote:
> I originally considered EXPLAIN (GENERIC_PLAN), but that would only
> backpatch so far.

Nice trick that makes the test output much smaller.  I've used this
idea and applied the fix down to v13 after a second lookup this
morning.
--
Michael

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Adjust regex for test with opening parenthesis in character classes

  2. Fix conversion of SIMILAR TO regexes for character classes