Bug #75297 ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY

• Submitted: 23 Dec 2014 14:34
• Modified: 24 Dec 2014 5:37
• Reporter: bsr bsr
• Status: Can't repeat
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 5.6.26
• OS: Linux
• CPU Architecture: Any
• Tags: ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY

[23 Dec 2014 14:34] bsr bsr

Description:
in Server version: 5.6.16 Source distribution
mysql> show variables like 'innodb_file_per_table';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| innodb_file_per_table | ON    |
+-----------------------+-------+
1 row in set (0.00 sec)

mysql> create table extend (id int not null)  data directory='/data/mysqldata/test/' ;
ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY

How to repeat:
in Server version: 5.6.16 Source distribution
mysql> show variables like 'innodb_file_per_table';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| innodb_file_per_table | ON    |
+-----------------------+-------+
1 row in set (0.00 sec)

mysql> create table extend (id int not null)  data directory='/data/mysqldata/test/' ;
ERROR 1210 (HY000): Incorrect arguments to DATA DIRECTORY

Suggested fix:
Upgrade to a higher version

[24 Dec 2014 5:37] MySQL Verification Team

Thank you for the report.
I could not repeat this on latest GA release build 5.6.22.
Please note that we do not fix bugs that are not repeatable with current versions and also, version 5.6.16 is old and many bugs were fixed since. Please upgrade to current version 5.6.22, try with it and inform us if problem still exists.

[test]> show variables like '%version%';
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.6.22                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.6.22-log                   |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | Linux                        |
+-------------------------+------------------------------+
7 rows in set (0.00 sec)

Database changed
[test]> show variables like 'innodb_file_per_table';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| innodb_file_per_table | ON    |
+-----------------------+-------+
1 row in set (0.00 sec)

[test]> create table extend (id int not null)  data directory='/tmp/bug' ;
Query OK, 0 rows affected (0.21 sec)

[test]> show create table extend\G
*************************** 1. row ***************************
       Table: extend
Create Table: CREATE TABLE `extend` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='/tmp/bug/'
1 row in set (0.00 sec)

[test]> \! ls -l /tmp/bug/
total 4
drwxrwx--- 2 mysql mysql 4096 Dec 26 11:36 test
[test]> \! ls -l /tmp/bug/test
total 96
-rw-rw---- 1 mysql mysql 98304 Dec 26 11:36 extend.ibd
[test]>

Also, see
http://dev.mysql.com/doc/refman/5.6/en/create-table.html
http://dev.mysql.com/doc/refman/5.6/en/tablespace-placing.html