Debian Codegraph @

mysql-test/suite/perfschema/r/all_tests.result

raw
1 drop table if exists t1;
2 drop table if exists t2;
3 create table t1 (test_name text);
4 create table t2 (test_name text);
5 load data infile "<MYSQLTEST_VARDIR>/tmp/perfschema-all_tests.txt" into table t1;
6 insert into t2 select concat('ddl_', table_name, '.test') from information_schema.tables
7 where table_schema='performance_schema';
8 insert into t2 select concat('dml_', table_name, '.test') from information_schema.tables
9 where table_schema='performance_schema';
10 update t2 set test_name= replace(test_name, "events_waits_summary_", "ews_");
11 update t2 set test_name= replace(test_name, "events_stages_summary_", "esgs_");
12 update t2 set test_name= replace(test_name, "events_statements_summary_", "esms_");
13 update t2 set test_name= replace(test_name, "events_transactions_summary_", "ets_");
14 update t2 set test_name= replace(test_name, "file_summary_", "fs_");
15 update t2 set test_name= replace(test_name, "objects_summary_", "os_");
16 update t2 set test_name= replace(test_name, "table_io_waits_summary_", "tiws_");
17 update t2 set test_name= replace(test_name, "table_lock_waits_summary_", "tlws_");
18 update t2 set test_name= replace(test_name, "memory_summary_", "mems_");
19 update t2 set test_name= replace(test_name, "user_variables_", "uvar_");
20 delete from t2 where t2.test_name in (select t1.test_name from t1);
21 select test_name as `MISSING DDL/DML TESTS` from t2;
22 MISSING DDL/DML TESTS
23 drop table t1;
24 drop table t2;