mysql-test/suite/perfschema/t/idx_hosts.test
raw| 1 | # Tests for PERFORMANCE_SCHEMA |
| 2 | |
| 3 | #setup |
| 4 | let $select_column = TOTAL_CONNECTIONS; |
| 5 | let $table = performance_schema.hosts; |
| 6 | |
| 7 | create user foo@localhost; |
| 8 | grant ALL on *.* to foo@localhost; |
| 9 | connect(con, localhost, foo,,); |
| 10 | |
| 11 | # Test index on HOST |
| 12 | |
| 13 | let $column_count = 1; |
| 14 | let $col1 = HOST; |
| 15 | let $col1_act = "localhost"; |
| 16 | |
| 17 | --source ../include/idx_explain_test.inc |
| 18 | |
| 19 | # Cleanup |
| 20 | drop user foo@localhost; |