diff options
| author | Sergei Petrunia <sergey@mariadb.com> | 2023-01-31 20:11:17 +0300 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2023-01-31 20:11:17 +0300 |
| commit | 82d5977b9fd6be5f5152d6831cd744fc739a2f24 (patch) | |
| tree | 592d4099b81d90ad28b70aedf1144639e96e45c7 | |
| parent | 47a40d90627dcf3c870cecd33c345c2e224986af (diff) | |
| download | mariadb-git-10.4-mdev30218-print-negative-gain.tar.gz | |
Debug patch: print filter_gain if it is less than 0.10.4-mdev30218-print-negative-gain
| -rw-r--r-- | sql/sql_select.cc | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/sql_select.cc b/sql/sql_select.cc index 350d43ff24d..76d51bda6ef 100644 --- a/sql/sql_select.cc +++ b/sql/sql_select.cc @@ -7968,6 +7968,13 @@ best_access_path(JOIN *join, if (filter) { tmp-= filter->get_adjusted_gain(rows) - filter->get_cmp_gain(rows); + double filter_gain= + filter->get_adjusted_gain(rows) - filter->get_cmp_gain(rows); + if (filter_gain < 0) + { + fprintf(stderr, "filter_gain:%g, query=%s\n", filter_gain, + thd->query()); + } DBUG_ASSERT(tmp >= 0); trace_access_idx.add("rowid_filter_key", s->table->key_info[filter->key_no].name); |