enterprise-support team mailing list archive

[Nickolay Ihalainen <ihanick@xxxxxxxxx>]

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