| 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: | |
| 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: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".
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!