MySQL Bugs: #83028: When connecting w/ mysql-workbench to a mysql DB, pri/ind/fk keys don't show up

Bug #83028	When connecting w/ mysql-workbench to a mysql DB, pri/ind/fk keys don't show up
Submitted:	16 Sep 2016 22:31	Modified:	19 Oct 2016 16:36
Reporter:	Richard Lyon	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	6.3.6	OS:	Ubuntu (16.04 Ubuntu 32-bit OS)
Assigned to:		CPU Architecture:	Any
Tags:	MySQL, mysql-workbench

Description:
When I reverse engineering my mysql 5.7 tables, which some have indexes and foreign keys, using mysql-workbench 6.3.6 32-bit (OS is 32-bit), the indexes and foreign keys do not show up. The columns with primary keys are shown without keys any more. For example:
transaction_id   int(11)   PK(unchecked)  when it should be checked. I used phpmyadmin tool (web based) and it shows that the indexes and foreign keys are in fact still there. So why would mysql-workbench 6.3.6 32-bit take away indexes/foreign keys/primary key relations?  mysql-workbench just shows the columns without any relationships or primary keys on any tables. That blows my mind.
Then when I reverse engineer what it has of course there will be no relationships showing up in the EER diagram.
mysql-workbench is useless if I cannot depend on it to "SEE" the indexes, foreign keys, and primary keys of my tables. I don't think the reverse engineering tool is to blame as it is only using what it has to start with. It must be the way mysql-workbench connects with mysql that is the problem.
Could you please look into this issue as my work cannot continue with using mysql-workbench as long as this keeps cropping up?
My email is rlyon2000@gmail.com

How to repeat:
It is repeatable every time I connect to the mysql database.
My email is rlyon2000@gmail.com

Suggested fix:
The issue looks like it is with how mysql-workbench connects and communicates with mysql. Any fixes for this?
My email is rlyon2000@gmail.com

My fault. I did not mean that the reverse engineering did not see the indexes and keys. I meant when I connect to the database it does not see the foreign keys, indexes, and primary keys.
The reverse engineering part is not the issue. It will of course not "SEE" the relationships because upon connecting to the mysql database it does not sense them.

Please try version 6.3.7. Thanks.

The latest version of mysql-workbench 6.3.7 is not downloadable as a 32-bit deb package so I cannot use that version to test if this issue persists. I believe the issue would also exist in 6.3.7 32-bit is I did have it installed. Please check on this issue as it should not be in version 6.3.6. Please treat this as important because this would also affect many, many people besides me.
Thanks.

included MySQL tag

Gee, maybe someone should check into why no keys show up when mysql-workbench 6.3.6 (32-bit) connects to a MySLQ 5.7 database. That is the most basic thing that a MySQL tool should be able to do. phpmyadmin tool does this without any issues.
Wow!

According manual:

https://dev.mysql.com/doc/workbench/en/wb-installing-linux.html

Note
32-bit binary builds are not available as of MySQL Workbench 6.2.0. You can use the source code to build your own 32-bit version, as needed.

So please build and test 6.3.7. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".