diff options
| author | unknown <timour@askmonty.org> | 2012-08-21 15:24:43 +0300 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2012-08-21 15:24:43 +0300 |
| commit | 80b3f7470536503ffe1103dda3dea3f29b7c9641 (patch) | |
| tree | 229f68dddbf924e3ec729ebd0adfb9c25b317466 /mysql-test/r/subselect_mat_cost_bugs.result | |
| parent | a45c451e4002875187a40ec17e872d3b69a3452a (diff) | |
| download | mariadb-git-80b3f7470536503ffe1103dda3dea3f29b7c9641.tar.gz | |
Fix bug mdev-447: Wrong output from the EXPLAIN command of the test case for lp bug #714999
The fix backports from MWL#182: Explain running statements the logic that
saves the original JOIN_TAB array of a query plan after optimization. This
array is later used during EXPLAIN to iterate over the original JOIN plan
nodes in the cases when this plan could be changed by early subquery
execution during the optimization phase of the outer query.
Diffstat (limited to 'mysql-test/r/subselect_mat_cost_bugs.result')
| -rw-r--r-- | mysql-test/r/subselect_mat_cost_bugs.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/subselect_mat_cost_bugs.result b/mysql-test/r/subselect_mat_cost_bugs.result index 1d03f2e9fe6..8c95c8637aa 100644 --- a/mysql-test/r/subselect_mat_cost_bugs.result +++ b/mysql-test/r/subselect_mat_cost_bugs.result @@ -148,7 +148,7 @@ FROM t2 GROUP BY f1 id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables 2 SUBQUERY t1 system NULL NULL NULL NULL 1 -3 SUBQUERY internal_tmp_table ALL group_key NULL NULL NULL 1 Using temporary; Using filesort +3 SUBQUERY t2 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort drop table t1, t2, t3; # # LP BUG#715034 Item_sum_distinct::clear(): Assertion `tree != 0' failed |