MDEV-16EXPLAIN the *actual* plan on a *running* statement; no progress indicators and numbers are needed
Closed
relates to
MDEV-238SHOW EXPLAIN: Server crashes in JOIN::print_explain with FROM subquery and GROUP BY
Closed
MDEV-239SHOW EXPLAIN: Assertion `field_types == 0 || field_types[field_pos] == MYSQL_TYPE_DOUBLE' failed in Protocol_text::store(double, uint32, String*) with SHOW EXPLAIN over EXPLAIN EXTENDED
Closed
MDEV-240SHOW EXPLAIN: Assertion `this->optimized == 2' failed in JOIN::print_explain on query with a JOIN, TEMPTABLE view, single-row base table
Closed
MDEV-267SHOW EXPLAIN: Server crashes in JOIN::print_explain on most of queries
Closed
MDEV-270SHOW EXPLAIN: server crashes in JOIN::print_explain on a query with select tables optimized away
Closed
MDEV-272SHOW EXPLAIN: Running SHOW EXPLAIN in parallel with a query makes the query thread die
Closed
MDEV-273SHOW EXPLAIN: server crashes in JOIN::print_explain on a query with impossible WHERE
Closed
MDEV-275SHOW EXPLAIN: server crashes in JOIN::print_explain with IN subquery and aggregate function
Closed
MDEV-297SHOW EXPLAIN: Server gets stuck until timeout occurs while executing SHOW INDEX and SHOW EXPLAIN in parallel
Closed
MDEV-298SHOW EXPLAIN: Plan returned by SHOW EXPLAIN only contains 'Using temporary' while the standard EXPLAIN says 'Using temporary; Using filesort'
Closed
MDEV-299SHOW EXPLAIN: Plan produced by SHOW EXPLAIN changes back and forth during query execution (type=range vs ALL, possible_keys, key, key_len, rows also differ)
Closed
MDEV-300SHOW EXPLAIN: select_type returned by SHOW EXPLAIN is different from the normal EXPLAIN (SIMPLE vs PRIMARY)
Closed
MDEV-301SHOW EXPLAIN: Server crashes while trying to destroy a mutex LOCK_apc_queue that was locked or to lock unitialized mutex
Closed
MDEV-305SHOW EXPLAIN: ref returned by SHOW EXPLAIN is different from the normal EXPLAIN ('const' vs empty string)
Closed
MDEV-323SHOW EXPLAIN: Plan produced by SHOW EXPLAIN loses 'UNION RESULT' line on the way without saying that the plan was already deleted
Closed
MDEV-324SHOW EXPLAIN: Plan produced by SHOW EXPLAIN for a query with TEMPTABLE view loses 'DERIVED' line on the way without saying that the plan was already deleted
Closed
MDEV-325SHOW EXPLAIN: Plan produced by SHOW EXPLAIN is different from standard EXPLAIN: type ALL vs 'index_merge', keys is different, 'Using sort_union(a,b);' is missing
Closed
MDEV-326EXPLAIN+ORDER BY: Different plans produced by SHOW EXPLAIN and EXPLAIN
Closed
MDEV-327SHOW EXPLAIN: Different select_type in plans produced by SHOW EXPLAIN and standard EXPLAIN: 'SUBQUERY' vs 'DEPENDENT SUBQUERY'
Closed
MDEV-328SHOW EXPLAIN: Plan produced by regular explain says 'Using index condition', but SHOW EXPLAIN does not
Closed
MDEV-408SHOW EXPLAIN: Some values are chopped off in SHOW EXPLAIN output
Closed
MDEV-410EXPLAIN shows type=range, while SHOW EXPLAIN and userstat show full table scan is used
Closed
MDEV-411SHOW EXPLAIN: For dependent subquery EXPLAIN produces type=index, key, 'Using where; Using index', while SHOW EXPLAIN says type=ALL, no key, 'Range checked for each record'
Closed
MDEV-412SHOW EXPLAIN: Server crashes in JOIN::print_explain on a query with inner join and ORDER BY the same column twice
Closed
MDEV-423SHOW EXPLAIN: 'Using where' for a subquery is shown in EXPLAIN, but not in SHOW EXPLAIN output
Closed
MDEV-428Select type DEPENDENT SUBQUERY in SHOW EXPLAIN vs SUBQUERY in EXPLAIN
Closed
MDEV-429Extra field 'Using filesort' in EXPLAIN vs 'Using where; Using filesort' in SHOW EXPLAIN on a query with HAVING and ORDER BY
Closed
MDEV-462SHOW EXPLAIN: Assertion `table_list->table' fails in find_field_in_table_ref if FOR contains a non-numeric value