Debian Codegraph @

mysql-test/suite/perfschema/t/idx_socket_summary_by_instance.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.socket_summary_by_instance;
11
12 select OBJECT_INSTANCE_BEGIN, EVENT_NAME
13 from performance_schema.socket_summary_by_instance
14 limit 1
15 into @oib, @e_name;
16
17 ###########################################################################
18 # Test index on OBJECT_INSTANCE_BEGIN
19 ###########################################################################
20
21 let $column_count = 1;
22 let $col1 = OBJECT_INSTANCE_BEGIN;
23 let $col1_act = @oib;
24
25 --source ../include/idx_explain_test.inc
26
27 ###########################################################################
28 # Test index on EVENT_NAME
29 ###########################################################################
30
31 let $column_count = 1;
32 let $col1 = EVENT_NAME;
33 let $col1_act = @e_name;
34
35 --source ../include/idx_explain_test.inc