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