WL#9570: Extend SHOW statements to list hidden columns and index information.

Affects: Server-8.0   —   Status: Complete

INFORMATION_SCHEMA tables are implemented as a views on the new
data dictionary tables in 8.0. But view definition for
COLUMNS, STATISTICS and KEY_COLUMN_USAGE do not check the hidden
column value from the dictionary tables for columns, indexes and
index elements. Hence hidden columns, indexes and index elements
are displayed by these INFORMATION_SCHEMA tables.

SHOW statements implementation uses the INFORMATION_SCHEMA tables.
So even SHOW statements displays the hidden column, index and
index elements.

The main goal of this WL are to,

  i) show columns, indexes and index element's information
     which are not hidden from the tables of INFORMATION_SCHEMA
     and SHOW statements.

 ii) Extend SHOW statements to list hidden columns and indexes
     and index elements on demand.

User Documentation
==================

* https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-2.html
* https://dev.mysql.com/doc/refman/8.0/en/show-columns.html
* https://dev.mysql.com/doc/refman/8.0/en/show-index.html