Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 #setup
4 let $select_column = ENABLED;
5 let $table = performance_schema.setup_objects;
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 call explain_test_proc();
18
19 insert into performance_schema.setup_objects values ('PROCEDURE',
20 'explain_test_db', 'explain_test_proc', 'YES', 'YES');
21
22 # Test index on OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
23
24 let $column_count = 3;
25 let $col1 = OBJECT_TYPE;
26 let $col2 = OBJECT_SCHEMA;
27 let $col3 = OBJECT_NAME;
28 let $col1_act = "PROCEDURE";
29 let $col2_act = "explain_test_db";
30 let $col3_act = "explain_test_proc";
31
32 --source ../include/idx_explain_test.inc
33
34 # Cleanup
35 delete from performance_schema.setup_objects where object_schema = 'explain_test_db';
36 drop table explain_test_db.explain_test_table;
37 drop database explain_test_db;