[Bug] SupportsFilterPushDown produces incorrect results when merging the result sets of different filter conditions on the same table

[MaoMiMao]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Version

all

What's Wrong?

After running different filter conditions separately on the same table and merging the two results with UNION ALL, a concatenation error occurred when applying the filterdown condition.

Exmaple:

Generated filtered sql

What You Expected?

operating normally

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• [X] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct