summaryrefslogtreecommitdiff
path: root/mysql-test/suite/federated
diff options
context:
space:
mode:
authorLuis Eduardo Oliveira Lizardo <108760288+mariadb-LuisLizardo@users.noreply.github.com>2022-07-18 17:48:01 +0200
committerGitHub <noreply@github.com>2022-07-18 17:48:01 +0200
commit2ccdfba8ee1af02ab17d4aff366a1c9d1883425b (patch)
tree03f090e9fe85d673e39453c06d22e2580e78ba26 /mysql-test/suite/federated
parent88b22356e623fd63aa87273a895521a6e6667bc7 (diff)
downloadmariadb-git-2ccdfba8ee1af02ab17d4aff366a1c9d1883425b.tar.gz
MDEV-28926 Add time spent on query optimizer to JSON ANALYZE (#2193)
* Add query optimizer timer to ANALYZE FORMAT=JSON * Adapt tests and results * Change logic to always close the writer after printing query blocks
Diffstat (limited to 'mysql-test/suite/federated')
-rw-r--r--mysql-test/suite/federated/federatedx_create_handlers.result6
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 6dcd53e77c7..8a82df0ddfc 100644
--- a/mysql-test/suite/federated/federatedx_create_handlers.result
+++ b/mysql-test/suite/federated/federatedx_create_handlers.result
@@ -117,6 +117,9 @@ ANALYZE FORMAT=JSON
SELECT id FROM federated.t1 WHERE id < 5;
ANALYZE
{
+ "query_optimization": {
+ "r_total_time_ms": "REPLACED"
+ },
"query_block": {
"select_id": 1,
"table": {
@@ -223,6 +226,9 @@ FROM federated.t2 GROUP BY name)) t
WHERE federated.t3.name=t.name;
ANALYZE
{
+ "query_optimization": {
+ "r_total_time_ms": "REPLACED"
+ },
"query_block": {
"select_id": 1,
"r_loops": 1,