I hope I’m articulating myself properly since we’re new to memsql as a product.
We’ve identified the following behaviour and I’m not sure how to label it nor how to tackle it:
We’ve implemented rls and created 5 new roles, it seem only the first 3 roles we apply stick while the 4th, 5th, and assuming anything after that doesn’t return any results.
So if I have the roles A, B, C, D and E - which ever 3 I choose to apply first will return results, if I apply a 4th role no results what so ever gets returned.
Role A -> I get a table back
Role BC -> I get a table back
Role EAD -> I get a table back
If I introduce more than 3 roles, ANY 3 roles, I don’t get anything back.
Any advice here would be most helpful.