Debian Codegraph @

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

raw
1 #
2 # Verify that query results are the same with and without indexes.
3 #
4 --source include/have_debug_sync.inc
5
6 let $table = "setup_actors";
7 let $key_group = 2.7;
8
9 --echo TABLE: $table
10 --echo INDEXES: PK (USER, HOST, EVENT_NAME)
11
12 --source ../include/idx_compare_setup.inc
13
14 insert into performance_schema.setup_actors values ("localhost","user1","%",'YES','YES');
15 insert into performance_schema.setup_actors values ("localhost","user2","%",'YES','YES');
16 insert into performance_schema.setup_actors values ("localhost","user3","%",'YES','YES');
17
18 --source ../include/idx_compare_load.inc
19
20 TRUNCATE performance_schema.setup_actors;
21 INSERT INTO performance_schema.setup_actors VALUES ('%', '%', '%', 'YES', 'YES');
22
23 --source ../include/idx_compare_cleanup.inc