summaryrefslogtreecommitdiff
path: root/mysql-test/t/subselect_cache.test
diff options
context:
space:
mode:
authorSergei Petrunia <psergey@askmonty.org>2017-01-26 02:57:12 +0300
committerSergei Petrunia <psergey@askmonty.org>2017-01-26 02:57:12 +0300
commit4113f1a7b774014cbe92923564bce876a370a170 (patch)
tree9296a14f9fd64324d59353232c8c159409cd27b5 /mysql-test/t/subselect_cache.test
parent86ca1357b0637f76be4184b76cbe4b32080c10de (diff)
parent9394bc06d832e6637afc9dba75f53f1ad7307bea (diff)
downloadmariadb-git-bb-10.1-otto.tar.gz
Merge branch 'grooverdan-10.1-MDEV-11866-ANALYZE-FORMAT=JSON-volatility-normalise' into 10.1bb-10.1-otto
Diffstat (limited to 'mysql-test/t/subselect_cache.test')
-rw-r--r--mysql-test/t/subselect_cache.test4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/subselect_cache.test b/mysql-test/t/subselect_cache.test
index 21247541fb6..55da0000f13 100644
--- a/mysql-test/t/subselect_cache.test
+++ b/mysql-test/t/subselect_cache.test
@@ -24,10 +24,10 @@ select a, (select d from t2 where b=c) from t1;
show status like "subquery_cache%";
show status like '%Handler_read%';
---replace_regex /"r_total_time_ms": [0-9]*[.]?[0-9]*/"r_total_time_ms": "REPLACED"/
+--source include/analyze-format.inc
analyze format=json
select a, (select d from t2 where b=c) from t1;
---replace_regex /"r_total_time_ms": [0-9]*[.]?[0-9]*/"r_total_time_ms": "REPLACED"/
+--source include/analyze-format.inc
analyze format=json
select a, (select d from t2 where b=c), (select d from t2 where b=c union select 1 order by 1 limit 1) from t1;
explain format=json