MySQL Bugs: #83740: Workbench 6.3.8 edit table definition show no indexes are present

Bug #83740	Workbench 6.3.8 edit table definition show no indexes are present
Submitted:	8 Nov 2016 10:08	Modified:	8 Nov 2016 12:15
Reporter:	Hartmut Mehnert	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.8	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	edit table definition, show no indexes are present, WBBugReporter

Description:
If i had created a table with indexes sucessful these indexes are not to see if i edit this table with workbench on tab indexes.
With other tools the indexes are to see.

How to repeat:
CREATE TABLE `secucard_salden` (
  `salden_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `trans_id` int(10) unsigned NOT NULL,
  `karten_id` int(10) unsigned NOT NULL,
  `haendler_id` int(10) unsigned NOT NULL,
  `waehrung_id` int(10) unsigned NOT NULL,
  `produkt_id` int(10) unsigned NOT NULL,
  `saldo_produkt` int(10) NOT NULL,
  `saldo_waehrungguthaben` int(10) NOT NULL,
  `vorgaenger_trans_id` int(10) unsigned NOT NULL DEFAULT '0',
  `ausloeser_trans_id` int(10) unsigned DEFAULT NULL,
  `storno` bit(1) NOT NULL DEFAULT b'0',
  `timestamp` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`salden_id`),
  UNIQUE KEY `trans_id` (`trans_id`) USING BTREE,
  KEY `karte_haendler_waehrung` (`karten_id`,`haendler_id`,`waehrung_id`,`produkt_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

Edit this table with workbench:
On tab indexes are the indexes not to see.

tab indexes

Attachment: Workbench Bug no indexes shown indexes.PNG (image/png, text), 24.61 KiB.

wb.log

Attachment: wb.log (application/octet-stream, text), 7.97 KiB.

Hello Hartmut Mehnert,

Thank you for the bug report.
Verified this behavior on MySQL Workbench in 6.3.8 version

Thanks,
Chiranjeevi

Screenshot

Attachment: 83740.JPG (image/jpeg, text), 133.52 KiB.