Bug #51761 main.innodb and innodb.innodb-index fail in embedded mode

• Submitted: 5 Mar 2010 8:29
• Modified: 5 Mar 2010 8:39
• Reporter: Alexander Nozdrin
• Status: Closed
• Category: Tests: Engine
• Severity: S7 (Test Cases)
• Version: Betony (M2), Celosia (M3)
• OS: Any
• CPU Architecture: Any
• Tags: disabled

[5 Mar 2010 8:29] Alexander Nozdrin

Description:
main.innodb and innodb.innodb-index fail in embedded mode.
In other modes the tests pass.

This is a test case issue. The test cases will be disabled
in the embedded server and enabled in the standalone mode.

See also Bug#49396.

How to repeat:
$ ./mtr -embedded innodb
@@ -2672,7 +2672,7 @@
 create table t2 (a varchar(10), foreign key (a) references t1(a)) engine = innodb DEFAULT CHARSET=latin1;
 create table t3(a varchar(10) primary key) engine = innodb DEFAULT CHARSET=utf8;
 rename table t3 to t1;
-ERROR HY000: Error on rename of './test/t3' to './test/t1' (errno: 150)
+ERROR HY000: Error on rename of './mysqld.1/data/test/t3' to './mysqld.1/data/test/t1' (errno: 150)
 set foreign_key_checks=1;
 drop table t2,t3;
 create table t1(a int primary key) row_format=redundant engine=innodb;
@@ -3155,7 +3155,7 @@
 INSERT INTO t2 VALUES (1);
 ALTER TABLE t2 ADD FOREIGN KEY (a) REFERENCES t1 (a) ON DELETE SET NULL;
 ALTER TABLE t2 MODIFY a INT NOT NULL;
-ERROR HY000: Error on rename of '#sql-temporary' to './test/t2' (errno: 150)
+ERROR HY000: Error on rename of '#sql-temporary' to './mysqld.1/data/test/t2' (errno: 150)
 DELETE FROM t1;
 DROP TABLE t2,t1;
 CREATE TABLE t1 (a VARCHAR(5) COLLATE utf8_unicode_ci PRIMARY KEY)

$ ./mtr innodb
main.innodb                              [ pass ]  13035

$ ./mtr --ps-protocol innodb
main.innodb                              [ pass ]  12981

$ ./mtr -embedded innodb-index
@@ -462,7 +462,7 @@
 drop index dc on t4;
 ERROR 42000: Can't DROP 'dc'; check that column/key exists
 alter table t3 drop foreign key dc;
-ERROR HY000: Error on rename of './test/t3' to '#sql2-temporary' (errno: 152)
+ERROR HY000: Error on rename of '/mnt/raid/alik/MySQL/bzr/00.builds/mysql-trunk/mysql-test/var/mysqld.1/data/test/t3' to '/mnt/raid/alik/MySQL/bzr/00.builds/mysql-trunk/mysql-test/var/mysqld.1/data/test/#sql2-69c5-1' (errno: 152)
 alter table t4 drop foreign key dc;
 select * from t2;
 a      b       c       d       e

$ ./mtr innodb-index
innodb.innodb-index                      [ pass ]  13689

$ ./mtr --ps-protocol innodb-index
innodb.innodb-index                      [ pass ]  13651