MySQL Bugs: #27269: MySqlConnection.Clone does not mimic SqlConnection.Clone behaviour

Bug #27269	MySqlConnection.Clone does not mimic SqlConnection.Clone behaviour
Submitted:	19 Mar 2007 19:27	Modified:	26 Mar 2007 8:34
Reporter:	Dani Sardà
Status:	Closed
Category:	Connector/Net	Severity:	S3 (Non-critical)
Version:	5.0.5	OS:	Microsoft Windows (Windows)
Assigned to:		Target Version:

Description:
When cloning a MySqlClient.MySqlConnection; if it has been open and Persist Security
Info=False, the cloned connection is not usable because the StringConnection has lost the
password information.

This is not the case with the SqlClient.SqlConnection or OleDbClient.OleDbConnection.

How to repeat:
Create a connection. (Make sure Persist Security Info is not set to True in the Connection
String)
Open it.
Clone it.
Open the clonned connection

//Create a connection
MySql.Data.MySqlClient.MySqlConnection cnMySql = new
MySql.Data.MySqlClient.MySqlConnection(CS_MY);
//Open it
cnMySql.Open();
//Clone it
ICloneable clMySql = (ICloneable)cnMySql;
MySql.Data.MySqlClient.MySqlConnection cnMySqlClone =
(MySql.Data.MySqlClient.MySqlConnection)clMySql.Clone();
//Open the cloned connection
cnMySqlClone.Open();

Suggested fix:
In the ICloneable.Clone method of MySqlConnection copy the connection string by using the
internal GetConnectionString method rather than using the public ConnectionString
property:

//clone.ConnectionString = this.ConnectionString;
clone.ConnectionString = this.settings.GetConnectionString(true);

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/22693

Fixed in 5.0.7

A note has been added to the 5.0.7 changelog.

Closing bug.