Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
Starting from mariadb-10.3.10 with commit 54db0be, IS.tables got max_index_length and temporary columns (which currently is a flag for information_schema tables only).
Example:
MariaDB [test]> select * from information_schema.tables where temporary='y'\G |
|
TABLE_CATALOG: def
|
TABLE_SCHEMA: information_schema
|
TABLE_NAME: INNODB_FT_DELETED
|
TABLE_TYPE: SYSTEM VIEW |
ENGINE: MEMORY
|
VERSION: 11
|
ROW_FORMAT: Fixed
|
TABLE_ROWS: NULL |
AVG_ROW_LENGTH: 9
|
DATA_LENGTH: 0
|
MAX_DATA_LENGTH: 9437184
|
INDEX_LENGTH: 0
|
DATA_FREE: 0
|
AUTO_INCREMENT: NULL |
CREATE_TIME: 2020-11-17 21:54:02
|
UPDATE_TIME: NULL |
CHECK_TIME: NULL |
TABLE_COLLATION: utf8_general_ci
|
CHECKSUM: NULL |
CREATE_OPTIONS: max_rows=1864135
|
TABLE_COMMENT:
|
MAX_INDEX_LENGTH: 0
|
TEMPORARY: Y |
|
79 rows in set (0.011 sec) |
|
MariaDB [test]> show create table information_schema.INNODB_FT_DELETED; |
+-------------------+-------------------------------------------------------------------------------------------------------------------------------------+ |
| Table | Create Table | |
+-------------------+-------------------------------------------------------------------------------------------------------------------------------------+ |
| INNODB_FT_DELETED | CREATE TEMPORARY TABLE `INNODB_FT_DELETED` ( |
`DOC_ID` bigint(21) unsigned NOT NULL DEFAULT 0 |
) ENGINE=MEMORY DEFAULT CHARSET=utf8 | |
+-------------------+-------------------------------------------------------------------------------------------------------------------------------------+ |
1 row in set (0.000 sec) |
This should be documented.