If there is a condition that depends only on the second table in a blocked join,
the following blocked join algorithms (BNL, BNLH) use this condition to pre-filter records from this table prior to joining the records.

Currently the optimizer extracts such a single table condition independently from the generic condition pushdown. As a result the same condition may be evaluated up to two times more. This is a problem if the condition is expensive. It also makes it problematic to move the condition to an optimal partial join (see MDEV-83).