Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/no_protocol.inc
4
5 #setup
6 let $select_column = COUNT_BUCKET;
7 let $table = performance_schema.events_statements_histogram_by_digest;
8
9 let $olddb = `select database()`;
10 create database explain_test_db;
11 use explain_test_db;
12
13 # truncate table performance_schema.events_statements_histogram_by_digest;
14 truncate table performance_schema.events_statements_summary_by_digest;
15
16 select 1;
17
18 select digest from performance_schema.events_statements_histogram_by_digest
19 where SCHEMA_NAME = 'explain_test_db' limit 1
20 into @digest;
21
22 eval use $olddb;
23
24 ###########################################################################
25 # Test index on SCHEMA_NAME, DIGEST, BUCKET_NUMBER
26 ###########################################################################
27
28 let $column_count = 3;
29 let $col1 = SCHEMA_NAME;
30 let $col2 = DIGEST;
31 let $col3 = BUCKET_NUMBER;
32 let $col1_act = "explain_test_db";
33 let $col2_act = @digest;
34 let $col3_act = 0;
35
36 --source ../include/idx_explain_test.inc
37
38 # Cleanup
39 drop database explain_test_db;