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:00:20 +0900
Message-ID: <aDZSFLHbohoLJQLd@paquier.xyz> (raw)
In-Reply-To: <b4b25c91f05f0be8fb7072c8dbf9d4ca6062b303.camel@cybertec.at>
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>

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

Attachments:

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

view thread (11+ messages)  latest in thread

Message-ID: <aDZSFLHbohoLJQLd@paquier.xyz>
Permalink:  ../aDZSFLHbohoLJQLd@paquier.xyz/
Also on:    postgresql.org/message-id/aDZSFLHbohoLJQLd@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: <aDZSFLHbohoLJQLd@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