Debian Codegraph @

mysql-test/suite/perfschema/t/idx_cond_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 = count(*);
10 let $table = performance_schema.cond_instances;
11
12 select OBJECT_INSTANCE_BEGIN, NAME from performance_schema.cond_instances
13 limit 1
14 into @oib, @name;
15
16 ###########################################################################
17 # Test index on OBJECT_INSTANCE_BEGIN
18 ###########################################################################
19
20 let $column_count = 1;
21 let $col1 = OBJECT_INSTANCE_BEGIN;
22 let $col1_act = @oib;
23
24 --source ../include/idx_explain_test.inc
25
26 ###########################################################################
27 # Test index on NAME
28 ###########################################################################
29
30 let $column_count = 1;
31 let $col1 = NAME;
32 let $col1_act = @name;
33
34 --source ../include/idx_explain_test.inc