Debian Codegraph @

mysql-test/suite/perfschema/t/idx_fs_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(*);
10 let $table = performance_schema.file_summary_by_instance;
11
12 select OBJECT_INSTANCE_BEGIN from performance_schema.file_summary_by_instance limit 1
13 into @oib;
14 select FILE_NAME from performance_schema.file_summary_by_instance limit 1
15 into @fname;
16 select EVENT_NAME from performance_schema.file_summary_by_instance limit 1
17 into @ename;
18
19 ###########################################################################
20 # Test index on OBJECT_INSTANCE_BEGIN
21 ###########################################################################
22
23 let $column_count = 1;
24 let $col1 = OBJECT_INSTANCE_BEGIN;
25 let $col1_act = @oib;
26
27 --source ../include/idx_explain_test.inc
28
29 ###########################################################################
30 # Test index on FILE_NAME
31 ###########################################################################
32
33 let $column_count = 1;
34 let $col1 = FILE_NAME;
35 let $col1_act = @fname;
36
37 --source ../include/idx_explain_test.inc
38
39 ###########################################################################
40 # Test index on EVENT_NAME
41 ###########################################################################
42
43 let $column_count = 1;
44 let $col1 = EVENT_NAME;
45 let $col1_act = @ename;
46
47 --source ../include/idx_explain_test.inc