Horton

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

Adrian Klaver <adrian.klaver@aklaver.com>

View thread View on postgr.es
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Dominique Devienne <ddevienne@gmail.com>, pgsql-general@postgresql.org
Date: 2025-09-04T15:12:56Z
Lists: pgsql-general 
On 9/4/25 08:03, Dominique Devienne wrote:
> In the same vein as v18betas breaking our unit-tests...
> (we still don't understand, haven't looked much though).
> 
> OK, above it's about a major upgrade. So that's one thing.
> 
> But now, we've ascertain that a particular test is:
> 
> OK with 16.9 and 17.5 (we cannot test on beta2 anymore)
> KO with 16.10 and 17.6 (and beta3 too, released at the same time)

How did you move from one version to the other?

> 
> Which for a minor patch is a surprise to us, not in a good way.
> 
> So... Did anything change around RLS in this patch series?
> Anything changed around ROLE INHERIT rules?
> 
> The symptom is that a LOGIN user lacks ROLEs is used to have.
> So perhaps some GRANTs are now silently doing nothing,
> for some unknown reasons.

What are the GRANTs that are done to give the user the privileges?

> 
> What in these patches could be affecting those areas?
> 
> Thanks, --DD
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Commits

  1. Amend recent fix for SIMILAR TO regex conversion.

  2. Fix conversion of SIMILAR TO regexes for character classes