Horton

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

Álvaro Herrera <alvherre@kurilemu.de>

View thread View on postgr.es
From: Álvaro Herrera <alvherre@kurilemu.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dominique Devienne <ddevienne@gmail.com>, Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-general@postgresql.org, Michael Paquier <michael@paquier.xyz>
Date: 2025-09-12T16:32:33Z
Lists: pgsql-general 
On 2025-Sep-12, Tom Lane wrote:

> Dominique Devienne <ddevienne@gmail.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"

Commits

  1. Amend recent fix for SIMILAR TO regex conversion.

  2. Fix conversion of SIMILAR TO regexes for character classes