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
-