Bug #94158 Not displaying indexes (list) in Navigator panel, Schemas tab
Submitted: 31 Jan 2019 19:36 Modified: 1 Feb 2019 8:13
Reporter: Kevin Harrison Email Updates:
Status: Unsupported Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.14 OS:Microsoft Windows (Windows 10 Pro)
Assigned to: CPU Architecture:x86 (i7-4720HQ)
Tags: indexes, navigator

[31 Jan 2019 19:36] Kevin Harrison
After upgrading from MySQL Workbench 6.2 to 8.0.14 GA, the list of indexes for a table, normally displayed in the Navigator, Schemas, database, under each table does not list any indexes.

However, if you select a table, and use the tool (spanner) to get the table details, the indexes are all shown in the Indexes tab.

Using MariaDB 10.1.39.

How to repeat:
Open MySQL Workbench.  Open a database connection.
In the Navigation panel, in the Schemas tab, select a database (schema), then select a table.  Use the Arrow to expand the table to get the list of table references.  An arrow to expand exists for Columns, Foreign Keys, and Triggers.  No arrow to expand and view the list of Indexes.

To view the indexes for a table you have to use the tool (spanner) icon next to the table in the schemas list to get the table definition details and select the indexes tab.

Suggested fix:
If there are indexes for a table, list them in the index list for the table in the Navigation panel, Schemas tab, for a selected schema, and a selected table.  There is a place for it.  Populate the list.
[1 Feb 2019 8:13] MySQL Verification Team
Thank you for the bug report. Server MariaDB isn't supported by WorkBench.