You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
grant select access to foo on asdf._file_with_spaces where pay_basis = 'ANN'
And the query:
SELECT*fromasdf._file_with_spaceswhere agency in (SELECT distinct(agency) as _file_with_spaces fromasdf._file_with_spaceswhere agency like'Department%'order by agency)
The result after an RLS rewrite is:
SELECT*from (
SELECT*FROMasdf._file_with_spacesWHERE pay_basis ='ANN')
AS asdf_file_with_spaces where agency in (
SELECT distinct(agency) as _file_with_spaces from (
SELECT*FROM asdf_file_with_spaces WHERE pay_basis ='ANN')
AS asdf_file_with_spaces where agency like'Department%'order by agency)
The third occurence of asdf_file_with_spaces is a problem, since it doesn't exist at that point. This query results in a 404 since the table can't be found.
The text was updated successfully, but these errors were encountered:
Given the RLS rule:
And the query:
The result after an RLS rewrite is:
The third occurence of asdf_file_with_spaces is a problem, since it doesn't exist at that point. This query results in a 404 since the table can't be found.
The text was updated successfully, but these errors were encountered: