| Bug #60116 | Inserts/copy row content | ||
|---|---|---|---|
| Submitted: | 13 Feb 2011 13:53 | Modified: | 16 Nov 2011 4:43 |
| Reporter: | Olivier Olivier | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: Modeling | Severity: | S3 (Non-critical) |
| Version: | Workbench 5.2.31 CE, Revision 7115 | OS: | Windows (7) |
| Assigned to: | CPU Architecture: | Any | |
[13 Feb 2011 13:53]
Olivier Olivier
[13 Feb 2011 13:55]
Olivier Olivier
Add OS
[13 Feb 2011 15:20]
Valeriy Kravchuk
Thank you for the problem report. Please, send the output of Help > System Info menu item. We may also need your .mwb file to demonstrate the problem. And yes, "paste row" is obviously missing in the context menu. That will be a valid feature request to add it...
[13 Feb 2011 15:50]
Olivier Olivier
mwb for test
Attachment: test_insert_copy.mwb (application/octet-stream, text), 6.54 KiB.
[13 Feb 2011 15:52]
Olivier Olivier
system info Info: Time: 16:45:34 Message: db.mysql.plugin.import.sql finished in 12.42s Details: n/a Info: Time: 16:49:26 Message: wb.file.saveModelAs finished in 0.02s Details: n/a ------------------------------------------------------------- MySQL Workbench CE for Windows version 5.2.31 Configuration Directory: C:\Users\ole\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE Cairo Version: 1.8.8 Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering. OpenGL Driver Version: 3.1 NVIDIA 190.24 OS: Microsoft Windows 7 (build 7600), 64-bit CPU: 4x Intel(R) Core(TM) i7 CPU M 640 @ 2.80GHz, 7.7 GiB RAM Active video adapter: NVIDIA GeForce GT 330M Installed video RAM: 1024 MB Current video mode: 1680 x 1050 x 4294967296 couleurs Used bit depth: 32 Driver version: 8.16.11.9024 Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um Current user language: Français (France)
[14 Feb 2011 10:26]
Valeriy Kravchuk
Looks like I still can not repeat this. Please, specify what exact table to open and what data to put in the row before trying to copy it.
[14 Feb 2011 10:52]
Olivier Olivier
got it, the message occurs when at least one column is null.
[14 Feb 2011 12:09]
MySQL Verification Team
I couldn't repeat too.
[14 Feb 2011 12:22]
Olivier Olivier
That's strange, I can't repeat it like that : - Create new table - add two columns (test1, test2, default var45 PK,NN) - goto insert, enter number in idtable1 (so test1 et test2 still null) - right click on pen, copy row content, get error message. Anyway, this is not a big problem. I'm more concerned by the fact that when you build a model from a script file, if this file contains "insert" commands to populate rows, those values do not appear in the "inserts" tab of the table definition as I thank it should be. Is my understanding correct ?
[14 Feb 2011 12:24]
Olivier Olivier
Sorry, read "I can repeat it" and not "I can't". Could it comes because of Windows 7 - x64 machine ?
[14 Feb 2011 13:26]
MySQL Verification Team
Could you please provide the script so we can test too. Thanks in advance.
[14 Feb 2011 13:59]
Olivier Olivier
The script is attached a few comments earlier.
[14 Feb 2011 14:33]
MySQL Verification Team
Thank you for the feedback. Still I can't repeat.
[14 Feb 2011 14:35]
Olivier Olivier
You can't repeat the copy row or the insert problem ?
[2 May 2011 17:50]
Armando Lopez Valencia
Defect Verified, problem with Model, Insert tab not populated will be open in a separate defect. Repro steps: 1. Load model attached in this defect. 2. Create new table 3. Add two columns (test1, test2, default var45 PK,NN) 4. Goto insert, enter number in idtable1 (so test1 et test2 still null) 5. Right click on pen, copy row content, get error message. Expected results: Row content copied. Actual results: Bug popup appears (see attachment 60116.jpg).
[16 Nov 2011 4:43]
Philip Olson
Fixed as of 5.2.36: + The <guimenu>Copy Row Content</guimenu> option would throw an + unexpected exception, from within a model. + </para> + + <para> + In addition, the <guimenu>Paste Row</guimenu> option was added.
