enterprise-support team mailing list archive

[Sveta Smirnova <sveta@xxxxxxxxxxxxx>]

Public bug reported:

Trying to verify bug #1597497 found this one.

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.

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.5
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.6
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.7
     Importance: Undecided
         Status: Confirmed


** Tags: i100474

** Attachment added: "Test case in MTR format"
   https://bugs.launchpad.net/bugs/1605000/+attachment/4704283/+files/bug1597497_1.test

** Changed in: percona-server
       Status: New => Confirmed

** Also affects: percona-server/5.7
   Importance: Undecided
       Status: Confirmed

** Also affects: percona-server/5.5
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.6
   Importance: Undecided
       Status: New

** Changed in: percona-server/5.5
       Status: New => Confirmed

** Changed in: percona-server/5.6
       Status: New => Confirmed

** Bug watch added: MySQL Bug System #82298
   http://bugs.mysql.com/bug.php?id=82298

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=82298
   Importance: Unknown
       Status: Unknown

-- 
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/1605000

Title:
  RENAME TABLE fails with "Table ... already exists" error with not
  existent table

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1605000/+subscriptions