Do dynamic filters (e.g. from SortExec) work with recursive queries?

We're not sure they ever worked correctly, but it's possible https://github.com/apache/datafusion/pull/17028 broke them entirely. We should confirm. I have not however been able to come up with a reasonable example, recursive queries are not something I use often enough to have a good intuition for. See https://github.com/apache/datafusion/pull/17028 for discussion.

Start by reading the discussion in pull request 17028 and trace how dynamic filters from SortExec are handled during recursive queries. Create a reasonable recursive-query example to determine whether the filters work correctly; done means the behavior is confirmed and covered by an appropriate regression test.

Written by the indexing model from the issue text.