Bug #68621 Undocumented index type 32

• Submitted: 10 Mar 2013 10:53
• Modified: 28 May 2013 15:05
• Reporter: Daniël van Eeden (OCA)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.6.10
• OS: Any
• Assigned to: Bugs System
• CPU Architecture: Any

[10 Mar 2013 10:53] Daniël van Eeden

Description:
Page: http://dev.mysql.com/doc/refman/5.6/en/innodb-sys-indexes-table.html

TYPE	A numeric identifier signifying the kind of index, in the range 0..3. 

A fulltext index has type 32, this is not in the documented range.

There also should be a table of known index types on the page:
0  Secondary Index
1  GEN_CLUST_INDEX
2  Unique index
3  primary key
32 Fulltext

The description for page_no is also missing.

How to repeat:
Read the docs

mysql [localhost] {msandbox} (test) > select * from information_schema.innodb_sys_indexes where type=32;
+----------+------+----------+------+----------+---------+-------+
| INDEX_ID | NAME | TABLE_ID | TYPE | N_FIELDS | PAGE_NO | SPACE |
+----------+------+----------+------+----------+---------+-------+
|     5184 | t    |     1505 |   32 |        1 |      -1 |  1455 |
+----------+------+----------+------+----------+---------+-------+
1 row in set (0.00 sec)

mysql [localhost] {msandbox} (test) > show create table ftestm4\G               *************************** 1. row ***************************
       Table: ftestm4
Create Table: CREATE TABLE `ftestm4` (
  `t` text,
  FULLTEXT KEY `t` (`t`) /*!50100 WITH PARSER `some_custom_parser` */ 
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql [localhost] {msandbox} (test) > CREATE TABLE `ftestm8` (
    -> `t` text,
    -> FULLTEXT KEY `t` (`t`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    -> ;
Query OK, 0 rows affected (0.07 sec)

mysql [localhost] {msandbox} (test) > select * from information_schema.innodb_sys_indexes where type=32;
+----------+------+----------+------+----------+---------+-------+
| INDEX_ID | NAME | TABLE_ID | TYPE | N_FIELDS | PAGE_NO | SPACE |
+----------+------+----------+------+----------+---------+-------+
|     5184 | t    |     1505 |   32 |        1 |      -1 |  1455 |
|     5201 | t    |     1520 |   32 |        1 |      -1 |  1464 |
+----------+------+----------+------+----------+---------+-------+
2 rows in set (0.00 sec)

Suggested fix:
Update docs.

[10 Mar 2013 10:54] Daniël van Eeden

change title...

[11 Mar 2013 9:50] Erlend Dahl

Thank you for the bug report.

[28 May 2013 15:05] Bugs System

Added index type values and PAGE_NO description to 5.6/5.7 reference manual.

PAGE_NO: "The root page number of the index B-tree. For full-text
indexes, the "PAGE_NO" field is unused and set to -1 ("FIL_NULL") because
the full-text index is laid out in several B-trees (auxiliary tables)."

TYPE: "A numeric identifier signifying the kind of index. 0 = Secondary
Index, 1 = Clustered Index, 2 = Unique Index, 3 = Primary Index, 32 =
Full-text Index."

Thank you for the bug report.