perms_users_sanitize (userId is null) ignores tenant

Description

IF NOT EXISTS (SELECT 1 FROM pg_constraint WHERE conname = 'permissions_users_userid_not_null') THEN

in perms_users_sanitize.sql checks if the constraint exists for any tenant.

This doesn't execute the code for all but the first tenant in a multi-tenant environment.

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:
Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Core: Platform

Fix versions

RCA Group

TBD

CSP Approved

Yes

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created May 6, 2022 at 2:18 PM
Updated January 18, 2023 at 10:09 AM
Resolved May 6, 2022 at 3:07 PM
TestRail: Cases
TestRail: Runs

Flag notifications