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:Microsoft Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: edit table definition, show no indexes are present, WBBugReporter

[8 Nov 2016 10:08] Hartmut Mehnert
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.
[8 Nov 2016 10:15] Hartmut Mehnert
tab indexes

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

[8 Nov 2016 10:16] Hartmut Mehnert
wb.log

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

[8 Nov 2016 12:15] Chiranjeevi Battula
Hello Hartmut Mehnert,

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

Thanks,
Chiranjeevi
[8 Nov 2016 12:15] Chiranjeevi Battula
Screenshot

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