diff options
author | Gleb Shchepa <gshchepa@mysql.com> | 2009-05-13 12:51:39 +0500 |
---|---|---|
committer | Gleb Shchepa <gshchepa@mysql.com> | 2009-05-13 12:51:39 +0500 |
commit | fbb96b339ae5fcce19446fd27a2fb75e49b960f8 (patch) | |
tree | f5fa0d7730c8cfc2b04e482e9032f07c8703e842 /win | |
parent | 230f3f5208cadaafdc4b1141be01c65b493b919a (diff) | |
download | mariadb-git-fbb96b339ae5fcce19446fd27a2fb75e49b960f8.tar.gz |
Bug #44290: explain crashes for subquery with distinct in
SQL_SELECT::test_quick_select
The crash was caused by an incomplete cleanup of JOIN_TAB::select
during the filesort of rows for GROUP BY clause inside a subquery.
Queries where a quick index access is replaced with filesort was
was affected. For example:
SELECT 1 FROM
(SELECT COUNT(DISTINCT c1) FROM t1
WHERE c2 IN (1, 1) AND c3 = 2 GROUP BY c2) x
Quick index access related data in the SQL_SELECT::test_quick_select
function was inconsistent after an incomplete cleanup.
This function has been completed to prevent crashes in the
SQL_SELECT::test_quick_select function.
Diffstat (limited to 'win')
0 files changed, 0 insertions, 0 deletions