blob: fec5b9c6bd5b387ef3ad04a26f7fe1b1c1671dcc (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
# verify that show_status_array and sys_var::val_str print values identically
use information_schema;
select variable_name, s.variable_value, v.global_value
from global_variables s join system_variables v using (variable_name)
where not (s.variable_value <=> v.global_value);
select variable_name, s.variable_value, v.session_value
from session_variables s join system_variables v using (variable_name)
where v.variable_scope != 'GLOBAL' and
not (s.variable_value <=> v.session_value);
|
