#977 Host Tab variables not updating

[Anonymous]

Originally created by: lostsec...@gmail.com

What exact steps will reproduce the problem?
1. Go to Host Tab
2. Change character_set_* to utf8
3. Change table_type = InnoDB

What was the expected output?
Variables value to reflect change imidiatly

What happened instead?
Nothing: changes are only visible after reconnect

Version used?
HeidiSQL revision: 2256
MySQL Server version: 5
Operating system: Vista

[Anonymous]

Originally posted by: a...@anse.de

The variables list gets refreshed correctly, it's just that the server returning the
old value in SHOW VARIABLES. A FLUSH VARIABLES command unfortunately doesn't exist
and FLUSH STATUS doesn't do the trick. So the only working fix would be a disconnect
plus reconnect, which would be silly just for getting some cosmetic thing working.

See also: http://dev.mysql.com/doc/refman/5.0/en/using-system-variables.html
"The global variable change does not affect the session variable for any client that
is currently connected (not even that of the client that issues the SET GLOBAL
statement)."

I'm not sure but one could interprete this as a bug in MySQL. Feel free to send them
a bug report if you feel it's worth the effort.

Status: Upstream