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(dot)klaver(at)aklaver(dot)com