Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 #setup
4 let $select_column = COUNT_STAR;
5 let $table = performance_schema.events_statements_summary_by_program;
6
7 let $olddb = `select database()`;
8 create database explain_test_db;
9 use explain_test_db;
10 create table explain_test_table(c int);
11 delimiter //;
12 create procedure explain_test_proc()
13 BEGIN
14 select * from explain_test_table;
15 END //
16 delimiter ;//
17
18 truncate table performance_schema.events_statements_summary_by_program;
19 call explain_test_proc();
20
21 ###########################################################################
22 # Test index on OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
23 ###########################################################################
24
25 let $column_count = 3;
26 let $col1 = OBJECT_TYPE;
27 let $col2 = OBJECT_SCHEMA;
28 let $col3 = OBJECT_NAME;
29 let $col1_act = "PROCEDURE";
30 let $col2_act = "explain_test_db";
31 let $col3_act = "explain_test_proc";
32
33 --source ../include/idx_explain_test.inc
34
35 # Cleanup
36 drop procedure explain_test_proc;
37 drop table explain_test_db.explain_test_table;
38 drop database explain_test_db;