Bug #51560 foreign key insert on ERR model throws exception

• Submitted: 26 Feb 2010 16:59
• Modified: 4 Apr 2010 13:18
• Reporter: jose juarez
• Status: No Feedback
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 5.2.16 @5249
• OS: Any
• CPU Architecture: Any
• Tags: foreign key insert on ERR model throws exception

[26 Feb 2010 16:59] jose juarez

Description:
Sorry for my english in advance.

Throws this exception:

Exception = System.InvalidOperationException
Message = Error en la operación porque el programa no pudo realizar o anular un cambio de valor de celda.
FullText = System.InvalidOperationException: Error en la operación porque el programa no pudo realizar o anular un cambio de valor de celda.
   en System.Windows.Forms.DataGridView.set_CurrentCell(DataGridViewCell value)
   en System.Windows.Forms.DataGridView.OnClearingColumns()
   en System.Windows.Forms.DataGridViewColumnCollection.Clear()
   en MySQL.Utilities.GridView.ProcessModelChange()
   en MySQL.Grt.Db.RecordsetView.ProcessModelChange()
   en MySQL.Grt.DelegateSlot0<int\,int>.cpp_callback()
   en sigc.pointer_functor0<int>.()(pointer_functor0<int>* )
   en sigc.adaptor_functor<sigc::pointer_functor0<int> >.()(adaptor_functor<sigc::pointer_functor0<int> >* )
   en sigc.internal.slot_call0<sigc::pointer_functor0<int>,int>.call_it(slot_rep* rep)
   en sigc.slot1<void,boost::shared_ptr<Recordset> >.()(slot1<void\,boost::shared_ptr<Recordset> >* , shared_ptr<Recordset>* _A_a1)
   en MySQL.Grt.Db.Recordset.apply_changes()
   en MySQL.Grt.Db.RecordsetView.commitButton_Click(Object sender, EventArgs e)
   en System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   en System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
   en System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   en System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   en System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   en System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   en System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   en System.Windows.Forms.Control.WndProc(Message& m)
   en System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   en System.Windows.Forms.ToolStrip.WndProc(Message& m)
   en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
On a ERR model (innoDB tables with foreign keys) 
- Fill parent table with data (tab 'Inserts' on 'Edit table')
- Then, fill child(foreign keys) table with correct values (tab 'Inserts' on 'Edit table')

Then throws a Exception

[1 Mar 2010 13:18] MySQL Verification Team

Thank you for the bug report. Could you please provide the model file which presents the reported behavior?. Thanks in advance.

[1 Mar 2010 23:09] jose juarez

Sorry for my english in advance.

I am trying to reproduce the error.
I was wrong, the exception is not related to foreign keys,

How to repeat:

- on ERR model create a table with 2 fields (int).
- Then double-click on the table and go to 'tab' named 'Inserts'
- Fill one row, 
   and one of the fields defined as INT try to fill an String ex:'test'.
- Then click on 'Apply changes to data source' =>  Throws an exception

Thanks

[4 Mar 2010 13:18] Susanne Ebrecht

Which server version are you using and are you connection remote server or local server?

[4 Apr 2010 23: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".