Debian Codegraph @

mysql-test/suite/perfschema/t/idx_esms_by_thread_by_event_name.test

raw
1 # Performance schema tests generally depend on specific query plans
2 # and behavior, and much of the perfschema suite is therefore disabled
3 # if the hypergraph optimizer is active.
4 --source include/not_hypergraph.inc
5
6 # Tests for PERFORMANCE_SCHEMA
7
8 #setup
9 let $select_column = COUNT_STAR;
10 let $table = performance_schema.events_statements_summary_by_thread_by_event_name;
11
12 select connection_id() into @conid;
13
14 select thread_id from performance_schema.threads
15 where PROCESSLIST_ID = @conid
16 into @tid;
17
18 ###########################################################################
19 # Test index on THREAD_ID, EVENT_NAME
20 ###########################################################################
21
22 let $column_count = 2;
23 let $col1 = THREAD_ID;
24 let $col2 = EVENT_NAME;
25 let $col1_act = @tid;
26 let $col2_act = "statement/sql/select";
27
28 --source ../include/idx_explain_test.inc