diff options
| author | Igor Babaev <igor@askmonty.org> | 2019-08-30 15:49:07 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2019-08-30 15:49:07 -0700 |
| commit | d1490c177139faa71cd88af71fdb7d88a8f45000 (patch) | |
| tree | 86086ac8d6816708919e258d10350fb5d4e4bf04 /sql/sql_select.h | |
| parent | 7060b0320d1479bb9476e0cbd4acc584e059e1ff (diff) | |
| download | mariadb-git-10.3-mdev15777.tar.gz | |
MDEV-15777 Use inferred IS NOT NULL predicates in the range optimizer10.3-mdev15777
This patch introduces the optimization that allows range optimizer to
consider index range scans that are built employing NOT NULL predicates
inferred from WHERE conditions and ON expressions.
The patch adds a new optimizer switch not_null_range_scan.
Diffstat (limited to 'sql/sql_select.h')
| -rw-r--r-- | sql/sql_select.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/sql_select.h b/sql/sql_select.h index dd823a7d7df..2b40a414d57 100644 --- a/sql/sql_select.h +++ b/sql/sql_select.h @@ -1749,6 +1749,7 @@ public: void add_keyuses_for_splitting(); bool inject_best_splitting_cond(table_map remaining_tables); bool fix_all_splittings_in_plan(); + void make_notnull_conds_for_range_scans(); bool transform_in_predicates_into_in_subq(THD *thd); private: @@ -2343,7 +2344,7 @@ Item_equal *find_item_equal(COND_EQUAL *cond_equal, Field *field, extern bool test_if_ref(Item *, Item_field *left_item,Item *right_item); -inline bool optimizer_flag(THD *thd, uint flag) +inline bool optimizer_flag(THD *thd, ulonglong flag) { return (thd->variables.optimizer_switch & flag); } |