diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/all_tests.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/all_tests.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/all_tests.result b/mysql-test/suite/perfschema/r/all_tests.result new file mode 100644 index 00000000..6b343d9d --- /dev/null +++ b/mysql-test/suite/perfschema/r/all_tests.result @@ -0,0 +1,24 @@ +drop table if exists t1; +drop table if exists t2; +create table t1 (test_name text); +create table t2 (test_name text); +load data infile "<MYSQLTEST_VARDIR>/tmp/perfschema-all_tests.txt" into table t1; +insert into t2 select concat('ddl_', table_name, '.test') from information_schema.tables +where table_schema='performance_schema'; +insert into t2 select concat('dml_', table_name, '.test') from information_schema.tables +where table_schema='performance_schema'; +update t2 set test_name= replace(test_name, "events_waits_summary_", "ews_"); +update t2 set test_name= replace(test_name, "events_stages_summary_", "esgs_"); +update t2 set test_name= replace(test_name, "events_statements_summary_", "esms_"); +update t2 set test_name= replace(test_name, "events_transactions_summary_", "ets_"); +update t2 set test_name= replace(test_name, "file_summary_", "fs_"); +update t2 set test_name= replace(test_name, "objects_summary_", "os_"); +update t2 set test_name= replace(test_name, "table_io_waits_summary_", "tiws_"); +update t2 set test_name= replace(test_name, "table_lock_waits_summary_", "tlws_"); +update t2 set test_name= replace(test_name, "memory_summary_", "mems_"); +update t2 set test_name= replace(test_name, "user_variables_", "uvar_"); +delete from t2 where t2.test_name in (select t1.test_name from t1); +select test_name as `MISSING DDL/DML TESTS` from t2; +MISSING DDL/DML TESTS +drop table t1; +drop table t2; |