the predicate order of Filter will make it impossible to push down to Join.

[KKould]

Bug Report

Columns from different tables should be divided as much as possible on both sides so that they can be pushed down normally under the Join.