Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL)
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
- relates to
-
MDEV-7648 Extra data in ANALYZE FORMAT=JSON $stmt
-
- Open
-
Activity
| Assignee | Oleksandr Byelkin [ sanja ] |
| Labels | analyze-stmt |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Sergei Petrunia [ psergey ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Sergei Petrunia [ psergey ] | Oleksandr Byelkin [ sanja ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Fix Version/s | 10.1.4 [ 18400 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v2 [ 60223 ] | MariaDB v3 [ 65331 ] |
| Workflow | MariaDB v3 [ 65331 ] | MariaDB v4 [ 148937 ] |