Bug #96095 | Primary key ignored when updating unless refreshing query | ||
---|---|---|---|
Submitted: | 4 Jul 2019 20:26 | Modified: | 3 Oct 2019 15:58 |
Reporter: | Bryce Morrison | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Workbench | Severity: | S2 (Serious) |
Version: | 8.0.16 | OS: | Windows |
Assigned to: | CPU Architecture: | Any | |
Tags: | primary key |
[4 Jul 2019 20:26]
Bryce Morrison
[5 Jul 2019 10:06]
MySQL Verification Team
Hello Bryce, Thank you for the report and feedback. I tried to reproduce at my end with dummy test case on Win 10 with WB 8.0.16 build but not seeing any issues. As requested in Bug #93990, please provide repeatable test case. - dummy schema for which I'm not seeing any issues: CREATE DATABASE IF NOT EXISTS test; use test; DROP TABLE IF EXISTS t; CREATE TABLE t ( id INT, id_1 INT, some_text varchar(100), PRIMARY KEY (id, id_1) ) ; INSERT INTO `test`.`t` (`id`, `id_1`, `some_text`) VALUES ('1', '1', 'MySQL1'); INSERT INTO `test`.`t` (`id`, `id_1`, `some_text`) VALUES ('2', '2', 'MySQL2'); INSERT INTO `test`.`t` (`id`, `id_1`, `some_text`) VALUES ('3', '3', 'MySQL3'); Then from WB attempted to update as mentioned in the report but it is working fine. regards, Umesh
[9 Aug 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".
[13 Aug 2019 19:02]
Bryce Morrison
I do not believe that you followed my instructions. Please try to replicate that problem.
[13 Aug 2019 19:07]
Bryce Morrison
To clarify, you only attempted to insert three rows, and forced the key column's value. I suggest trying to edit an existing table's existing values, in a table which as multiple key columns requiring each to be a unique numeric ID. Then make a request to modify a value that is not the key column, such as a text field. After the first attempt is successful, Workbench will appear to refresh the table which is visible. Repeat the procedure, adjusting another value which is not a key column. When Workbench tries to update the table, and provides you with a preview of the commands which are to be executed, notice that after "WHERE", when you would expect to see the TWO OR MORE key column values defined in the command, they are blank. Please read this comment more than once, slowly this time, and do not skip any steps.
[13 Aug 2019 19:11]
Bryce Morrison
I apologize if I'm appearing impatient with this ticket. You've at least made the two key columns in your example, but there's something missing. Try making one of them required, but perhaps not auto-increment.
[14 Aug 2019 9:18]
Simon Vacker
Bryce, Could you provide SQL to create a database and table for which you experience the issue?
[14 Aug 2019 18:00]
Bryce Morrison
I'm sorry, Simon, but I do not have access to that database at this particular moment, but I'm reviewing some of the files that I do have with me that may have been modified at the same time that this ticket (96095) was opened. From what I recall, one of the primary key columns did require an auto increment unique id. The second column which did require it to be a primary key might have also been auto increment, and of almost a matching value to the first primary key column.
[3 Sep 2019 15:58]
MySQL Verification Team
To repeat this issue we need the complete SQL script test case, with just your description we are not able to repeat it. Thanks in advance.
[4 Oct 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".