Debian Codegraph @

mysql-test/suite/sys_vars/t/sysvars_star.test

raw
1 #
2 # MDEV-12684 Show what config file a sysvar got a value from
3 #
4
5 source include/not_embedded.inc;
6 if (!$SQL_ERRLOG_SO) {
7 skip No sql_errlog plugin;
8 }
9
10 #system_versioning_alter_history
11 #binlog_format
12 set completion_type=CHAIN;
13 set global low_priority_updates=1;
14
15 install soname 'sql_errlog';
16
17 vertical_results;
18 replace_regex /(C:)?\/.*\//var\//;
19 select * from information_schema.system_variables
20 where variable_name in (
21 'completion_type', #session!=global, origin=compile-time
22 'low_priority_updates', #global!=default, origin=sql
23 'column_compression_threshold', #origin=command-line
24 'plugin_maturity', #origin=config
25 'sql_error_log_rate', #plugin, origin=command-line
26 'sql_error_log_rotations' #plugin, origin=config
27 )
28 order by variable_name;
29
30 create user foo@localhost;
31
32 connect foo,localhost,foo;
33 select global_value_path from information_schema.system_variables where variable_name='plugin_maturity';
34 connection default;
35 replace_regex /(C:)?\/.*\//var\//;
36 select global_value_path from information_schema.system_variables where variable_name='plugin_maturity';
37 disconnect foo;
38 drop user foo@localhost;
39 set global low_priority_updates=default;
40 disable_warnings;
41 uninstall soname 'sql_errlog';
42 let $count_sessions= 1;
43 source include/wait_until_count_sessions.inc;