Bug #22182 Renaming database doesn't work
Submitted: 9 Sep 2006 10:38 Modified: 15 Jun 2007 8:30
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:5.2 OS:Any (all)
Assigned to: CPU Architecture:Any

[9 Sep 2006 10:38] Georg Richter
Description:
After I've said RENAME DATABASE, I get 'error 157' from storage engine.

There is apparent similarity to bug 211, but I make a separate bug report
since I can't tell if the cause is the same.

How to repeat:
mysql> create database falcon1;
Query OK, 1 row affected (0.00 sec)

mysql> use falcon1;
Database changed
mysql> create table t (s1 int);
Query OK, 0 rows affected (0.16 sec)

mysql> rename database falcon1 to falcon2;
Query OK, 0 rows affected (0.05 sec)

mysql> insert into t values (0);
ERROR 1030 (HY000): Got error 157 from storage engine
[18 Sep 2006 0:18] Miguel Solorzano
Thank you for the bug report.

miguel@hegel:~/dbs/5.1f> bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.1.12-beta-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database falcon1;
Query OK, 1 row affected (0.00 sec)

mysql> use falcon1;
Database changed
mysql> create table t (s1 int) engine=falcon;
Query OK, 0 rows affected (0.12 sec)

mysql> rename database falcon1 to falcon2;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into t values (0);
ERROR 1030 (HY000): Got error 157 from storage engine
mysql>
[14 Jun 2007 15:33] Jim Starkey
This works nicely with the new Falcon table space scheme.
[14 Jun 2007 20:32] Hakan Küçükyılmaz
falcon_bug_22182.test passes now

Test(s) which will be run though they are marked as disabled:
  falcon_bug_22182     : Bug#22182 2006-08-24 hakank (Get pushbuild green)

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

falcon_bug_22182               [ pass ]            307
-------------------------------------------------------
[15 Jun 2007 8:30] MC Brown
A note has been added to the 6.0.1 changelog.