Debian Codegraph @

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

raw
1 # Performance schema tests generally depend on specific query plans
2 # and behavior, and much of the perfschema suite is therefore disabled
3 # if the hypergraph optimizer is active.
4 --source include/not_hypergraph.inc
5
6 # Tests for PERFORMANCE_SCHEMA
7
8 #setup
9 let $select_column = COUNT(*);
10 let $table = performance_schema.table_handles;
11
12 connect(con1, localhost, root,,);
13
14 --echo # Connection con1
15 --connection con1
16
17 create database explain_test_db;
18 create table explain_test_db.explain_test_table(a int);
19
20 lock table explain_test_db.explain_test_table write;
21 insert into explain_test_db.explain_test_table values (1);
22
23 --echo # Connection default
24 --connection default
25
26 #select * from performance_schema.table_handles;
27
28 select OBJECT_INSTANCE_BEGIN, OWNER_THREAD_ID, OWNER_EVENT_ID
29 from performance_schema.table_handles
30 where OBJECT_NAME = 'explain_test_table'
31 into @oib, @o_tid, @o_eid;
32
33 ###########################################################################
34 # Test index on OBJECT_INSTANCE_BEGIN
35 ###########################################################################
36
37 let $column_count = 1;
38 let $col1 = OBJECT_INSTANCE_BEGIN;
39 let $col1_act = @oib;
40
41 --source ../include/idx_explain_test.inc
42
43 ###########################################################################
44 # Test index on OBJECT_TYPE, OBJET_SCHEMA, OBJECT_NAME
45 ###########################################################################
46
47 let $column_count = 3;
48 let $col1 = OBJECT_TYPE;
49 let $col2 = OBJECT_SCHEMA;
50 let $col3 = OBJECT_NAME;
51 let $col1_act = "TABLE";
52 let $col2_act = "explain_test_db";
53 let $col3_act = "explain_test_table";
54
55 --source ../include/idx_explain_test.inc
56
57 ###########################################################################
58 # Test index on OWNER_THREAD_ID, OWNER_EVENT_ID
59 ###########################################################################
60
61 let $column_count = 2;
62 let $col1 = OWNER_THREAD_ID;
63 let $col2 = OWNER_EVENT_ID;
64 let $col1_act = @o_tid;
65 let $col2_act = @o_eid;
66
67 --source ../include/idx_explain_test.inc
68
69 # Cleanup
70
71 --echo # Connection con1
72 --connection con1
73 unlock tables;
74 drop table explain_test_db.explain_test_table;
75 drop database explain_test_db;
76
77 --echo # Connection default
78 --connection default
79 --disconnect con1