diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2018-10-23 11:23:34 +0200 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2018-11-05 21:10:15 +0300 |
| commit | 3b6d90385230be911e15b9aa93a76e26367bc4bc (patch) | |
| tree | 8f026a81896a47847a727062fcbc0e598ba22ba6 /sql/sql_select.h | |
| parent | 03680a9b4fda9fa15675e137d46521628553c0eb (diff) | |
| download | mariadb-git-3b6d90385230be911e15b9aa93a76e26367bc4bc.tar.gz | |
MDEV-17493: Partition pruning doesn't work for nested outer joins
Reuse the fix for MDEV-17518 here, too.
Diffstat (limited to 'sql/sql_select.h')
| -rw-r--r-- | sql/sql_select.h | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/sql/sql_select.h b/sql/sql_select.h index 2cc47f6ec3b..0e486c1fbec 100644 --- a/sql/sql_select.h +++ b/sql/sql_select.h @@ -263,8 +263,12 @@ typedef struct st_join_table { /* Pointer to the associated ON expression. on_expr_ref=!NULL except for degenerate joins. - *on_expr_ref!=NULL for tables that are first inner tables within an outer - join. + + Optimization phase: *on_expr_ref!=NULL for tables that are the single + tables on the inner side of the outer join (t1 LEFT JOIN t2 ON...) + + Execution phase: *on_expr_ref!=NULL for tables that are first inner tables + within an outer join (which may have multiple tables) */ Item **on_expr_ref; COND_EQUAL *cond_equal; /**< multiple equalities for the on expression */ |