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/main/intersect_all.result | |
| parent | ffe0beca2557a31758f50fa53ceb9948b6cd6248 (diff) | |
| download | mariadb-git-6c4076fac4ade864eda7f09bd9770de3c640feb0.tar.gz | |
MDEV-30032: EXPLAIN FORMAT=JSON output: part #2: print 'loops'.
Diffstat (limited to 'mysql-test/main/intersect_all.result')
| -rw-r--r-- | mysql-test/main/intersect_all.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/intersect_all.result b/mysql-test/main/intersect_all.result index 7b5bc2c2b95..8f826a193aa 100644 --- a/mysql-test/main/intersect_all.result +++ b/mysql-test/main/intersect_all.result @@ -69,6 +69,7 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 4, "cost": "COST_REPLACED", "filtered": 100 @@ -87,6 +88,7 @@ EXPLAIN "table": { "table_name": "t2", "access_type": "ALL", + "loops": 1, "rows": 4, "cost": "COST_REPLACED", "filtered": 100 @@ -105,6 +107,7 @@ EXPLAIN "table": { "table_name": "t3", "access_type": "ALL", + "loops": 1, "rows": 4, "cost": "COST_REPLACED", "filtered": 100 @@ -141,6 +144,7 @@ ANALYZE "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 4, "r_rows": 4, @@ -166,6 +170,7 @@ ANALYZE "table": { "table_name": "t2", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 4, "r_rows": 4, @@ -191,6 +196,7 @@ ANALYZE "table": { "table_name": "t3", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 4, "r_rows": 4, @@ -224,6 +230,7 @@ ANALYZE "table": { "table_name": "<derived2>", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 4, "r_rows": 2, @@ -251,6 +258,7 @@ ANALYZE "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 4, "r_rows": 4, @@ -276,6 +284,7 @@ ANALYZE "table": { "table_name": "t2", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 4, "r_rows": 4, @@ -301,6 +310,7 @@ ANALYZE "table": { "table_name": "t3", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 4, "r_rows": 4, @@ -403,6 +413,7 @@ EXPLAIN "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "rows": 6, "cost": "COST_REPLACED", "filtered": 100 @@ -421,6 +432,7 @@ EXPLAIN "table": { "table_name": "t3", "access_type": "ALL", + "loops": 1, "rows": 5, "cost": "COST_REPLACED", "filtered": 100 @@ -431,6 +443,7 @@ EXPLAIN "table": { "table_name": "t2", "access_type": "ALL", + "loops": 5, "rows": 7, "cost": "COST_REPLACED", "filtered": 100 @@ -471,6 +484,7 @@ ANALYZE "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 6, "r_rows": 6, @@ -496,6 +510,7 @@ ANALYZE "table": { "table_name": "t3", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 5, "r_rows": 5, @@ -511,6 +526,7 @@ ANALYZE "table": { "table_name": "t2", "access_type": "ALL", + "loops": 5, "r_loops": 1, "rows": 7, "r_rows": 7, @@ -550,6 +566,7 @@ ANALYZE "table": { "table_name": "<derived2>", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 6, "r_rows": 3, @@ -577,6 +594,7 @@ ANALYZE "table": { "table_name": "t1", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 6, "r_rows": 6, @@ -602,6 +620,7 @@ ANALYZE "table": { "table_name": "t3", "access_type": "ALL", + "loops": 1, "r_loops": 1, "rows": 5, "r_rows": 5, @@ -617,6 +636,7 @@ ANALYZE "table": { "table_name": "t2", "access_type": "ALL", + "loops": 5, "r_loops": 1, "rows": 7, "r_rows": 7, |