diff options
author | Sergey Petrunya <psergey@askmonty.org> | 2012-07-25 20:41:48 +0400 |
---|---|---|
committer | Sergey Petrunya <psergey@askmonty.org> | 2012-07-25 20:41:48 +0400 |
commit | 55597a48698b267b966873727b079cd3ac0d1c18 (patch) | |
tree | 5869ad91600e4fa8a3ba8ee95edac27d93cc3499 /mysql-test/r/subselect_mat_cost_bugs.result | |
parent | a742d49c902b97ea8a6e20368a16bb47d71b3b57 (diff) | |
download | mariadb-git-55597a48698b267b966873727b079cd3ac0d1c18.tar.gz |
MDEV-410: EXPLAIN shows type=range, while SHOW EXPLAIN and userstat show full table scan is used
- Make Item_subselect::fix_fields() ignore UNCACHEABLE_EXPLAIN flag when deciding whether
the subquery item should be marked as constant.
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 5a38fe7ca72..1d03f2e9fe6 100644 --- a/mysql-test/r/subselect_mat_cost_bugs.result +++ b/mysql-test/r/subselect_mat_cost_bugs.result @@ -162,7 +162,7 @@ EXPLAIN SELECT * FROM (SELECT * FROM t2) AS a2 WHERE (SELECT distinct SUM(distinct f3 ) FROM t1); 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 +1 PRIMARY <derived2> system NULL NULL NULL NULL 0 const row not found 3 SUBQUERY t1 index NULL f3 5 NULL 2 Using index 2 DERIVED NULL NULL NULL NULL NULL NULL NULL no matching row in const table insert into t2 values (1),(2); |