Remove duplicated conditions pushed both to join_tab->select_cond and join_tab->cache_select->cond for blocked joins.

Description

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).

Assignee

Timour Katchaounov

Reporter

Timour Katchaounov

Labels

None

Time tracking

16h

Fix versions

Due date

2013/10/15

Priority

Major
Configure