Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
Attachments
Issue Links
- duplicates
-
MDEV-16 EXPLAIN the *actual* plan on a *running* statement; no progress indicators and numbers are needed
- Closed
- relates to
-
MDEV-238 SHOW EXPLAIN: Server crashes in JOIN::print_explain with FROM subquery and GROUP BY
- Closed
-
MDEV-239 SHOW 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-240 SHOW EXPLAIN: Assertion `this->optimized == 2' failed in JOIN::print_explain on query with a JOIN, TEMPTABLE view, single-row base table
- Closed
-
MDEV-267 SHOW EXPLAIN: Server crashes in JOIN::print_explain on most of queries
- Closed
-
MDEV-270 SHOW EXPLAIN: server crashes in JOIN::print_explain on a query with select tables optimized away
- Closed
-
MDEV-272 SHOW EXPLAIN: Running SHOW EXPLAIN in parallel with a query makes the query thread die
- Closed
-
MDEV-273 SHOW EXPLAIN: server crashes in JOIN::print_explain on a query with impossible WHERE
- Closed
-
MDEV-275 SHOW EXPLAIN: server crashes in JOIN::print_explain with IN subquery and aggregate function
- Closed
-
MDEV-297 SHOW EXPLAIN: Server gets stuck until timeout occurs while executing SHOW INDEX and SHOW EXPLAIN in parallel
- Closed
-
MDEV-298 SHOW EXPLAIN: Plan returned by SHOW EXPLAIN only contains 'Using temporary' while the standard EXPLAIN says 'Using temporary; Using filesort'
- Closed
-
MDEV-299 SHOW 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-300 SHOW EXPLAIN: select_type returned by SHOW EXPLAIN is different from the normal EXPLAIN (SIMPLE vs PRIMARY)
- Closed
-
MDEV-301 SHOW EXPLAIN: Server crashes while trying to destroy a mutex LOCK_apc_queue that was locked or to lock unitialized mutex
- Closed
-
MDEV-305 SHOW EXPLAIN: ref returned by SHOW EXPLAIN is different from the normal EXPLAIN ('const' vs empty string)
- Closed
-
MDEV-323 SHOW EXPLAIN: Plan produced by SHOW EXPLAIN loses 'UNION RESULT' line on the way without saying that the plan was already deleted
- Closed
-
MDEV-324 SHOW 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-325 SHOW 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-326 EXPLAIN+ORDER BY: Different plans produced by SHOW EXPLAIN and EXPLAIN
- Closed
-
MDEV-327 SHOW EXPLAIN: Different select_type in plans produced by SHOW EXPLAIN and standard EXPLAIN: 'SUBQUERY' vs 'DEPENDENT SUBQUERY'
- Closed
-
MDEV-328 SHOW EXPLAIN: Plan produced by regular explain says 'Using index condition', but SHOW EXPLAIN does not
- Closed
-
MDEV-408 SHOW EXPLAIN: Some values are chopped off in SHOW EXPLAIN output
- Closed
-
MDEV-410 EXPLAIN shows type=range, while SHOW EXPLAIN and userstat show full table scan is used
- Closed
-
MDEV-411 SHOW 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-412 SHOW EXPLAIN: Server crashes in JOIN::print_explain on a query with inner join and ORDER BY the same column twice
- Closed
-
MDEV-423 SHOW EXPLAIN: 'Using where' for a subquery is shown in EXPLAIN, but not in SHOW EXPLAIN output
- Closed
-
MDEV-428 Select type DEPENDENT SUBQUERY in SHOW EXPLAIN vs SUBQUERY in EXPLAIN
- Closed
-
MDEV-429 Extra field 'Using filesort' in EXPLAIN vs 'Using where; Using filesort' in SHOW EXPLAIN on a query with HAVING and ORDER BY
- Closed
-
MDEV-462 SHOW EXPLAIN: Assertion `table_list->table' fails in find_field_in_table_ref if FOR contains a non-numeric value
- Closed