If you run only the nested query it fails because the field does not exist for table_b If you run all the query, it returns all the records of table_a
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных