diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2021-03-19 17:32:08 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2021-03-19 17:37:38 +0300 |
| commit | b9a45ba40fbf251f5635ecebad6ea7414be39d41 (patch) | |
| tree | 465a1936ddced015b9a3f327a0e27b792e16f929 /mysql-test/main/opt_trace_index_merge.result | |
| parent | 00528a04457d33210baceba1a79e82ea126b48bd (diff) | |
| download | mariadb-git-b9a45ba40fbf251f5635ecebad6ea7414be39d41.tar.gz | |
MDEV-23645: Optimizer trace: print conditions after substitute_for_best_equal_field
Print the conditions for WHERE, HAVING, and ON.
Diffstat (limited to 'mysql-test/main/opt_trace_index_merge.result')
| -rw-r--r-- | mysql-test/main/opt_trace_index_merge.result | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/mysql-test/main/opt_trace_index_merge.result b/mysql-test/main/opt_trace_index_merge.result index 3b79a7a44e8..f1e13586eda 100644 --- a/mysql-test/main/opt_trace_index_merge.result +++ b/mysql-test/main/opt_trace_index_merge.result @@ -230,8 +230,13 @@ explain select * from t1 where a=1 or b=1 { "best_join_order": ["t1"] }, { + "substitute_best_equal": { + "condition": "WHERE", + "resulting_condition": "t1.a = 1 or t1.b = 1" + } + }, + { "attaching_conditions_to_tables": { - "original_condition": "t1.a = 1 or t1.b = 1", "attached_conditions_computation": [], "attached_conditions_summary": [ { |