From 6c4076fac4ade864eda7f09bd9770de3c640feb0 Mon Sep 17 00:00:00 2001
From: Sergei Petrunia <sergey@mariadb.com>
Date: Mon, 21 Nov 2022 18:17:14 +0300
Subject: MDEV-30032: EXPLAIN FORMAT=JSON output: part #2: print 'loops'.

---
 mysql-test/main/join_cache.result | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'mysql-test/main/join_cache.result')

diff --git a/mysql-test/main/join_cache.result b/mysql-test/main/join_cache.result
index f5baec125e8..b5ed58e4382 100644
--- a/mysql-test/main/join_cache.result
+++ b/mysql-test/main/join_cache.result
@@ -6264,6 +6264,7 @@ EXPLAIN
           "key": "PRIMARY",
           "key_length": "4",
           "used_key_parts": ["a"],
+          "loops": 1,
           "rows": 10,
           "cost": "COST_REPLACED",
           "filtered": 100,
@@ -6280,6 +6281,7 @@ EXPLAIN
             "key": "kp1",
             "key_length": "10",
             "used_key_parts": ["kp1", "kp2"],
+            "loops": 10,
             "rows": 836,
             "cost": "COST_REPLACED",
             "filtered": 9.090909004,
-- 
cgit v1.2.1