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 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;