Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/no_protocol.inc
4
5 #setup
6 let $select_column = COUNT_STAR;
7 let $table = performance_schema.events_statements_summary_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_summary_by_digest;
14
15 select 1;
16
17 select digest from performance_schema.events_statements_summary_by_digest
18 where SCHEMA_NAME = 'explain_test_db' limit 1
19 into @digest;
20
21 eval use $olddb;
22
23 ###########################################################################
24 # Test index on SCHEMA_NAME, DIGEST
25 ###########################################################################
26
27 let $column_count = 2;
28 let $col1 = SCHEMA_NAME;
29 let $col2 = DIGEST;
30 let $col1_act = "explain_test_db";
31 let $col2_act = @digest;
32
33 --source ../include/idx_explain_test.inc
34
35 # Cleanup
36 drop database explain_test_db;