diff options
author | gkodinov/kgeorge@magare.gmz <> | 2007-05-04 10:48:51 +0300 |
---|---|---|
committer | gkodinov/kgeorge@magare.gmz <> | 2007-05-04 10:48:51 +0300 |
commit | 6badb08ce30c7b96714e7df91b8d7cf008a7bbb9 (patch) | |
tree | 063e8080c776ed341a337770fb33a4588175b108 /mysql-test/t/heap_hash.test | |
parent | b77a85ef22f2b728d185e5e0b0e9d1d5ff5bb940 (diff) | |
download | mariadb-git-6badb08ce30c7b96714e7df91b8d7cf008a7bbb9.tar.gz |
Bug #27807.
Non-correlated scalar subqueries may get executed
in EXPLAIN at the optimization phase if they are
part of a right hand sargable expression.
If the scalar subquery uses a temp table to
materialize its results it will replace the
subquery structure from the parser with a simple
select from the materialization table.
As a result the EXPLAIN will crash as the
temporary materialization table is not to be shown
in EXPLAIN at all.
Fixed by preserving the original query structure
right after calling optimize() for scalar subqueries
with temp tables executed during EXPLAIN.
Diffstat (limited to 'mysql-test/t/heap_hash.test')
0 files changed, 0 insertions, 0 deletions