Details
-
Bug
-
Status: In Review (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Currently eliminated tables (both regular and derived) are not displayed in the
EXPLAIN/ANALYZE [FORMAT=JSON]
|
output at all. This can be confusing to the user. Those tables must be displayed in the following way:
+------+-------------+-------+------+---------------+------+---------+------+------+------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|
+------+-------------+-------+------+---------------+------+---------+------+------+------------+
|
| 1 | SIMPLE | t1 | NULL | NULL | NULL | NULL | NULL | NULL | Eliminated |
|
+------+-------------+-------+------+---------------+------+---------+------+------+------------+
|
In case of FORMAT=JSON they must be displayed like this:
{
|
"table": "t1"
|
"Eliminated": true
|
}
|
Attachments
Issue Links
- relates to
-
MDEV-26278 Table elimination does not work across derived tables
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue relates to |
| Issue Type | Task [ 3 ] | Bug [ 1 ] |
| Summary | Show eliminated tables in EXPLAIN [FORMAT=JSON] output | Eliminated tables are not shown in EXPLAIN [FORMAT=JSON] output |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Priority | Critical [ 2 ] | Major [ 3 ] |
| Assignee | Oleg Smirnov [ JIRAUSER50405 ] | Sergei Petrunia [ psergey ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Fix Version/s | 10.11 [ 27614 ] |
| Fix Version/s | 10.10 [ 27530 ] |