Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA table io
2 # Reveal that in case of DML on an updatable view the
3 # base table used within the view shows up whereas
4 # the view itself never shows up.
5
6 --source include/have_myisam.inc
7 --source include/force_myisam_default.inc
8 --source ../include/table_io_setup_helper.inc
9
10 let $engine_type= MyISAM;
11 let $table_item= test.v1;
12
13 --disable_warnings
14 eval drop view if exists $table_item;
15 drop table if exists test.no_index_tab;
16 --enable_warnings
17
18
19 # Start recording events
20 update performance_schema.setup_consumers set enabled='YES';
21 insert into marker set a = 1;
22 eval create table test.no_index_tab
23 ( a varchar(255) not null, b int not null) engine = $engine_type;
24 insert into marker set a = 1;
25 # Make sure the proper engine is used
26 show create table test.no_index_tab;
27 insert into marker set a = 1;
28 eval create view $table_item as select * from test.no_index_tab;
29 --source ../include/table_io_basic_dml.inc
30 eval drop view $table_item;
31 insert into marker set a = 1;
32 drop table test.no_index_tab;
33
34 # Stop recording events + pull result
35 --source ../include/table_io_result_helper.inc
36
37 # Cleanup
38 --source ../include/table_io_cleanup_helper.inc