Debian Codegraph @

mysql-test/suite/perfschema/t/idx_rwlock_instances.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 = READ_LOCKED_BY_COUNT;
10 let $table = performance_schema.rwlock_instances;
11
12 select OBJECT_INSTANCE_BEGIN, NAME from performance_schema.rwlock_instances
13 limit 1
14 into @oib, @name;
15
16 #TODO : How to get data for this column?
17 select WRITE_LOCKED_BY_THREAD_ID from performance_schema.rwlock_instances
18 where WRITE_LOCKED_BY_THREAD_ID is not NULL
19 limit 1
20 into @wlbtid;
21
22 ###########################################################################
23 # Test index on OBJECT_INSTANCE_BEGIN
24 ###########################################################################
25
26 let $column_count = 1;
27 let $col1 = OBJECT_INSTANCE_BEGIN;
28 let $col1_act = @oib;
29
30 --source ../include/idx_explain_test.inc
31
32 ###########################################################################
33 # Test index on NAME
34 ###########################################################################
35
36 let $column_count = 1;
37 let $col1 = NAME;
38 let $col1_act = @name;
39
40 --source ../include/idx_explain_test.inc
41
42 ###########################################################################
43 # Test index on WRITE_LOCKED_BY_THREAD_ID
44 ###########################################################################
45
46 #let $column_count = 1;
47 #let $col1 = WRITE_LOCKED_BY_THREAD_ID;
48 #let $col1_act = @wlbtid;
49
50 #--source ../include/idx_explain_test.inc