Re: Latest patches break one of our unit-test, related to RLS

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dominique Devienne <ddevienne(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general(at)postgresql(dot)org, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: Latest patches break one of our unit-test, related to RLS
Date: 2025-09-12 16:32:33
Message-ID: 202509121631.dtn5kw5er2m5@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2025-Sep-12, Tom Lane wrote:

> Dominique Devienne <ddevienne(at)gmail(dot)com> writes:
> >> This DOES look like a bug, no? I've done regexes for a long time,
> >> and these two forms should be equivalent IMHO. --DD
>
> Yeah, I agree it's busted. You can use EXPLAIN VERBOSE to see the
> translated-to-POSIX pattern, and it's wrong:

And now we also have
https://postgr.es/m/41a37137-f8bb-8fc5-2948-31b528f166dc@bfw-online.de

CC'ed the committer here.

--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"La victoria es para quien se atreve a estar solo"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ellen Allhatatlan 2025-09-12 19:16:51 Re: MVCC and all that...
Previous Message Dominique Devienne 2025-09-12 14:28:36 Re: Latest patches break one of our unit-test, related to RLS