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:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:Workbench 5.2.31 CE, Revision 7115 OS:Microsoft Windows (7)
Assigned to: CPU Architecture:Any

[13 Feb 2011 13:53] Olivier Olivier
Description:
After creating a model from an existing sql script.Model is created, log doesn't return error.

1) Get message "mysql has encountered a problem" when trying to copy and paste a row in the insert tab.

2) There is no "paste row" command

3) When creating model from a working script which contains several "insert" commands to fill tables, I expected to find those parameters in the insert tab, but the corresponding insert tabs are always empty.

NB : 

How to repeat:
1) Select table/inserts tab, insert one row, one attribute
right click on leaft header/copy row content
Get message "mysql has encountered a problem"
[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] Miguel Solorzano
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] Miguel Solorzano
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] Miguel Solorzano
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.