Bug #73425 Cannot create a table using a 'select if' statement
Submitted: 29 Jul 2014 12:32 Modified: 29 Aug 2014 12:39
Reporter: Ian Bates Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:6.1 OS:Any
Assigned to: CPU Architecture:Any

[29 Jul 2014 12:32] Ian Bates
Description:
Basically, I am loading locally data from a csv format into a table, joining that imported table with another table, and in the process have been dropping and creating lots of tables and views.  I created a new table as a "select if" updating of the data. Then it crapped out =(.

Stack Trace:

Exception = System.ArgumentOutOfRangeException
Message = Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
FullText = System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at MySQL.Controls.FlatTabControl.ValidateTab(Int32 index)
   at MySQL.Controls.FlatTabControl.DrawControl(Graphics g)
   at MySQL.Controls.FlatTabControl.OnPaint(PaintEventArgs e)
   at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
   at System.Windows.Forms.Control.WmPaint(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.TabControl.WndProc(Message& m)
   at MySQL.Controls.FlatTabControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
1)run a script that loads data from a local csv.
2)"outer left join" on condition to a rather large table.
3)create a new table as a "select if" condition to update some data based on those conditions.
[29 Jul 2014 12:39] MySQL Verification Team
Which exactly version 6.1.X are you using?. Thanks.
[30 Aug 2014 1: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".