pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: SIMILAR TO expressions translate wildcards where they shouldn't
Date: Wed, 28 May 2025 09:15:33 +0900
Message-ID: <aDZVpfnWONm10F35@paquier.xyz> (raw)
In-Reply-To: <aDZSFLHbohoLJQLd@paquier.xyz>
References: <16ab039d1af455652bdf4173402ddda145f2c73b.camel@cybertec.at>
	<aC_K7JPXF0AdPZqB@paquier.xyz>
	<aC_p7b5H6pLICU_e@paquier.xyz>
	<5498224d1d5a6a3be7f29ae7725f76162d48372f.camel@cybertec.at>
	<aDVUWaoZg8cW3B9x@paquier.xyz>
	<37584c1321b984a0c5c05d213ef70b869d95a12a.camel@cybertec.at>
	<1101508.1748357652@sss.pgh.pa.us>
	<b4b25c91f05f0be8fb7072c8dbf9d4ca6062b303.camel@cybertec.at>
	<aDZSFLHbohoLJQLd@paquier.xyz>

On Wed, May 28, 2025 at 09:00:20AM +0900, Michael Paquier wrote:
> 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.

And I've managed to miss that the case with an opening parenthesis
throws an error due to an unbalanced set of parentheses because the
regexp is processed when the query is written the way Tom has
mentioned.

Will fix in a bit after an extra round of check-world, sorry about
that..
--
Michael

Attachments:

  [application/pgp-signature] signature.asc (832B, ../aDZVpfnWONm10F35@paquier.xyz/2-signature.asc)
  download

view thread (11+ messages)  latest in thread

Message-ID: <aDZVpfnWONm10F35@paquier.xyz>
Permalink:  ../aDZVpfnWONm10F35@paquier.xyz/
Also on:    postgresql.org/message-id/aDZVpfnWONm10F35@paquier.xyz

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: michael@paquier.xyz, laurenz.albe@cybertec.at, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
  Subject: Re: SIMILAR TO expressions translate wildcards where they shouldn't
  In-Reply-To: <aDZVpfnWONm10F35@paquier.xyz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox