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)
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.10
• OS: Any (*)
• Assigned to: Jim Winstead
• CPU Architecture: Any

[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.