Debian Codegraph @

mysql-test/suite/perfschema/t/idx_uvar_by_thread.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 = VARIABLE_VALUE;
10 let $table = performance_schema.user_variables_by_thread;
11 select connection_id() into @conid;
12
13 select thread_id from performance_schema.threads
14 where PROCESSLIST_ID = @conid
15 into @tid;
16
17 set @a=1;
18 set @b=2;
19 set @c=3;
20
21 ###########################################################################
22 # Test index on THREAD_ID, VARIABLE_NAME
23 ###########################################################################
24
25 let $column_count = 2;
26 let $col1 = THREAD_ID;
27 let $col2 = VARIABLE_NAME;
28 let $col1_act = @tid;
29 let $col2_act = "a";
30
31 --source ../include/idx_explain_test.inc