DATA DIRECTORY and INDEX DIRECTORY are not stored in information_schema.TABLES.
MariaDB [_]> CREATE OR REPLACE TABLE test.t (c INT)
|
-> ENGINE MyISAM
|
-> DATA DIRECTORY '/tmp'
|
-> INDEX DIRECTORY '/tmp'
|
-> MIN_ROWS 1000;
|
Query OK, 0 rows affected (0.01 sec)
|
|
MariaDB [_]> SHOW CREATE TABLE test.t;
|
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------+
|
| t | CREATE TABLE `t` (
|
`c` int(11) DEFAULT NULL
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MIN_ROWS=1000 DATA DIRECTORY='/tmp/' INDEX DIRECTORY='/tmp/' |
|
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [_]> SELECT CREATE_OPTIONS FROM information_schema.TABLES
|
-> WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 't';
|
+----------------+
|
| CREATE_OPTIONS |
|
+----------------+
|
| min_rows=1000 |
|
+----------------+
|
1 row in set (0.00 sec)
|
I didn't check previous versions or MySQL.
If this is not a bug, please consider it as a feature request.
Bug
Major
