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 ## To skip the test with QC enabled till BUG#14830950 is fixed.
7 #-- source include/have_QC_Disabled.inc
8
9 --source include/not_embedded.inc
10 --source include/have_perfschema.inc
11 --source ../include/table_io_setup_helper.inc
12
13 let $engine_type= MyISAM;
14 let $table_item= test.v1;
15
16 --disable_warnings
17 eval drop view if exists $table_item;
18 drop table if exists test.no_index_tab;
19 --enable_warnings
20
21
22 # Start recording events
23 update performance_schema.setup_consumers set enabled='YES';
24 insert into marker set a = 1;
25 eval create table test.no_index_tab
26 ( a varchar(255) not null, b int not null) engine = $engine_type;
27 insert into marker set a = 1;
28 # Make sure the proper engine is used
29 show create table test.no_index_tab;
30 insert into marker set a = 1;
31 eval create view $table_item as select * from test.no_index_tab;
32 --source ../include/table_io_basic_dml.inc
33 eval drop view $table_item;
34 insert into marker set a = 1;
35 drop table test.no_index_tab;
36
37 # Stop recording events + pull result
38 --source ../include/table_io_result_helper.inc
39
40 # Cleanup
41 --source ../include/table_io_cleanup_helper.inc
42