Debian Codegraph @

mysql-test/suite/perfschema/t/idx_esmh_global.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_global;
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_global;
14
15 select 1;
16
17 eval use $olddb;
18
19 ###########################################################################
20 # Test index on BUCKET_NUMBER
21 ###########################################################################
22
23 let $column_count = 1;
24 let $col1 = BUCKET_NUMBER;
25 let $col1_act = 12;
26
27 --source ../include/idx_explain_test.inc
28
29 # Cleanup
30 drop database explain_test_db;