Our company is encountering an unusual issue today. Some tables with Row-Level Security (RLS) applied, when joined together, are returning results that do not respect the RLS policies. This problem has never occurred before. Interestingly, when we switch to a single-user cluster, the queries execute correctly and respect the RLS.
Is anyone else experiencing a similar situation? Any insights or solutions would be greatly appreciated.