Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.3.13, 5.5(EOL), 10.0(EOL), 10.1(EOL)
-
10.1.12
Description
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.