• unknown's avatar
    Bug #36011: server crash with explain extended on query · 0fb1527e
    unknown authored
       with dependent subqueries
    An IN subquery is executed on EXPLAIN when it's not correlated.
    If the subquery required a temporary table for its execution
    not all the internal structures were restored from pointing to
    the items of the temporary table to point back to the items of
    the subquery.
    Fixed by restoring the ref array when a temp tables were used in
    executing the IN subquery during EXPLAIN EXTENDED.
    
    
    mysql-test/r/subselect.result:
      Bug #36011: test case
    mysql-test/t/subselect.test:
      Bug #36011: test case
    sql/sql_select.cc:
      Bug #36011: restore the ref array after execution 
      when there were temp tables.
    0fb1527e
subselect.result 154 KB