Bug #1995 5.0 fails symlink test
Submitted: 2 Dec 2003 8:12 Modified: 5 Dec 2003 2:37
Reporter: Bill Kearney Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:5.0 OS:Linux (Redhat 9)
Assigned to: CPU Architecture:Any

[2 Dec 2003 8:12] Bill Kearney
Description:
When compiling 5.0 on RH9 it fails the symlink test with this error:

mysql-test-run --local symlink
bash: mysql-test-run: command not found
[root@friday mysql-test]# ./mysql-test-run --local symlink
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb --language=../sql/share/english/
Installing Slave Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --language=../sql/share/english/
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

 TEST                           RESULT
------------------------------------------
symlink                        [ fail ]

Errors are (from /home/downloads/mysql/5.0/mysql-5.0/mysql-test/var/log/mysqltest-time) :
/home/downloads/mysql/5.0/mysql-5.0/client/mysqltest: At line 69: query 'create table t1 (a int not null auto_increment, b char(16) not null, primary key (a)) type=myisam data directory="tmp"' failed with wrong errno 1103 instead of 1279...
/home/downloads/mysql/5.0/mysql-5.0/client/mysqltest: At line 79: query 'create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) type=myisam index directory="not-hard-path"' failed with wrong errno 1103 instead of 1279...
/home/downloads/mysql/5.0/mysql-5.0/client/mysqltest: At line 96: Result length mismatch
(the last line(s) may be the ones that caused the die() in mysqltest)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/symlink.result    2003-11-29 19:31:10.000000000 +0300
--- r/symlink.reject    2003-12-02 16:15:27.000000000 +0300
***************
*** 40,53 ****
    `b` char(16) NOT NULL default '',
    `c` int(11) NOT NULL default '0',
    PRIMARY KEY  (`a`)
! ) TYPE=MyISAM CHARSET=latin1 DATA DIRECTORY='TEST_DIR/var/tmp/' INDEX DIRECTORY='TEST_DIR/var/run/'
  alter table t9 rename t8, add column d int not null;
  alter table t8 rename t7;
  rename table t7 to t9;
  drop table t1;
  Got one of the listed errors
! Got one of the listed errors
! Got one of the listed errors
  Got one of the listed errors
  Got one of the listed errors
  alter table t9 rename mysqltest.t9;
--- 40,53 ----
    `b` char(16) NOT NULL default '',
    `c` int(11) NOT NULL default '0',
    PRIMARY KEY  (`a`)
! ) TYPE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='TEST_DIR/var/tmp/' INDEX DIRECTORY='TEST_DIR/var/run/'
  alter table t9 rename t8, add column d int not null;
  alter table t8 rename t7;
  rename table t7 to t9;
  drop table t1;
+ ERROR 42000: Incorrect table name 'tmp'
  Got one of the listed errors
! ERROR 42000: Incorrect table name 'not-hard-path'
  Got one of the listed errors
  Got one of the listed errors
  alter table t9 rename mysqltest.t9;
***************
*** 62,66 ****
    `c` int(11) NOT NULL default '0',
    `d` int(11) NOT NULL default '0',
    PRIMARY KEY  (`a`)
! ) TYPE=MyISAM CHARSET=latin1 DATA DIRECTORY='TEST_DIR/var/tmp/' INDEX DIRECTORY='TEST_DIR/var/run/'
  drop database mysqltest;
--- 62,66 ----
    `c` int(11) NOT NULL default '0',
    `d` int(11) NOT NULL default '0',
    PRIMARY KEY  (`a`)
! ) TYPE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='TEST_DIR/var/tmp/' INDEX DIRECTORY='TEST_DIR/var/run/'
  drop database mysqltest;
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Aborting: symlink failed. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished

How to repeat:
Perform setup as per website instructions (checking out using bk).  It compiles but fails on the symlink test.

C compiler:    gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
C++ compiler:  g++ (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
[5 Dec 2003 2:37] Alexander Keremidarski
Thank you for your time and effort.

Please when reporting bugs with BitKepper trees alwasy specify ChangeSet

I just tested 5.0 on RH9 and symlink passed (btw. another tests failed)

symlink                        [ pass ]

$ bk changes
ChangeSet@1.1642, 2003-12-05 00:56:28+03:00, konstantin@oak.local
  cleanup

Also note that 5.0 is under constant development and it is normal to have some failures fixed in next couple of changesets. 

I don't want to discourage you reporting bugs. Just give us some time to see and fix such problems which happen often with development-only tree. (No Release is scheduled yet for 5.0)

And always tell us which ChangeSet troubles you.

Best regards
[5 Dec 2003 4:48] Bill Kearney
Sure, it's to be expected that the dev tree will have it's issues.  I'm just reporting it.  As per your request, the changeset info (do you need only the top line?):

ChangeSet@1.1629.1.1, 2003-11-28 00:31:15+03:00, sergefp@mysql.com
  Fix for bug 1974