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

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