MDEV-27036: resolve duplicated key issues of JSON tracing outputs:

MDEV-27036: repeated "table" key resolve for print_explain_json

MDEV-27036: duplicated keys in best_access_path

MDEV-27036: Explain_aggr_filesort::print_json_members: resolve duplicated "filesort" member in Json object

MDEV-27036: Explain_basic_join::
            print_explain_json_interns fixed start_dups_weedout case for main.explain_json test

1 files changed, 35 insertions, 29 deletions

diff --git a/mysql-test/main/join_cache.result b/mysql-test/main/join_cache.result
index 0fbb73f56fe..36e045dc2bd 100644
--- a/mysql-test/main/join_cache.result
+++ b/mysql-test/main/join_cache.result
@@ -6195,36 +6195,42 @@ EXPLAIN
 {
   "query_block": {
     "select_id": 1,
-    "table": {
-      "table_name": "a",
-      "access_type": "range",
-      "possible_keys": ["PRIMARY"],
-      "key": "PRIMARY",
-      "key_length": "4",
-      "used_key_parts": ["a"],
-      "rows": 10,
-      "filtered": 100,
-      "attached_condition": "a.a <= 10",
-      "using_index": true
-    },
-    "block-nl-join": {
-      "table": {
-        "table_name": "b",
-        "access_type": "range",
-        "possible_keys": ["kp1"],
-        "key": "kp1",
-        "key_length": "10",
-        "used_key_parts": ["kp1", "kp2"],
-        "rows": 836,
-        "filtered": 76.43428802,
-        "index_condition": "b.kp2 <= 10",
-        "attached_condition": "b.kp2 <= 10 and b.col1 + 1 < 33333"
+    "nested_loop": [
+      {
+        "table": {
+          "table_name": "a",
+          "access_type": "range",
+          "possible_keys": ["PRIMARY"],
+          "key": "PRIMARY",
+          "key_length": "4",
+          "used_key_parts": ["a"],
+          "rows": 10,
+          "filtered": 100,
+          "attached_condition": "a.a <= 10",
+          "using_index": true
+        }
       },
-      "buffer_type": "flat",
-      "buffer_size": "54",
-      "join_type": "BNL",
-      "attached_condition": "b.kp1 = a.a"
-    }
+      {
+        "block-nl-join": {
+          "table": {
+            "table_name": "b",
+            "access_type": "range",
+            "possible_keys": ["kp1"],
+            "key": "kp1",
+            "key_length": "10",
+            "used_key_parts": ["kp1", "kp2"],
+            "rows": 836,
+            "filtered": 76.43428802,
+            "index_condition": "b.kp2 <= 10",
+            "attached_condition": "b.kp2 <= 10 and b.col1 + 1 < 33333"
+          },
+          "buffer_type": "flat",
+          "buffer_size": "54",
+          "join_type": "BNL",
+          "attached_condition": "b.kp1 = a.a"
+        }
+      }
+    ]
   }
 }
 drop table t1,t2,t3;