Bug #60700 If connection contains ":", I get exceptions on each select
Submitted: 30 Mar 2011 11:54 Modified: 8 Jun 2011 18:24
Reporter: Eugene Prokopiev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.33 CE OS:Windows (Vista x86, XP)
Assigned to: CPU Architecture:Any
Tags: connection name, workbench

[30 Mar 2011 11:54] Eugene Prokopiev
Description:
Connection name can't contain : symbol (it works well at 5.2.31 version).
If you try to make selects on such connection, you will get exception.

How to repeat:
Add : to connection name, connect, try to select something

Suggested fix:
review changes at connections handler
[30 Mar 2011 12:01] MySQL Verification Team
Thank you for the bug report. Provide a connection name which cause the behavior reported I couldn't repeat with my:local and mylocal: names. Thanks in advance.
[30 Mar 2011 14:01] Eugene Prokopiev
A1: Master,
A1.F: Slave, etc.

All that connections were created at previous versions of workbench. 
Right now, when I create such connection, it's not displayed at "Open Connection  to Start Querying" list, but displayed at "Manage Connections" dialog.
[30 Mar 2011 14:09] Valeriy Kravchuk
On Mac OS X new connection named "F1:master" does not appear in the left list until Workbench restart. But after restart it can be used without any exceptions.
[30 Mar 2011 14:24] Eugene Prokopiev
Yes, connection appear at the list after restart (CO: Master2).
Connect is OK, but exception on select.
[31 Mar 2011 6:01] Valeriy Kravchuk
Verified on 32-bit Windows XP. Stack trace is:

Exception = System.Runtime.InteropServices.SEHException
Message = External component has thrown an exception.
FullText = System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.
   at Db_sql_editor.exec_sql(Db_sql_editor* , basic_string<char\,std::char_traits<char>\,std::allocator<char> >* , shared_ptr<Sql_editor>* , Boolean , Boolean , Boolean )
   at MySQL.GUI.Workbench.Db_sql_editor.exec_sql(String sql, Boolean active_editor, Boolean wrap_with_non_std_delimiter)
   at MySQL.GUI.Workbench.DbSqlEditor.DoExecuteSqlScript(Boolean currentStatementOnly)
   at MySQL.GUI.Workbench.DbSqlEditor.ExecuteSqlScript()
   at MySQL.Grt.RunWrappedDelegate0<void\,void\,MySQL::Grt::DelegateSlot0<void\,void>::ManagedDelegate>.native_callback()
   at sigc.pointer_functor0<void>.()(pointer_functor0<void>* )
   at sigc.adaptor_functor<sigc::pointer_functor0<void> >.()(adaptor_functor<sigc::pointer_functor0<void> >* )
   at sigc.internal.slot_call0<sigc::pointer_functor0<void>,void>.call_it(slot_rep* rep)
   at mforms.ToolBarItem.callback(ToolBarItem* )
   at MySQL.Forms.ToolBarItemImpl.OnItemActivation(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.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)
[5 Apr 2011 20:29] Alfredo Kojima
Marked bug #60611 as duplicate
[7 Apr 2011 17:56] Alfredo Kojima
marked bug #60796 as a duplicate
[12 Apr 2011 1:33] Alfredo Kojima
bug #60824 is a duplicate
[14 Apr 2011 23:35] Alfredo Kojima
bug #60605 is a duplicate
[21 Apr 2011 20:39] Alfredo Kojima
bug #60949 is a duplicate
[14 May 2011 10:11] Valeriy Kravchuk
Bug #60779 was marked as a duplicate of this one.
[17 May 2011 13:41] Alfredo Kojima
bug #61200 is a duplicate
[8 Jun 2011 18:24] Paul DuBois
Noted in 5.2.34 changelog. 

If a conection name contained a ':' character, it did not work.