Bug #37192 Workbench loses Inserts data II
| Submitted: | 4 Jun 2008 13:29 | Modified: | 10 Jul 2008 15:57 |
|---|---|---|---|
| Reporter: | Bernhard Wellhoefer | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S1 (Critical) |
| Version: | 5.0.22 | OS: | Windows (XP SP2) |
| Assigned to: | Alfredo Kojima | CPU Architecture: | Any |
[4 Jun 2008 13:29]
Bernhard Wellhoefer
[4 Jun 2008 17:05]
MySQL Verification Team
Thank you for the bug report. I could not repeat with a simple table using the 5.0.22SE: INSERT INTO `table1` (`idtable1`, `col2`) VALUES (1, NULL); INSERT INTO `table1` (`idtable1`, `col2`) VALUES (2, NULL); INSERT INTO `table1` (`idtable1`, `col2`) VALUES (3, NULL); values NULL were added for the new added column, could you please provide a test model file ready to add a new INT column and to verify the behavior reported. Thanks in advance. PS: Also I deleted the new column and the inserts were preserved.
[5 Jun 2008 7:02]
Bernhard Wellhoefer
Ok I agree that it is not so easy to reproduce the issue. Here the steps to reproduce it: 1) Create a table, e.g. CREATE TABLE IF NOT EXISTS `broca2`.`table1` ( `idtable1` INT NOT NULL AUTO_INCREMENT , `i` INT NOT NULL , `t` TEXT NOT NULL , PRIMARY KEY (`idtable1`) ) ENGINE = InnoDB 2) Create for the table some Inserts 3) Go to a different table and open for this table the column editor (just to change the focus to another table) 4) Switch back to the test table from step 1 5) Add an INT column to the table from step 1 6) Now the Inserts data are lost.
[5 Jun 2008 20:42]
MySQL Verification Team
Thank you for the feedback. I was able to repeat with the last 'how to repeat' instructions.
[23 Jun 2008 20:06]
Johannes Taxacher
issue is fixed. note that due to recent changes in insert-editor values for newly added columns aren't inserted automatically any longer. this fix will be in 5.0.23
[10 Jul 2008 15:57]
Tony Bedford
An entry has been added to the 5.0.23 changelog: When a new column is added to a table Inserts data gets deleted.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.