Bug #8707 failure if CREATE TBL ... DATA DIRECTORY = actual db dir
Submitted: 22 Feb 2005 20:40 Modified: 9 Mar 2005 4:35
Reporter: Martin Friebe (Gold Quality Contributor) (SCA)
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:4.1.10 OS:Any (*)
Assigned to: Jim Winstead Target Version:

[22 Feb 2005 20:40] Martin Friebe 
Description:
the how to repeat is on freebsd, but should be similiar on any other op system.

creating a table, with data directory option, will give an error, if the alternatly
specified dir points to the location mysql would have used anyway.

How to repeat:
show variables like 'datadir';
+---------------+----------------+
| Variable_name | Value          |
+---------------+----------------+
| datadir       | /var/db/mysql/ |
+---------------+----------------+

use xxx;
create  table dd1 (a int) data directory = '/var/db/mysql/xxx/' select 9 a;
ERROR 25 (HY000): Can't create symlink './xxx/dd1.MYD' pointing at
'/var/db/mysql/xxx/dd1.MYD' (Error 17)

Suggested fix:
-
[24 Feb 2005 11:26] Alexander Barkov 
ok to push.
[3 Mar 2005 22:37] Jim Winstead 
Pushed, will be in 4.1.11.
[9 Mar 2005 4:35] Paul DuBois 
Noted in 4.1.11 changelog.