Debian Codegraph @

mysql-test/suite/perfschema/t/idx_session_connect_attrs.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 = ORDINAL_POSITION;
10 let $table = performance_schema.session_connect_attrs;
11
12 select PROCESSLIST_ID from performance_schema.session_connect_attrs limit 1
13 into @plid;
14
15 ##########################################################################
16 # Test index on PROCESSLIST_ID, ATTR_NAME
17 ##########################################################################
18
19 let $column_count = 2;
20 let $col1 = PROCESSLIST_ID;
21 let $col2 = ATTR_NAME;
22 let $col1_act = @plid;
23 let $col2_act = "_os";
24
25 --source ../include/idx_explain_test.inc