[MDEV-28869] Eliminated tables are not shown in EXPLAIN [FORMAT=JSON] output - Jira

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

relates to

MDEV-26278 Table elimination does not work across derived tables

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server