diff options
author | Varun Gupta <varun.gupta@mariadb.com> | 2019-04-30 21:05:50 +0530 |
---|---|---|
committer | Varun Gupta <varun.gupta@mariadb.com> | 2019-04-30 21:07:25 +0530 |
commit | cb9fa1a08bd1f4f609324971e58b9b300a5cb55f (patch) | |
tree | a4fee4824c848da56de5e8c68189550e36be860e /mysql-test/main/subselect_extra_no_semijoin.result | |
parent | 8c8bee0a5635d7f8197a148f267c04c1452b47fc (diff) | |
download | mariadb-git-cb9fa1a08bd1f4f609324971e58b9b300a5cb55f.tar.gz |
MDEV-9959: A serious MariaDB server performance bug
If a derived table has SELECT DISTINCT, provide index statistics for it so that the join optimizer in the
upper select knows that ref access to the table will produce one row.
Diffstat (limited to 'mysql-test/main/subselect_extra_no_semijoin.result')
-rw-r--r-- | mysql-test/main/subselect_extra_no_semijoin.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/subselect_extra_no_semijoin.result b/mysql-test/main/subselect_extra_no_semijoin.result index ec9ddb0452e..49a1431eb9b 100644 --- a/mysql-test/main/subselect_extra_no_semijoin.result +++ b/mysql-test/main/subselect_extra_no_semijoin.result @@ -411,7 +411,7 @@ EXPLAIN SELECT a FROM t1 WHERE (a,b) IN (SELECT * FROM v2); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using where -2 DEPENDENT SUBQUERY <derived3> index_subquery key0 key0 10 func,func 2 Using where +2 DEPENDENT SUBQUERY <derived3> index_subquery key0 key0 10 func,func 1 Using where 3 DERIVED t2 ALL NULL NULL NULL NULL 6 4 UNION t3 ALL NULL NULL NULL NULL 4 NULL UNION RESULT <union3,4> ALL NULL NULL NULL NULL NULL |