Debian Codegraph @

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

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