Aren’t support for the renaming tables almost available in the both ICE 3.3.0 and 3.3.1? Looking at the source code the only thing I see missing is the connection between the Brighthouse handler and the rename table method?
And if this is the case why aren’t it fully implemented?

Regards,
Kim Christensen

Also the current implementation, actually makes a table unusable. This is because the .frm file are renamed, but the corresponding .bht directory are not renamed. This make the table unreadable, until the directory and .frm file matches.
I have created a bug report here, and attached a patch which enables the RENAME TABLE statement.

Hi !

I guess rename table in ICE is not supported officially. So there is no bug But thanks for the contribution!

Officially support or not, at least the statement shouldn’t make the table inaccessible. Instead it should return, command not supported or something like that.

Oh sorry, I did not get it, that the command is not rejected and leads to data corruption. So there is a serious bug…

Update: ALTER TABLE RENAME is not implemented and gives a correct error message. RENAME TABLE corrupts data - it is not handled properly.

Update2: The problem is caused by the new implementation of RENAME TABLE in mysql 5.1.40 GA, so it started to appear after IB migrated to mysql GA