MySQL Bugs: #35501: trouble with many colums per table

Bug #35501	trouble with many colums per table
Submitted:	22 Mar 2008 17:13	Modified:	8 Apr 2008 14:30
Reporter:	Bernhard Hoefling	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	5.0.15	OS:	Windows (xp sp2)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
I loaded my demo-model from last time (id:34249 solved Ver 5.012) which contains 2 tables and many columns and one relation. 

Now (ver 5.015) the relation has disappeared.

When i try to make an additional one, i got a message box "Index out of Range"!

How to repeat:
open the file relation_layout.mwb - no relation

relation disappeared

Attachment: relation_layout.mwb (application/octet-stream, text), 10.39 KiB.

- your model seems corrupted, pls recreate the relationship (open the 
table CMM* table and reset the referenced column in the foreign keys
editor.
- your table doesn't fit the model, go to Model -> Diagram Size
and change the model size so that it is 2 pages high and 1 page wide

If the relationship doesn't appear, save and reopen the model.

- I have deleted the foreign key, then i create a new one and get the message "Index out of Range" - so recreation doesnt work.

- I incresed diagram size to 2x3 pages save and resart - no relation appears

- I export create script
- the the foreign key constraint ist wrong:
  CONSTRAINT `CMM01_GEO02_DLVY_LOC_FK`
    FOREIGN KEY (`DLVY_LOC_ID` )
    REFERENCES `mydb`.`GEO02_LOC` ());
so i corret by hand to:
  CONSTRAINT `CMM01_GEO02_DLVY_LOC_FK`
    FOREIGN KEY (`DLVY_LOC_ID` )
    REFERENCES `mydb`.`GEO02_LOC` (LOC_ID));
and import the tables in a new workbench-dokument with autocreated ER.
here i have the relation.

- I don't want to do so with my 100 tables ER.
- I deinstall 5.0.15 and install 5.0.12 again and the relation appears in the original relation_layout.mwb from case 34249. - so the relation_layout.mwb is not corrupt!

Please, try to repeat with a newer version, 5.0.16-rc, and inform about the results.

I tried 5.0.16. and open relation_layout.mwb
no relation appears.
On table cmm01_contr, I tried to remove the checkbox in the list of column/referenced column (referenced column is empty!)
a window pop's up, with the following content:

Informationen über das Aufrufen von JIT-Debuggen
anstelle dieses Dialogfelds finden Sie am Ende dieser Meldung.

************** Ausnahmetext **************
System.Runtime.InteropServices.SEHException: Eine externe Komponente hat eine Ausnahme ausgelöst.
   bei bec.FKConstraintColumnsListBE.set_column_is_fk(FKConstraintColumnsListBE* , NodeId* , Boolean )
   bei MySQL.Grt.Db.FKConstraintColumnsListBE.set_column_is_fk(NodeId node, Boolean flag)
   bei MySQL.GUI.Workbench.Plugins.DbMysqlTableFkColumnListModel.ValuePushed(Object sender, NodeControlValueEventArgs e)
   bei Aga.Controls.Tree.NodeControls.BindableControl.OnValuePushed(NodeControlValueEventArgs args)
   bei Aga.Controls.Tree.NodeControls.BindableControl.SetValue(TreeNodeAdv node, Object value)
   bei Aga.Controls.Tree.NodeControls.NodeCheckBox.SetCheckState(TreeNodeAdv node, CheckState value)
   bei Aga.Controls.Tree.NodeControls.NodeCheckBox.MouseDown(TreeNodeAdvMouseEventArgs args)
   bei Aga.Controls.Tree.TreeViewAdv.OnMouseDown(MouseEventArgs e)
   bei System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
   bei System.Windows.Forms.Control.WndProc(Message& m)
   bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Geladene Assemblys **************
mscorlib
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
    CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll.
----------------------------------------
MySQLWorkbench
    Assembly-Version: 5.0.16.2874.
    Win32-Version: 5.0.16.2874.
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/MySQLWorkbench.exe.
----------------------------------------
wb.wr
    Assembly-Version: 0.0.0.0.
    Win32-Version: .
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/wb.wr.DLL.
----------------------------------------
grt.wr
    Assembly-Version: 0.0.0.0.
    Win32-Version: .
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/grt.wr.DLL.
----------------------------------------
System.Windows.Forms
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll.
----------------------------------------
System
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll.
----------------------------------------
System.Drawing
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll.
----------------------------------------
MySQLCsUtilities
    Assembly-Version: 1.0.0.0.
    Win32-Version: 1.0.0.0.
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/MySQLCsUtilities.DLL.
----------------------------------------
msvcm80
    Assembly-Version: 8.0.50727.1433.
    Win32-Version: 8.00.50727.1433.
    CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.1433_x-ww_5cf844d2/msvcm80.dll.
----------------------------------------
MySQLGrtShell
    Assembly-Version: 1.0.0.0.
    Win32-Version: 1.0.0.0.
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/MySQLGrtShell.EXE.
----------------------------------------
WeifenLuo.WinFormsUI.Docking
    Assembly-Version: 2.2.3007.11795.
    Win32-Version: 2.2.0.0.
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/WeifenLuo.WinFormsUI.Docking.DLL.
----------------------------------------
System.Xml
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll.
----------------------------------------
mscorlib.resources
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
    CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll.
----------------------------------------
MySQLWorkbenchEditors
    Assembly-Version: 1.0.0.0.
    Win32-Version: 1.0.0.0.
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/MySQLWorkbenchEditors.DLL.
----------------------------------------
Aga.Controls
    Assembly-Version: 1.6.0.0.
    Win32-Version: 1.6.0.0.
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/Aga.Controls.DLL.
----------------------------------------
grt.helpers.be
    Assembly-Version: 1.0.0.0.
    Win32-Version: 1.0.0.0.
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/grt.helpers.be.DLL.
----------------------------------------
System.Windows.Forms.resources
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.1433 (REDBITS.050727-1400).
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_de_b77a5c561934e089/System.Windows.Forms.resources.dll.
----------------------------------------
db.mysql.editors.wbp.fe
    Assembly-Version: 1.0.0.0.
    Win32-Version: 1.0.0.0.
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/db.mysql.editors.wbp.fe.DLL.
----------------------------------------
db.mysql.editors.wbp.wr
    Assembly-Version: 0.0.0.0.
    Win32-Version: .
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/db.mysql.editors.wbp.wr.DLL.
----------------------------------------
grt.db.wr
    Assembly-Version: 0.0.0.0.
    Win32-Version: .
    CodeBase: file:///C:/Programme/MySQL/MySQL%20Workbench%205.0%20OSS/grt.db.wr.DLL.
----------------------------------------

************** JIT-Debuggen **************
Um das JIT-Debuggen (Just-In-Time) zu aktivieren, muss in der
Konfigurationsdatei der Anwendung oder des Computers
(machine.config) der jitDebugging-Wert im Abschnitt system.windows.forms festgelegt werden.
Die Anwendung muss mit aktiviertem Debuggen kompiliert werden.

Zum Beispiel:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

Wenn das JIT-Debuggen aktiviert ist, werden alle nicht behandelten
Ausnahmen an den JIT-Debugger gesendet, der auf dem
Computer registriert ist, und nicht in diesem Dialogfeld behandelt.

The crash is fixed and I've made it possible again to display connections with the referenced
column unset as in 5.0.12. But the uploaded model does lack the referenced column in the FK.
You can see that by opening the model in 5.0.12 and inspecting the FK.

this is fixed now. (tested in SVN Rev 2931) ... even thoug imho it would be better to not display connections that arent properly setup.

A note has been added to the 5.0.17 changelog: 

Opening an existing Workbench model with an invalid foreign key definition would cause an exception.