diff options
| author | Sergei Petrunia <sergey@mariadb.com> | 2022-11-21 18:17:14 +0300 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2023-02-03 11:22:17 +0300 |
| commit | 6c4076fac4ade864eda7f09bd9770de3c640feb0 (patch) | |
| tree | b89d6af0ac8f26c9d96cbf14654023d9f7da7429 /mysql-test/suite/federated | |
| parent | ffe0beca2557a31758f50fa53ceb9948b6cd6248 (diff) | |
| download | mariadb-git-6c4076fac4ade864eda7f09bd9770de3c640feb0.tar.gz | |
MDEV-30032: EXPLAIN FORMAT=JSON output: part #2: print 'loops'.
Diffstat (limited to 'mysql-test/suite/federated')
| -rw-r--r-- | mysql-test/suite/federated/federatedx_create_handlers.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/federatedx_create_handlers.result b/mysql-test/suite/federated/federatedx_create_handlers.result index 92436e1ac64..59ca0bb2fec 100644 --- a/mysql-test/suite/federated/federatedx_create_handlers.result +++ b/mysql-test/suite/federated/federatedx_create_handlers.result @@ -166,6 +166,7 @@ EXPLAIN "table": { "table_name": "t3", "access_type": "ALL", + "loops": 1, "rows": 7, "cost": "COST_REPLACED", "filtered": 100 @@ -180,6 +181,7 @@ EXPLAIN "key_length": "18", "used_key_parts": ["name"], "ref": ["federated.t3.name"], + "loops": 7, "rows": 2, "cost": "COST_REPLACED", "filtered": 100, @@ -242,6 +244,7 @@ ANALYZE "table": { "table_name": "t3", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 7, "r_rows": 7, @@ -261,6 +264,7 @@ ANALYZE "key_length": "18", "used_key_parts": ["name"], "ref": ["federated.t3.name"], + "loops": 7, "r_loops": 7, "rows": 2, "r_rows": 0, @@ -376,6 +380,7 @@ EXPLAIN "table": { "table_name": "t5", "access_type": "ALL", + "loops": 1, "rows": 2, "cost": "COST_REPLACED", "filtered": 100 @@ -386,6 +391,7 @@ EXPLAIN "table": { "table_name": "<derived2>", "access_type": "ALL", + "loops": 2, "rows": 5, "cost": "COST_REPLACED", "filtered": 100 |