| 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 performance_schema.global_variables; |
| 5 |
insert into t2 select variable_name from performance_schema.session_variables; |
| 6 |
update t2 set variable_name= replace(variable_name, "performance_schema_", "pfs_"); |
| 7 |
update t2 set variable_name= replace(variable_name, "_history_long_", "_hl_"); |
| 8 |
update t2 set variable_name= replace(variable_name, "_history_", "_h_"); |
| 9 |
update t2 set variable_name= replace(variable_name, "_throttle_queries_not_using_indexes", "_throttle_qni"); |
| 10 |
update t2 set variable_name= replace(variable_name, "lock_order_", "lo_"); |
| 11 |
select variable_name as `There should be *no* long test name listed below:` from t2 |
| 12 |
where length(variable_name) > 50; |
| 13 |
There should be *no* long test name listed below: |
| 14 |
select variable_name as `There should be *no* variables listed below:` from t2 |
| 15 |
left join t1 on variable_name=test_name where test_name is null ORDER BY variable_name; |
| 16 |
There should be *no* variables listed below: |
| 17 |
activate_all_roles_on_login |
| 18 |
activate_all_roles_on_login |
| 19 |
authentication_policy |
| 20 |
authentication_policy |
| 21 |
binlog_encryption |
| 22 |
binlog_encryption |
| 23 |
binlog_expire_logs_auto_purge |
| 24 |
binlog_expire_logs_auto_purge |
| 25 |
binlog_rotate_encryption_master_key_at_startup |
| 26 |
binlog_rotate_encryption_master_key_at_startup |
| 27 |
cte_max_recursion_depth |
| 28 |
cte_max_recursion_depth |
| 29 |
default_collation_for_utf8mb4 |
| 30 |
default_collation_for_utf8mb4 |
| 31 |
disabled_storage_engines |
| 32 |
disabled_storage_engines |
| 33 |
explain_format |
| 34 |
explain_format |
| 35 |
generated_random_password_length |
| 36 |
generated_random_password_length |
| 37 |
group_replication_consistency |
| 38 |
group_replication_consistency |
| 39 |
init_replica |
| 40 |
init_replica |
| 41 |
init_slave |
| 42 |
init_slave |
| 43 |
innodb_dedicated_server |
| 44 |
innodb_dedicated_server |
| 45 |
innodb_log_spin_cpu_abs_lwm |
| 46 |
innodb_log_spin_cpu_abs_lwm |
| 47 |
innodb_log_spin_cpu_pct_hwm |
| 48 |
innodb_log_spin_cpu_pct_hwm |
| 49 |
innodb_log_wait_for_flush_spin_hwm |
| 50 |
innodb_log_wait_for_flush_spin_hwm |
| 51 |
keyring_operations |
| 52 |
keyring_operations |
| 53 |
log_replica_updates |
| 54 |
log_replica_updates |
| 55 |
log_slave_updates |
| 56 |
log_slave_updates |
| 57 |
log_slow_replica_statements |
| 58 |
log_slow_replica_statements |
| 59 |
log_slow_slave_statements |
| 60 |
log_slow_slave_statements |
| 61 |
mandatory_roles |
| 62 |
mandatory_roles |
| 63 |
master_verify_checksum |
| 64 |
master_verify_checksum |
| 65 |
max_length_for_sort_data |
| 66 |
max_length_for_sort_data |
| 67 |
optimizer_max_subgraph_pairs |
| 68 |
optimizer_max_subgraph_pairs |
| 69 |
partial_revokes |
| 70 |
partial_revokes |
| 71 |
password_require_current |
| 72 |
password_require_current |
| 73 |
pseudo_slave_mode |
| 74 |
regexp_stack_limit |
| 75 |
regexp_stack_limit |
| 76 |
regexp_time_limit |
| 77 |
regexp_time_limit |
| 78 |
replica_allow_batching |
| 79 |
replica_allow_batching |
| 80 |
replica_checkpoint_group |
| 81 |
replica_checkpoint_group |
| 82 |
replica_checkpoint_period |
| 83 |
replica_checkpoint_period |
| 84 |
replica_compressed_protocol |
| 85 |
replica_compressed_protocol |
| 86 |
replica_exec_mode |
| 87 |
replica_exec_mode |
| 88 |
replica_load_tmpdir |
| 89 |
replica_load_tmpdir |
| 90 |
replica_max_allowed_packet |
| 91 |
replica_max_allowed_packet |
| 92 |
replica_net_timeout |
| 93 |
replica_net_timeout |
| 94 |
replica_parallel_type |
| 95 |
replica_parallel_type |
| 96 |
replica_parallel_workers |
| 97 |
replica_parallel_workers |
| 98 |
replica_pending_jobs_size_max |
| 99 |
replica_pending_jobs_size_max |
| 100 |
replica_preserve_commit_order |
| 101 |
replica_preserve_commit_order |
| 102 |
replica_skip_errors |
| 103 |
replica_skip_errors |
| 104 |
replica_sql_verify_checksum |
| 105 |
replica_sql_verify_checksum |
| 106 |
replica_type_conversions |
| 107 |
replica_type_conversions |
| 108 |
replication_optimize_for_static_plugin_config |
| 109 |
replication_optimize_for_static_plugin_config |
| 110 |
replication_sender_observe_commit_only |
| 111 |
replication_sender_observe_commit_only |
| 112 |
resultset_metadata |
| 113 |
rpl_stop_replica_timeout |
| 114 |
rpl_stop_replica_timeout |
| 115 |
rpl_stop_slave_timeout |
| 116 |
rpl_stop_slave_timeout |
| 117 |
select_into_buffer_size |
| 118 |
select_into_buffer_size |
| 119 |
select_into_disk_sync |
| 120 |
select_into_disk_sync |
| 121 |
select_into_disk_sync_delay |
| 122 |
select_into_disk_sync_delay |
| 123 |
skip_replica_start |
| 124 |
skip_replica_start |
| 125 |
skip_slave_start |
| 126 |
skip_slave_start |
| 127 |
slave_allow_batching |
| 128 |
slave_allow_batching |
| 129 |
slave_checkpoint_group |
| 130 |
slave_checkpoint_group |
| 131 |
slave_checkpoint_period |
| 132 |
slave_checkpoint_period |
| 133 |
slave_compressed_protocol |
| 134 |
slave_compressed_protocol |
| 135 |
slave_exec_mode |
| 136 |
slave_exec_mode |
| 137 |
slave_load_tmpdir |
| 138 |
slave_load_tmpdir |
| 139 |
slave_max_allowed_packet |
| 140 |
slave_max_allowed_packet |
| 141 |
slave_net_timeout |
| 142 |
slave_net_timeout |
| 143 |
slave_parallel_type |
| 144 |
slave_parallel_type |
| 145 |
slave_parallel_workers |
| 146 |
slave_parallel_workers |
| 147 |
slave_pending_jobs_size_max |
| 148 |
slave_pending_jobs_size_max |
| 149 |
slave_preserve_commit_order |
| 150 |
slave_preserve_commit_order |
| 151 |
slave_skip_errors |
| 152 |
slave_skip_errors |
| 153 |
slave_sql_verify_checksum |
| 154 |
slave_sql_verify_checksum |
| 155 |
slave_transaction_retries |
| 156 |
slave_transaction_retries |
| 157 |
slave_type_conversions |
| 158 |
slave_type_conversions |
| 159 |
sql_require_primary_key |
| 160 |
sql_require_primary_key |
| 161 |
sql_slave_skip_counter |
| 162 |
sql_slave_skip_counter |
| 163 |
statement_id |
| 164 |
sync_master_info |
| 165 |
sync_master_info |
| 166 |
temptable_max_mmap |
| 167 |
temptable_max_mmap |
| 168 |
temptable_use_mmap |
| 169 |
temptable_use_mmap |
| 170 |
terminology_use_previous |
| 171 |
terminology_use_previous |
| 172 |
tls_ciphersuites |
| 173 |
tls_ciphersuites |
| 174 |
use_secondary_engine |
| 175 |
xa_detach_on_prepare |
| 176 |
xa_detach_on_prepare |
| 177 |
drop table t1; |
| 178 |
drop table t2; |