Verified as described with vanilla mysql 5.6 & 5.7, percona server 5.5, 5.6.,5.7 The issue is not reproduced with mysql 8.0.2.
It's possible to make test.b table visible again with: mysql> select * from b; ERROR 1146 (42S02): Table 'test.b' doesn't exist mysql> set foreign_key_checks=0; Query OK, 0 rows affected (0.00 sec) mysql> select * from b; Empty set (0.00 sec) ** Bug watch added: MySQL Bug System #87270 http://bugs.mysql.com/bug.php?id=87270 ** Also affects: mysql-server via http://bugs.mysql.com/bug.php?id=87270 Importance: Unknown Status: Unknown ** Also affects: percona-server/5.6 Importance: Undecided Status: New ** Also affects: percona-server/5.5 Importance: Undecided Status: New ** Also affects: percona-server/5.7 Importance: Undecided Status: New ** Changed in: percona-server/5.6 Status: New => Confirmed ** Changed in: percona-server/5.7 Status: New => Confirmed ** Changed in: percona-server/5.5 Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Server/Client Support Team, which is subscribed to MySQL. Matching subscriptions: Ubuntu Server/Client Support Team https://bugs.launchpad.net/bugs/1705239 Title: Mysql allows modifying referenced table with incompatible charset and after mysql restart referencing(or referenced depending on order of commands) table disappears from catalog To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1705239/+subscriptions -- Mailing list: https://launchpad.net/~enterprise-support Post to : [email protected] Unsubscribe : https://launchpad.net/~enterprise-support More help : https://help.launchpad.net/ListHelp
