Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA table io
2
3 --source include/have_myisam.inc
4 --source include/force_myisam_default.inc
5 --source ../include/table_io_setup_helper.inc
6
7 let $engine_type= MyISAM;
8 let $table_item= test.no_index_tab;
9
10 --disable_warnings
11 eval drop table if exists $table_item;
12 drop table if exists test.no_index_tab_1;
13 drop table if exists test.no_index_tab_2;
14 --enable_warnings
15
16 # Start recording events
17 update performance_schema.setup_consumers set enabled='YES';
18 insert into marker set a = 1;
19 eval create table test.no_index_tab_1
20 ( a varchar(255) not null, b int not null) engine = $engine_type;
21 insert into marker set a = 1;
22 create table test.no_index_tab_2 like test.no_index_tab_1;
23 insert into marker set a = 1;
24 eval create table $table_item
25 ( a varchar(255) not null, b int not null) engine = merge
26 union = (test.no_index_tab_1,test.no_index_tab_2) insert_method = first;
27 insert into marker set a = 1;
28 # Make sure the proper engine is used
29 show create table test.no_index_tab_1;
30 insert into marker set a = 1;
31 show create table test.no_index_tab_2;
32 insert into marker set a = 1;
33 eval show create table $table_item;
34 --source ../include/table_io_basic_dml.inc
35 drop table test.no_index_tab_1;
36 insert into marker set a = 1;
37 drop table test.no_index_tab_2;
38 insert into marker set a = 1;
39 eval drop table $table_item;
40
41 # Stop recording events + pull result
42 --source ../include/table_io_result_helper.inc
43
44 # Cleanup
45 --source ../include/table_io_cleanup_helper.inc