summaryrefslogtreecommitdiff
path: root/mysql-test/main/show_explain_ps.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/show_explain_ps.result')
-rw-r--r--mysql-test/main/show_explain_ps.result7
1 files changed, 3 insertions, 4 deletions
diff --git a/mysql-test/main/show_explain_ps.result b/mysql-test/main/show_explain_ps.result
index fae432e830e..69ee2cab31d 100644
--- a/mysql-test/main/show_explain_ps.result
+++ b/mysql-test/main/show_explain_ps.result
@@ -31,12 +31,11 @@ count(*)
set debug_dbug='';
select event_name
from
-performance_schema.events_stages_history_long
+performance_schema.events_stages_history_long join
+performance_schema.threads using (thread_id)
where
event_name like '%show explain' and
-thread_id in(select thread_id
-from performance_schema.events_statements_history_long
-where EVENT_NAME='statement/sql/show_explain');
+processlist_id=$thr1;
event_name
stage/sql/Show explain
drop table t0;