Debian Codegraph @

mysql-test/suite/perfschema/t/idx_esgs_by_user_by_event_name.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 #setup
4 let $select_column = COUNT_STAR;
5 let $table = performance_schema.events_stages_summary_by_user_by_event_name;
6
7 create user foo@localhost;
8 grant ALL on *.* to foo@localhost;
9 connect(con, localhost, foo,,);
10
11 ###########################################################################
12 # Test index on USER, EVENT_NAME
13 ###########################################################################
14
15 let $column_count = 2;
16 let $col1 = USER;
17 let $col2 = EVENT_NAME;
18 let $col1_act = "foo";
19 let $col2_act = "stage/sql/executing";
20
21 --source ../include/idx_explain_test.inc
22
23 # Cleanup
24 drop user foo@localhost;