1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
# Performance schema tests generally depend on specific query plans
# and behavior, and much of the perfschema suite is therefore disabled
# if the hypergraph optimizer is active.
--source include/not_hypergraph.inc
# Tests for PERFORMANCE_SCHEMA
#setup
let $select_column = COUNT_STAR;
let $table = performance_schema.events_waits_summary_by_instance;
select OBJECT_INSTANCE_BEGIN from performance_schema.events_waits_summary_by_instance limit 1
into @oib;
select EVENT_NAME from performance_schema.events_waits_summary_by_instance limit 1
into @ename;
###########################################################################
# Test index on OBJECT_INSTANCE_BEGIN
###########################################################################
let $column_count = 1;
let $col1 = OBJECT_INSTANCE_BEGIN;
let $col1_act = @oib;
--source ../include/idx_explain_test.inc
###########################################################################
# Test index on EVENT_NAME
###########################################################################
let $column_count = 1;
let $col1 = EVENT_NAME;
let $col1_act = @ename;
--source ../include/idx_explain_test.inc
|
