Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9307

DATA/INDEX DIRECTORY are not in information_schema.TABLES

    XMLWordPrintable

Details

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

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            f_razzoli Federico Razzoli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.