TokuDB renaming table to nonexistent DB destroys table
Bug #1645386 reported by
Kai
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.6 |
Fix Released
|
Critical
|
Vlad Lesin | |||
5.7 |
Fix Released
|
Critical
|
Vlad Lesin |
Bug Description
tokudb_version 5.6.33-79.0
ALTER TABLE foo.bar RENAME zot.bar;
If table "zot" does not exist, the table is destroyed instead of giving an error message.
This occurs with tokudb_dir_per_db both ON and OFF. All other TokuDB variables have not been changed at any point.
affects: | percona-xtradb-cluster → percona-server |
tags: | added: tokudb |
Changed in percona-server: | |
importance: | Undecided → Critical |
To post a comment you must log in.
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