Bug #93914 dd::Index_impl::m_hidden not included in SDI
Submitted: 14 Jan 2019 11:24 Modified: 12 Feb 2019 19:50
Reporter: Dyre Tjeldvoll Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[14 Jan 2019 11:24] Dyre Tjeldvoll 
Description:
The member variable m_hidden which is true for additional indexes generated by SE is omitted from the SDI json. This makes it hard to identify the actual indices created by the user when looking at the SDI.

How to repeat:
Extract the SDI for an Innodb table (MyISAM tables do not use hidden indexes).

Suggested fix:
Include the m_hidden field in serialize() and deserialize() member functions.
[12 Feb 2019 19:50] Paul DuBois 
Posted by developer:
 
Fixed in 8.0.16.

SDI JSON files did not include the m_hidden field of Index_impl
objects. This made it hard to use the SDI JSON to recreate the CREATE
statement for the table because InnoDB adds a number of hidden
indexes. The SDI JSON now includes the m_hidden field. This changes
SDI format, so the SDI version number was increased to the current
server version number.