Comment 1 for bug 1645386

With Innodb it is something like:

mysql [localhost] {root} (dbtest) > alter table dbtest.sbtest1 rename fff.sbtest1;
ERROR 1025 (HY000): Error on rename of './dbtest/sbtest1' to './fff/sbtest1' (errno: -1 - Unknown error -1)

But the base table will remain good:
mysql [localhost] {root} (dbtest) > show tables;
+------------------+
| Tables_in_dbtest |
+------------------+
| sbtest1 |
+------------------+
1 row in set (0.00 sec)

mysql [localhost] {root} (dbtest) > select count(*) from sbtest1;
+----------+
| count(*) |
+----------+
| 10000 |
+----------+
1 row in set (0.04 sec)

http://bugs.mysql.com/bug.php?id=84000