From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/suite/perfschema/t/merge_table_io.test | 46 +++++++++++++++++++++++ 1 file changed, 46 insertions(+) create mode 100644 mysql-test/suite/perfschema/t/merge_table_io.test (limited to 'mysql-test/suite/perfschema/t/merge_table_io.test') diff --git a/mysql-test/suite/perfschema/t/merge_table_io.test b/mysql-test/suite/perfschema/t/merge_table_io.test new file mode 100644 index 00000000..d4727525 --- /dev/null +++ b/mysql-test/suite/perfschema/t/merge_table_io.test @@ -0,0 +1,46 @@ +# 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 table if exists $table_item; +drop table if exists test.no_index_tab_1; +drop table if exists test.no_index_tab_2; +--enable_warnings + +# Start recording events +update performance_schema.setup_consumers set enabled='YES'; +insert into marker set a = 1; +eval create table test.no_index_tab_1 +( a varchar(255) not null, b int not null) engine = $engine_type; +insert into marker set a = 1; +create table test.no_index_tab_2 like test.no_index_tab_1; +insert into marker set a = 1; +eval create table $table_item + ( a varchar(255) not null, b int not null) engine = merge + union = (test.no_index_tab_1,test.no_index_tab_2) insert_method = first; +insert into marker set a = 1; +# Make sure the proper engine is used +show create table test.no_index_tab_1; +insert into marker set a = 1; +show create table test.no_index_tab_2; +insert into marker set a = 1; +eval show create table $table_item; +--source ../include/table_io_basic_dml.inc +drop table test.no_index_tab_1; +insert into marker set a = 1; +drop table test.no_index_tab_2; +insert into marker set a = 1; +eval drop table $table_item; + +# Stop recording events + pull result +--source ../include/table_io_result_helper.inc + +# Cleanup +--source ../include/table_io_cleanup_helper.inc + -- cgit v1.2.3