1create table t1 (test_name text); 2create table t2 (variable_name text); 3load data infile "MYSQLTEST_VARDIR/tmp/sys_vars.all_vars.txt" into table t1; 4insert into t2 select variable_name from information_schema.global_variables; 5insert into t2 select variable_name from information_schema.session_variables; 6update t2 set variable_name= replace(variable_name, "PERFORMANCE_SCHEMA_", "PFS_"); 7update t2 set variable_name= replace(variable_name, "_HISTORY_LONG_", "_HL_"); 8update t2 set variable_name= replace(variable_name, "_HISTORY_", "_H_"); 9update t2 set variable_name= replace(variable_name, "_THROTTLE_QUERIES_NOT_USING_INDEXES", "_THROTTLE_QNI"); 10select variable_name as `There should be *no* long test name listed below:` from t2 11where length(variable_name) > 50; 12There should be *no* long test name listed below: 13select variable_name as `There should be *no* variables listed below:` from t2 14left join t1 on variable_name=test_name where test_name is null ORDER BY variable_name; 15There should be *no* variables listed below: 16DISABLED_STORAGE_ENGINES 17DISABLED_STORAGE_ENGINES 18KEYRING_OPERATIONS 19KEYRING_OPERATIONS 20REPLICATION_OPTIMIZE_FOR_STATIC_PLUGIN_CONFIG 21REPLICATION_OPTIMIZE_FOR_STATIC_PLUGIN_CONFIG 22REPLICATION_SENDER_OBSERVE_COMMIT_ONLY 23REPLICATION_SENDER_OBSERVE_COMMIT_ONLY 24TLS_VERSION 25TLS_VERSION 26drop table t1; 27drop table t2; 28