diff options
| author | Sergei Petrunia <sergey@mariadb.com> | 2022-11-19 21:00:23 +0300 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2023-02-03 11:01:24 +0300 |
| commit | ffe0beca2557a31758f50fa53ceb9948b6cd6248 (patch) | |
| tree | c1ed3bb3a4190a2fc0a331dee0bd428cea564a30 /mysql-test/suite/json | |
| parent | 657868f5e726e0a5e78d879e4ae50f1d3b5a8d71 (diff) | |
| download | mariadb-git-ffe0beca2557a31758f50fa53ceb9948b6cd6248.tar.gz | |
MDEV-30032: EXPLAIN FORMAT=JSON output: print costs
Basic printout for join and table execution costs.
Diffstat (limited to 'mysql-test/suite/json')
| -rw-r--r-- | mysql-test/suite/json/r/json_table.result | 2 | ||||
| -rw-r--r-- | mysql-test/suite/json/r/json_table_mysql.result | 2 | ||||
| -rw-r--r-- | mysql-test/suite/json/t/json_table.test | 1 | ||||
| -rw-r--r-- | mysql-test/suite/json/t/json_table_mysql.test | 1 |
4 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/suite/json/r/json_table.result b/mysql-test/suite/json/r/json_table.result index 44957352865..3eefaa72c1d 100644 --- a/mysql-test/suite/json/r/json_table.result +++ b/mysql-test/suite/json/r/json_table.result @@ -211,12 +211,14 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { "table_name": "tt", "access_type": "ALL", "rows": 40, + "cost": "COST_REPLACED", "filtered": 100, "table_function": "json_table" } diff --git a/mysql-test/suite/json/r/json_table_mysql.result b/mysql-test/suite/json/r/json_table_mysql.result index cdca41b3a24..44ca370f01f 100644 --- a/mysql-test/suite/json/r/json_table_mysql.result +++ b/mysql-test/suite/json/r/json_table_mysql.result @@ -189,12 +189,14 @@ EXPLAIN { "query_block": { "select_id": 1, + "cost": "COST_REPLACED", "nested_loop": [ { "table": { "table_name": "tt", "access_type": "ALL", "rows": 40, + "cost": "COST_REPLACED", "filtered": 100, "table_function": "json_table" } diff --git a/mysql-test/suite/json/t/json_table.test b/mysql-test/suite/json/t/json_table.test index 492be2d48bf..982922ff595 100644 --- a/mysql-test/suite/json/t/json_table.test +++ b/mysql-test/suite/json/t/json_table.test @@ -145,6 +145,7 @@ create view v2 as select * from json_table('[{"co\\\\lor": "blue", "price": 50 select * from v2; drop view v2; +--source include/explain-no-costs.inc explain format=json select * from json_table('[{"a": 1, "b": [11,111]}, {"a": 2, "b": [22,222]}]', '$[*]' COLUMNS( a INT PATH '$.a')) as tt; explain select * from diff --git a/mysql-test/suite/json/t/json_table_mysql.test b/mysql-test/suite/json/t/json_table_mysql.test index 9f77ad964f3..3b0fb556260 100644 --- a/mysql-test/suite/json/t/json_table_mysql.test +++ b/mysql-test/suite/json/t/json_table_mysql.test @@ -167,6 +167,7 @@ select * from #eval $query; #eval explain $query; +--source include/explain-no-costs.inc explain format=json select * from json_table( |