Description:
The few builds where "embedded" did not crash immediately (bug#19650)
failed in "ps_1general":
-------------------------------------------------------
*** r/ps_1general.result
--- r/ps_1general.reject
***************
*** 539,545
prepare stmt1 from ' rename table t5 to t6, t7 to t8 ' ;
create table t5 (a int) ;
execute stmt1 ;
! ERROR HY000: Can't find file: './test/t7' (errno: 2)
create table t7 (a int) ;
execute stmt1 ;
execute stmt1 ;
--- 539,545
prepare stmt1 from ' rename table t5 to t6, t7 to t8 ' ;
create table t5 (a int) ;
execute stmt1 ;
! ERROR HY000: Can't find file: '/var/tmp/mysqldev/hpux11/test/mysql-5.1.10-beta-hpux11.11-hppa2.' (errno: 2)
create table t7 (a int) ;
execute stmt1 ;
execute stmt1 ;
-------------------------------------------------------
Similar on SCO (different path name).
AIUI, this happens because the error message writes only 64 characters of the path name, so the strings replacement in the test does not apply (string does not match).
Similar effect in test "innodb":
-------------------------------------------------------
*** r/innodb.result
--- r/innodb.reject
***************
*** 2912,2918
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)
set foreign_key_checks=1;
drop table t2,t3;
create table t1(a int primary key) row_format=redundant engine=innodb;
--- 2912,2918
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 '/home/mysqldev/opnsrv6c/test/mysql-5.1.10-beta-sco-osr6-i686/mys' to '/home/mysqldev/opn
srv6c/test/mysql-5.1.10-beta-sco-osr6-i686/mys' (errno: 150)
set foreign_key_checks=1;
drop table t2,t3;
create table t1(a int primary key) row_format=redundant engine=innodb;
-------------------------------------------------------
(here: SCO; hpux11 is corresponding)
How to repeat:
Run the test suite on the "embedded" server.
Suggested fix:
With current path name lengths
and especially with the embedded server reporting the full path name,
a limit of 64 characters in the error message might be inappropriate ?
See the "rename table t1 to t2;" in test "trigger"
which fails with an "Errcode: 13" message (as intended)
but still reports the full name.
