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

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

                Dates

                Created:
                Updated:
                Resolved: