Bug #13378 Test case 'symlink' fails on Windows

• Submitted: 21 Sep 2005 13:32
• Modified: 20 Oct 2005 19:48
• Reporter: Kent Boortz
• Status: Can't repeat
• Category: MySQL Server: MyISAM storage engine
• Severity: S2 (Serious)
• Version: 5.0.13-pre/5.0.14 BK source
• OS: Windows (Windows)
• Assigned to: Jim Winstead
• CPU Architecture: Any

[21 Sep 2005 13:32] Kent Boortz

Description:
Not sure if the test is supposed to fail because of assumtions in the
test about Unix like behaviour of symbol links. The test case
'symlink' is failing on Windows with

mysqltest: At line 73: query 'create table t1 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam data directory="tmp"' succeeded - should have failed with errno 1103...^M
mysqltest: At line 80: query 'create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam index directory="/this-dir-does-not-exist"' succeeded - should have failed with errno 1...^M
mysqltest: At line 83: query 'create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam index directory="not-hard-path"' failed with wrong errno 1050 instead of 1103...^M
mysqltest: At line 87: query 'create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam index directory="$MYSQL_TEST_DIR/var/run"' failed with wrong errno 1050 instead of 1...^M
mysqltest: At line 91: query 'create table mysqltest.t9 (a int not null auto_increment, b char(16) not null, primary key (a)) engine=myisam data directory="$MYSQL_TEST_DIR/var/tmp"' failed with wrong errno 1050 instead of 1...^M
mysqltest: At line 97: query 'alter table t9 rename mysqltest.t9' failed: 1050: Table 't9' already exists

How to repeat:
Run the 'symlink' test case on Windows

[22 Sep 2005 0:31] MySQL Verification Team

I tested outside of cygwin environment with lates Windows server:

C:\mysql\bin>mysql -uroot dbw
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.14-rc-nt

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

mysql> create table t1 (a int not null auto_increment, b
    -> char(16) not null, primary key (a)) engine=myisam data directory="tmp";
Query OK, 0 rows affected (0.13 sec)

mysql> create table t9 (a int not null
    -> auto_increment, b char(16) not null, primary key (a)) engine=myisam index
    -> directory="/this-dir-does-not-exist";
Query OK, 0 rows affected (0.08 sec)

mysql> create table t9 (a int not null
    -> auto_increment, b char(16) not null, primary key (a)) engine=myisam index
    -> directory="not-hard-path";
ERROR 1050 (42S01): Table 't9' already exists

[20 Oct 2005 19:48] Jim Winstead

i can't repeat this -- the symlink test gets skipped because have_symlink is false, and always should be on windows.