diff options
Diffstat (limited to 'mysql-test/suite/perfschema/t/temp_table_io.test')
| -rw-r--r-- | mysql-test/suite/perfschema/t/temp_table_io.test | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/t/temp_table_io.test b/mysql-test/suite/perfschema/t/temp_table_io.test new file mode 100644 index 00000000..7a4d6999 --- /dev/null +++ b/mysql-test/suite/perfschema/t/temp_table_io.test @@ -0,0 +1,28 @@ +# Tests for PERFORMANCE_SCHEMA table io + +--source include/not_embedded.inc +--source include/have_perfschema.inc +--source ../include/table_io_setup_helper.inc + +let $engine_type= MyISAM; +let $table_item= test.no_index_tab; +--disable_warnings +eval drop temporary table if exists $table_item; +--enable_warnings + +# Start recording events +update performance_schema.setup_consumers set enabled = 'YES'; +insert into marker set a = 1; +eval create temporary table $table_item +( a varchar(255) not null, b int not null) engine = $engine_type; +insert into marker set a = 1; +eval show create table $table_item; +--source ../include/table_io_basic_dml.inc +eval drop temporary table $table_item; + +# Stop recording events + pull result +--source ../include/table_io_result_helper.inc + +# Cleanup +--source ../include/table_io_cleanup_helper.inc + |