Bug #8707 failure if CREATE TBL ... DATA DIRECTORY = actual db dir
Submitted: 22 Feb 2005 19:40 Modified: 9 Mar 2005 3:35
Reporter: Martin Friebe (Gold Quality Contributor) (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.10 OS:Any (*)
Assigned to: Jim Winstead

[22 Feb 2005 19: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 10:26] Alexander Barkov
ok to push.
[3 Mar 2005 21:37] Jim Winstead
Pushed, will be in 4.1.11.
[9 Mar 2005 3:35] Paul Dubois
Noted in 4.1.11 changelog.