Bug #82298 RENAME TABLE fails with "Table ... already exists" error with not existent table
Submitted: 20 Jul 2016 22:30 Modified: 21 Jul 2016 6:43
Reporter: Sveta Smirnova (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:5.5.50, 5.6.31, 5.7.13 OS:Any
Assigned to: CPU Architecture:Any

[20 Jul 2016 22:30] Sveta Smirnova 
Description:
RENAME TABLE fails with "Table ... already exists" error with not existent table

How to repeat:
show tables;
Tables_in_test
XK4P3A_B0ZCUC_4WXPFR_MIDTE7_BOA174_IQJFXC_2AE81C_HP6FVD_1OLDJ0_K
_product_instance_new
customer_profile
organisation
product_specification

mysqltest: At line 152: query 'RENAME TABLE `_product_instance_new` TO `product_instance`' failed: 1050: Table './test/product_instance' already exists

Test case will be attached.
[20 Jul 2016 22:31] Sveta Smirnova 
Test case for MTR

Attachment: bug1597497_1.test (application/octet-stream, text), 6.99 KiB.
[21 Jul 2016 6:43] MySQL Verification Team 
Hello Sveta,

Thank you for the report and test case.
Verified as described.

Regards,
Umesh