Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7834

ANALYZE FORMAT=JSON output column should be named ANALYZE

Details

    Description

      MariaDB [test]>  create table t10 (a int);
      Query OK, 0 rows affected (0.32 sec)
       
      MariaDB [test]> analyze format=json select * from t10\G
      *************************** 1. row ***************************
      EXPLAIN: {
        "query_block": {
          "select_id": 1,
          "r_loops": 1,
          "r_total_time_ms": 0.4534,
          "table": {
            "table_name": "t10",
            "access_type": "ALL",
            "r_loops": 1,
            "rows": 1,
            "r_rows": 0,
            "r_total_time_ms": 0.1,
            "filtered": 100,
            "r_filtered": 100
          }
        }
      }

      Note that the column is named "EXPLAIN". It should be "ANALYZE".

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              sanja Oleksandr Byelkin
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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