Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 #setup
4 let $select_column = VARIABLE_VALUE;
5 let $table = performance_schema.status_by_account;
6
7 create user foo@localhost;
8 grant ALL on *.* to foo@localhost;
9 connect(con, localhost, foo,,);
10
11 --echo # Connection con
12 --connection con
13
14 # Test index on HOST, USER, VARIABLE_NAME
15 let $column_count = 3;
16 let $col1 = USER;
17 let $col2 = HOST;
18 let $col3 = VARIABLE_NAME;
19 let $col1_act = "foo";
20 let $col2_act = "localhost";
21 let $col3_act = "Max_execution_time_exceeded";
22
23 --source ../include/idx_explain_test.inc
24
25 --echo # Conenction default
26 --connection default
27
28 #Cleanup
29 --disconnect con
30 drop user foo@localhost;