RLS seems unable to handle multiple references to the same table.

[justinanderson]

Given the RLS rule:

grant select access to foo on asdf._file_with_spaces where pay_basis = 'ANN'

And the query:

SELECT * from asdf._file_with_spaces where agency in (SELECT distinct(agency) as _file_with_spaces from asdf._file_with_spaces where agency like 'Department%' order by agency)

The result after an RLS rewrite is:

SELECT * from (
    SELECT * FROM asdf._file_with_spaces WHERE 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.