azurit,
I'm not sure we can get away with just a warning, since there is no a good enough workaround for the users. Dumping system tables every time before a minor upgrade doesn't sound like a great idea.
Sergei Golubchik,
The problem affects both 5.5 and 10.0. In 10.0, even though we extend the length of the columns at the end of mysql_system_tables_fix.sql, earlier there is an ALTER that truncates them (and hence the data) to 16 symbols. The fix is simple there, we just need to modify the alter to use the correct length.
With 5.5, the only idea I have at the moment is doing it via prepared statements, something like the example below.
Unfortunately, it will have to be done in different places, so it's going to look ugly.
Anyway, if you think that's what we should do (both for 5.5 and 10.0), I can go through the scripts and make the changes, so you don't need to waste time on that.
Hi,
What do you mean by "probably"? What exactly do you observe?