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

Laurenz Albe <laurenz.albe@cybertec.at>

From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Michael Paquier <michael@paquier.xyz>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs@lists.postgresql.org
Date: 2025-05-28T08:33:39Z
Lists: pgsql-bugs
On Wed, 2025-05-28 at 09:00 +0900, Michael Paquier wrote:
> 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.

Thanks for taking care of this!

Yours,
Laurenz Albe



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