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

ANALYZE FORMAT=JSON output column should be named ANALYZE

    XMLWordPrintable

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

            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.