Debian Codegraph @

mysql-test/suite/sys_vars/r/all_vars.result

raw
1 create table t1 (test_name text);
2 create table t2 (variable_name text);
3 load data infile "MYSQLTEST_VARDIR/tmp/sys_vars.all_vars.txt" into table t1;
4 insert into t2 select variable_name from information_schema.global_variables;
5 insert into t2 select variable_name from information_schema.session_variables;
6 update t2 set variable_name= replace(variable_name, "PERFORMANCE_SCHEMA_", "PFS_");
7 select distinct variable_name as `there should be *no* long test name listed below:` from t2
8 where length(variable_name) > 50;
9 there should be *no* long test name listed below:
10 select distinct variable_name as `there should be *no* variables listed below:` from t2
11 left join t1 on variable_name=test_name where test_name is null;
12 there should be *no* variables listed below:
13 wsrep_certification_rules
14 drop table t1;
15 drop table t2;