[MDEV-7834] ANALYZE FORMAT=JSON output column should be named ANALYZE Created: 2015-03-25  Updated: 2015-03-26  Resolved: 2015-03-26

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.1
Fix Version/s: 10.1.4

Type: Bug Priority: Major
Reporter: Sergei Petrunia Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: analyze-stmt

Issue Links:
Relates
relates to MDEV-7648 Extra data in ANALYZE FORMAT=JSON $stmt Open

 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".
Generated at Thu Feb 08 07:22:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.