diff options
| author | Monty <monty@mariadb.org> | 2020-03-04 19:52:19 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2020-03-27 03:54:45 +0200 |
| commit | b3ab3105fdb34dae6c2d4270751bc0694c3d9df8 (patch) | |
| tree | 79abb79d00874c2ece6182b5c2bff55458312ffc /mysql-test/main/opt_trace_index_merge_innodb.result | |
| parent | f36ca142f7fa59598e34e842b60372b963067766 (diff) | |
| download | mariadb-git-b3ab3105fdb34dae6c2d4270751bc0694c3d9df8.tar.gz | |
Removed double calls to records_in_range from distinct and group by
Fixed by moving testing of get_best_group_min_max() after range testing.
Diffstat (limited to 'mysql-test/main/opt_trace_index_merge_innodb.result')
| -rw-r--r-- | mysql-test/main/opt_trace_index_merge_innodb.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/opt_trace_index_merge_innodb.result b/mysql-test/main/opt_trace_index_merge_innodb.result index 4b047315bf5..b90c7098ac9 100644 --- a/mysql-test/main/opt_trace_index_merge_innodb.result +++ b/mysql-test/main/opt_trace_index_merge_innodb.result @@ -108,10 +108,6 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { } ], "setup_range_conditions": [], - "group_index_range": { - "chosen": false, - "cause": "no group by or distinct" - }, "analyzing_range_alternatives": { "range_scan_alternatives": [ { @@ -158,6 +154,10 @@ explain select * from t1 where pk1 != 0 and key1 = 1 { }, "analyzing_index_merge_union": [] }, + "group_index_range": { + "chosen": false, + "cause": "no group by or distinct" + }, "chosen_range_access_summary": { "range_access_plan": { "type": "range_scan", |