Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
https://github.com/mariadb/server/commit/73df7a30094a0fac8f59de1c91a7bce6cd3ff643 (pushed into 11.4) has cleaned up EXPLAIN FORMAT=JSON output, including wrapping tables in "nested_loop":
--- a/mysql-test/main/analyze_format_json.result
|
+++ b/mysql-test/main/analyze_format_json.result
|
@@ -9,18 +9,22 @@ ANALYZE
|
"select_id": 1,
|
"r_loops": 1,
|
"r_total_time_ms": "REPLACED",
|
- "table": {
|
- "table_name": "t0",
|
- "access_type": "ALL",
|
- "r_loops": 1,
|
- "rows": 10,
|
- "r_rows": 10,
|
- "r_table_time_ms": "REPLACED",
|
- "r_other_time_ms": "REPLACED",
|
- "filtered": 100,
|
- "r_filtered": 30,
|
- "attached_condition": "t0.a < 3"
|
- }
|
+ "nested_loop": [
|
+ {
|
+ "table": {
|
+ "table_name": "t0",
|
+ "access_type": "ALL",
|
+ "r_loops": 1,
|
+ "rows": 10,
|
+ "r_rows": 10,
|
+ "r_table_time_ms": "REPLACED",
|
+ "r_other_time_ms": "REPLACED",
|
+ "filtered": 100,
|
+ "r_filtered": 30,
|
+ "attached_condition": "t0.a < 3"
|
+ }
|
+ }
|
+ ]
|
} |
This has made diffs between old EXPLAIN outputs and new EXPLAIN outputs meaningless.
This task is about creating a script to convert from the "old" format to "new" format.\
Attachments
Issue Links
- links to
