Bug #94767 On diagram, primary keys which are also foreign keys has lost their icon.

• Submitted: 25 Mar 2019 13:04
• Modified: 25 Mar 2019 21:17
• Reporter: Alexander Chernov
• Status: Verified
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 8.x
• OS: Windows (Microsoft Windows 10 Pro)
• CPU Architecture: Any
• Tags: WBBugReporter

[25 Mar 2019 13:04] Alexander Chernov

Description:
I am getting this result in datagram modelling
https://i.imgur.com/vNVyA6e.png

Notice that foo_id has lost completely it's icon. 
By contrast here how it looks in 6.3.10
https://i.imgur.com/Ki8TwpS.png

How to repeat:

CREATE TABLE IF NOT EXISTS `mydb`.`foo` (
  `id` INT NOT NULL,
  `foo1` VARCHAR(45) NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
CREATE TABLE IF NOT EXISTS `mydb`.`child1` (
  `foo_id` INT NOT NULL,
  PRIMARY KEY (`foo_id`),
  CONSTRAINT `fk_child1_foo`
    FOREIGN KEY (`foo_id`)
    REFERENCES `mydb`.`foo` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
CREATE TABLE IF NOT EXISTS `mydb`.`child2` (
  `foo_id` INT NOT NULL,
  `pk2` INT NOT NULL,
  `col` VARCHAR(45) NULL,
  PRIMARY KEY (`foo_id`, `pk2`),
  INDEX `fk_child2_foo1_idx` (`foo_id` ASC) VISIBLE,
  CONSTRAINT `fk_child2_foo1`
    FOREIGN KEY (`foo_id`)
    REFERENCES `mydb`.`foo` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB

[25 Mar 2019 13:06] Alexander Chernov

test model.

Attachment: test.mwb (application/octet-stream, text), 7.34 KiB.

[25 Mar 2019 21:17] MySQL Verification Team

Thank you for the bug report.