Bug #97160 Program Crashes when I try to assign a Foreing Key to table.
Submitted: 9 Oct 2019 14:43 Modified: 10 Nov 2019 11:17
Reporter: Julian Muhlberger Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3.8 build 1228 CE (64bits) OS:Ubuntu (Ubuntu 18.04.3 LTS)
Assigned to: CPU Architecture:x86 (Linux hostname 5.0.0-31-generic #33~18.04.1-Ubuntu SMP Tue Oct 1 10:20:39 UTC 2019 x86_6)
Tags: crash, foreing key

[9 Oct 2019 14:43] Julian Muhlberger
Description:
Almost of the times, when I create a field in a table, and I want to assign it to a Foreing Key restriction, the application crashes. It occurs exactly when I click on the field selection, it is remarked on the attached image.
It happen with all my tables, and sometimes assign a foreing key takes me a lot of tries. But, just In case, this is my table structure...

CREATE TABLE IF NOT EXISTS `estadisticas`.`HL3` (
  `idHL3` INT UNSIGNED NOT NULL,
  `Nombre` VARCHAR(45) NULL,
  `Equipo` INT UNSIGNED NOT NULL,
  `Locacion` INT UNSIGNED NULL,
  `Version` INT UNSIGNED NULL,
  PRIMARY KEY (`idHL3`, `Equipo`),
  INDEX `fk_HL3_3_idx` (`Equipo` ASC),
  CONSTRAINT `fk_HL3_3`
    FOREIGN KEY (`Equipo`)
    REFERENCES `estadisticas`.`Equipo` (`idEquipo`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB

The fields that I want to design as foraing key are:   
`Locacion` INT UNSIGNED NULL
`Version` INT UNSIGNED NULL

How to repeat:
1) create a field INT UNSIGNED in a table
2) go to Foreing Key tab
3) add new foreign key
4) select the table where the primary key is
5) on the right "foreing key Columns" list, select the field created at step 1.
6) app crashes!
[9 Oct 2019 14:45] Julian Muhlberger
Output of the application running with debuglevel3

Attachment: workbench stdout report (application/octet-stream, text), 107.86 KiB.

[9 Oct 2019 14:45] Julian Muhlberger
workbench version

Attachment: Captura de pantalla de 2019-10-09 11-33-38.png (image/png, text), 23.34 KiB.

[9 Oct 2019 14:46] Julian Muhlberger
foreing key assignation

Attachment: Captura de pantalla de 2019-10-09 11-28-12.png (image/png, text), 28.92 KiB.

[10 Oct 2019 11:17] MySQL Verification Team
Thank you for the bug report. Please try version 8.0.17. Thanks.
[11 Nov 2019 1:00] Bugs System
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".