• Igor Babaev's avatar
    MDEV-24936 EXPLAIN for query based on table value constructor lacks info · a5b18613
    Igor Babaev authored
               on used subqueries
    
    If a query was based on a table value constructor that contained subqueries
    then EXPLAIN for such query did not contain any lines explaining the
    execution plans of the subqueries.
    This happened because
    - no optimize() method was called for any subquery used by the table value
      constructor when EXPLAIN command for the query was processed;
    - EXPLAIN node created for the table value constructor itself did not
      assume that some child nodes could be attached to it.
    
    Approved by Oleksandr Byelkin <sanja@mariadb.com>
    a5b18613
table_value_constr.test 24.9 KB