• Sergei Petrunia's avatar
    MDEV-406: ANALYZE $stmt: get ANALYZE work for subqueries · c08de062
    Sergei Petrunia authored
    - "ANALYZE $stmt" should discard select's output, but it should still
      evaluate the output columns (otherwise, subqueries in select list
      are not executed)
    - SHOW EXPLAIN's code practice of calling JOIN::save_explain_data()
      after JOIN::exec() is disastrous for ANALYZE, because it resets
      all counters after the first execution. It is stopped
      = "Late" test_if_skip_sort_order() calls explicitly update their part
        of the query plan.
      = Also, I had to rewrite I_S optimization to actually have optimization
        and execution stages.
    c08de062
show_explain.result 44.3 KB