MySQL Bugs: #94158: Not displaying indexes (list) in Navigator panel, Schemas tab

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:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0.14	OS:	Windows (Windows 10 Pro)
Assigned to:		CPU Architecture:	x86 (i7-4720HQ)
Tags:	indexes, navigator

Description:
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.

Thank you for the bug report. Server MariaDB isn't supported by WorkBench.